leo
/
LAPP_GAAS_GFrame_BACKEND
2
2
Fork 0
Code Issues 0 Pull Requests 0 Projects 0 Releases 0 Wiki Activity
GAAS GFrame项目web后台
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1203 Commits
15 Branches
7.4 MiB
Branch: develop
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'develop'
${ noResults }
LAPP_GAAS_GFrame_BACKEND/web/models/daymodel_model.go

215 lines
9.7 KiB
Raw Permalink Normal View History

iris 版本升级v12 2021/3/12 v1.21.3.12
4 years ago
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
 
  1. package models
  2. 

  3. import (
  4. 	"LAPP_GAAS_GFrame_BACKEND/db"
  5. 	"LAPP_GAAS_GFrame_BACKEND/utils"
  6. 	"errors"
  7. 	"fmt"
  8. 	"xorm.io/core"
  9. )
  10. 

  11. //日模型

  12. type Daymodel struct {
  13. 	Finr       int    `xorm:"pk comment('工厂号') Int" json:"daymodel-finr"`
  14. 	Daymodelid int    `xorm:"pk comment('日模型ID') Int" json:"daymodel-daymodelid"`
  15. 	Descr      string `xorm:"comment('描述') VARCHAR(30)" json:"daymodel-descr"`
  16. 	Abrev      string `xorm:"comment('简写') VARCHAR(8)" json:"daymodel-abrev"`
  17. 	Color      string `xorm:"comment('颜色') VARCHAR(8)" json:"daymodel-color"`
  18. 	S1Activ    int    `xorm:"comment('激活班次1') INT" json:"daymodel-s1_activ"`
  19. 	S2Activ    int    `xorm:"comment('激活班次2') INT" json:"daymodel-s2_activ"`
  20. 	S3Activ    int    `xorm:"comment('激活班次3') INT" json:"daymodel-s3_activ"`
  21. 	S4Activ    int    `xorm:"comment('激活班次4') INT" json:"daymodel-s4_activ"`
  22. 	S1Beg      string `xorm:"comment('班次1开始') VARCHAR(5)" json:"daymodel-s1_beg"`
  23. 	S1End      string `xorm:"comment('班次1结束') VARCHAR(5)" json:"daymodel-s1_end"`
  24. 	S1Len      int    `xorm:"comment('班次1长度') INT" json:"daymodel-s1_len"`
  25. 	S2Beg      string `xorm:"comment('班次2开始') VARCHAR(5)" json:"daymodel-s2_beg"`
  26. 	S2End      string `xorm:"comment('班次2结束') VARCHAR(5)" json:"daymodel-s2_end"`
  27. 	S2Len      int    `xorm:"comment('班次2长度') VARCHAR(5)" json:"daymodel-s2_len"`
  28. 	S3Beg      string `xorm:"comment('班次3开始') VARCHAR(5)" json:"daymodel-s3_beg"`
  29. 	S3End      string `xorm:"comment('班次3结束') VARCHAR(5)" json:"daymodel-s3_end"`
  30. 	S3Len      int    `xorm:"comment('班次3长度') VARCHAR(5)" json:"daymodel-s3_len"`
  31. 	S4Beg      string `xorm:"comment('班次4开始') VARCHAR(5)" json:"daymodel-s4_beg"`
  32. 	S4End      string `xorm:"comment('班次4结束') VARCHAR(5)" json:"daymodel-s4_end"`
  33. 	S4Len      int    `xorm:"comment('班次4长度') INT" json:"daymodel-s4_len"`
  34. 	DmLen      int    `xorm:"comment('Dm长度') INT" json:"daymodel-dm_len"`
  35. 	S1B1Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s1_b1_beg"`
  36. 	S1B1End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s1_b1_end"`
  37. 	S1B2Beg    string `xorm:"comment('中断2开始') VARCHAR(5)" json:"daymodel-s1_b2_beg"`
  38. 	S1B2End    string `xorm:"comment('中断2结束') VARCHAR(5)" json:"daymodel-s1_b2_end"`
  39. 	S1B3Beg    string `xorm:"comment('中断3开始') VARCHAR(5)" json:"daymodel-s1_b3_beg"`
  40. 	S1B3End    string `xorm:"comment('中断3结束') VARCHAR(5)" json:"daymodel-s1_b3_end"`
  41. 	S1B4Beg    string `xorm:"comment('中断4开始') VARCHAR(5)" json:"daymodel-s1_b4_beg"`
  42. 	S1B4End    string `xorm:"comment('中断4结束') VARCHAR(5)" json:"daymodel-s1_b4_end"`
  43. 	S1B5Beg    string `xorm:"comment('中断5开始') VARCHAR(5)" json:"daymodel-s1_b5_beg"`
  44. 	S1B5End    string `xorm:"comment('中断5结束') VARCHAR(5)" json:"daymodel-s1_b5_end"`
  45. 	S2B1Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s2_b1_beg"`
  46. 	S2B1End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s2_b1_end"`
  47. 	S2B2Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s2_b2_beg"`
  48. 	S2B2End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s2_b2_end"`
  49. 	S2B3Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s2_b3_beg"`
  50. 	S2B3End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s2_b3_end"`
  51. 	S2B4Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s2_b4_beg"`
  52. 	S2B4End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s2_b4_end"`
  53. 	S2B5Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s2_b5_beg"`
  54. 	S2B5End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s2_b5_end"`
  55. 	S3B1Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s3_b1_beg"`
  56. 	S3B1End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s3_b1_end"`
  57. 	S3B2Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s3_b2_beg"`
  58. 	S3B2End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s3_b2_end"`
  59. 	S3B3Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s3_b3_beg"`
  60. 	S3B3End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s3_b3_end"`
  61. 	S3B4Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s3_b4_beg"`
  62. 	S3B4End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s3_b4_end"`
  63. 	S3B5Beg    string `xorm:"comment('中断1开始') VARCHAR(5)" json:"daymodel-s3_b5_beg"`
  64. 	S3B5End    string `xorm:"comment('中断1结束') VARCHAR(5)" json:"daymodel-s3_b5_end"`
  65. 	Lastmodif  string `xorm:"comment('最近一次更改时间') VARCHAR(14)" json:"daymodel-lastmodif"`
  66. 	Lastuser   string `xorm:"comment('最近一次更改人') VARCHAR(20)" json:"daymodel-lastuser"`
  67. 	Credatuz   string `xorm:"comment('创建时间') VARCHAR(14)" json:"daymodel-credatuz"`
  68. }
  69. 

  70. func (t *Daymodel) TableName() string {
  71. 	return "daymodel"
  72. }
  73. 

  74. // 清除string字段的右侧空格

  75. func (t *Daymodel) Clipped() {
  76. 	utils.TrimStruct(t, *t)
  77. }
  78. 

  79. //增

  80. func (t *Daymodel) Add() error {
  81. 	e := db.Eloquent.Master()
  82. 	countrole := new(Daymodel)
  83. 	affw, err := e.Table("daymodel").ID(core.PK{t.Finr, t.Daymodelid}).Count(countrole)
  84. 	if err != nil {
  85. 		return err
  86. 	}
  87. 	if affw > 0 {
  88. 		return errors.New("数据已经存在！")
  89. 	}
  90. 	t.S1Len, _ = utils.Timelen(t.S1End, t.S1Beg)
  91. 	t.S2Len, _ = utils.Timelen(t.S2End, t.S2Beg)
  92. 	t.S3Len, _ = utils.Timelen(t.S3End, t.S3Beg)
  93. 

  94. 	s1_b1_len, _ := utils.Timelen(t.S1B1End, t.S1B1Beg)
  95. 	s1_b2_len, _ := utils.Timelen(t.S1B2End, t.S1B2Beg)
  96. 	s1_b3_len, _ := utils.Timelen(t.S1B3End, t.S1B3Beg)
  97. 	s1_b4_len, _ := utils.Timelen(t.S1B4End, t.S1B4Beg)
  98. 	s1_b5_len, _ := utils.Timelen(t.S1B5End, t.S1B5Beg)
  99. 

  100. 	s2_b1_len, _ := utils.Timelen(t.S2B1End, t.S2B1Beg)
  101. 	s2_b2_len, _ := utils.Timelen(t.S2B2End, t.S2B2Beg)
  102. 	s2_b3_len, _ := utils.Timelen(t.S2B3End, t.S2B3Beg)
  103. 	s2_b4_len, _ := utils.Timelen(t.S2B4End, t.S2B4Beg)
  104. 	s2_b5_len, _ := utils.Timelen(t.S2B5End, t.S2B5Beg)
  105. 

  106. 	s3_b1_len, _ := utils.Timelen(t.S3B1End, t.S3B1Beg)
  107. 	s3_b2_len, _ := utils.Timelen(t.S3B2End, t.S3B2Beg)
  108. 	s3_b3_len, _ := utils.Timelen(t.S3B3End, t.S3B3Beg)
  109. 	s3_b4_len, _ := utils.Timelen(t.S3B4End, t.S3B4Beg)
  110. 	s3_b5_len, _ := utils.Timelen(t.S3B5End, t.S3B5Beg)
  111. 

  112. 	t.DmLen = (t.S1Len - s1_b1_len - s1_b2_len - s1_b3_len - s1_b4_len - s1_b5_len) + (t.S2Len - s2_b1_len - s2_b2_len - s2_b3_len - s2_b4_len - s2_b5_len) + (t.S3Len - s3_b1_len - s3_b2_len - s3_b3_len - s3_b4_len - s3_b5_len)
  113. 	_, err = e.Table("daymodel").Insert(t)
  114. 	if err != nil {
  115. 		fmt.Printf("err is :%v", err)
  116. 		return err
  117. 	}
  118. 	return nil
  119. }
  120. 

  121. //删

  122. func (t *Daymodel) Del() bool {
  123. 	e := db.Eloquent.Master()
  124. 	_, err := e.ID(core.PK{t.Finr, t.Daymodelid}).Delete(&Daymodel{})
  125. 	if err != nil {
  126. 		return false
  127. 	}
  128. 	return true
  129. }
  130. 

  131. //改

  132. func (t *Daymodel) Update() bool {
  133. 	e := db.Eloquent.Master()
  134. 

  135. 	t.S1Len, _ = utils.Timelen(t.S1End, t.S1Beg)
  136. 	t.S2Len, _ = utils.Timelen(t.S2End, t.S2Beg)
  137. 	t.S3Len, _ = utils.Timelen(t.S3End, t.S3Beg)
  138. 

  139. 	s1_b1_len, _ := utils.Timelen(t.S1B1End, t.S1B1Beg)
  140. 	s1_b2_len, _ := utils.Timelen(t.S1B2End, t.S1B2Beg)
  141. 	s1_b3_len, _ := utils.Timelen(t.S1B3End, t.S1B3Beg)
  142. 	s1_b4_len, _ := utils.Timelen(t.S1B4End, t.S1B4Beg)
  143. 	s1_b5_len, _ := utils.Timelen(t.S1B5End, t.S1B5Beg)
  144. 

  145. 	s2_b1_len, _ := utils.Timelen(t.S2B1End, t.S2B1Beg)
  146. 	s2_b2_len, _ := utils.Timelen(t.S2B2End, t.S2B2Beg)
  147. 	s2_b3_len, _ := utils.Timelen(t.S2B3End, t.S2B3Beg)
  148. 	s2_b4_len, _ := utils.Timelen(t.S2B4End, t.S2B4Beg)
  149. 	s2_b5_len, _ := utils.Timelen(t.S2B5End, t.S2B5Beg)
  150. 

  151. 	s3_b1_len, _ := utils.Timelen(t.S3B1End, t.S3B1Beg)
  152. 	s3_b2_len, _ := utils.Timelen(t.S3B2End, t.S3B2Beg)
  153. 	s3_b3_len, _ := utils.Timelen(t.S3B3End, t.S3B3Beg)
  154. 	s3_b4_len, _ := utils.Timelen(t.S3B4End, t.S3B4Beg)
  155. 	s3_b5_len, _ := utils.Timelen(t.S3B5End, t.S3B5Beg)
  156. 

  157. 	t.DmLen = (t.S1Len - s1_b1_len - s1_b2_len - s1_b3_len - s1_b4_len - s1_b5_len) + (t.S2Len - s2_b1_len - s2_b2_len - s2_b3_len - s2_b4_len - s2_b5_len) + (t.S3Len - s3_b1_len - s3_b2_len - s3_b3_len - s3_b4_len - s3_b5_len)
  158. 

  159. 	_, err := e.ID(core.PK{t.Finr, t.Daymodelid}).Update(t)
  160. 	if err != nil {
  161. 		return false
  162. 	}
  163. 	return true
  164. }
  165. 

  166. //查

  167. func (t *Daymodel) SelectOne() (Daymodel, error) {
  168. 	e := db.Eloquent.Master()
  169. 	var data Daymodel
  170. 	_, err := e.ID(core.PK{t.Finr, t.Daymodelid}).Get(&data)
  171. 	if err != nil {
  172. 		return data, err
  173. 	}
  174. 	return data, nil
  175. }
  176. 

  177. //分页

  178. func (t *Daymodel) GetPage(pageSize int, pageIndex int) ([]Daymodel, int, error) {
  179. 	data := make([]Daymodel, 0)
  180. 	e := db.Eloquent.Master()
  181. 	table := e.Table("daymodel").Where("finr = ? ", t.Finr)
  182. 	where := "where finr = " + "'" + utils.ValueToString(t.Finr, "") + "'"
  183. 	if t.Daymodelid > 0 {
  184. 		table = table.And("daymodelid = ?", t.Daymodelid)
  185. 		where += " and daymodelid = " + "'" + utils.ValueToString(t.Daymodelid, "") + "'"
  186. 	}
  187. 	Offset := (pageIndex - 1) * pageSize
  188. 	err := e.SQL("SELECT TOP " + utils.ValueToString(pageSize, "") + " daymodel.* FROM daymodel " + where + " AND (convert(varchar(10),finr)+convert(varchar(40),daymodelid) NOT IN (SELECT TOP " + utils.ValueToString(Offset, "") + " convert(varchar(10),finr)+convert(varchar(40),daymodelid) FROM daymodel " + where + " ORDER BY credatuz DESC)) ORDER BY credatuz DESC").Find(&data)
  189. 	pcount := new(Daymodel)
  190. 	count, err := table.Count(pcount)
  191. 	if err != nil {
  192. 		return data, 0, err
  193. 	}
  194. 	for k, _ := range data {
  195. 		data[k].Clipped()
  196. 	}
  197. 	return data, int(count), nil
  198. }
  199. 

  200. type DayModelData struct {
  201. 	Daymodelid int    `json:"daymodelid"`
  202. 	Descr      string `json:"descr"`
  203. 	Abrev      string `json:"abrev"`
  204. 	Color      string `json:"color"`
  205. }
  206. 

  207. func (t *Daymodel) SelectArr() ([]DayModelData, error) {
  208. 	e := db.Eloquent.Master()
  209. 	var data []DayModelData
  210. 	err := e.Table("daymodel").Where("finr = ?", t.Finr).Find(&data)
  211. 	if err != nil {
  212. 		return data, err
  213. 	}
  214. 	return data, nil
  215. }