Special_Reset.cs 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using UAS_MES_NEW.DataOperate;
  10. using UAS_MES_NEW.Entity;
  11. using UAS_MES_NEW.PublicMethod;
  12. namespace UAS_MES_NEW.Special
  13. {
  14. public partial class Special_Reset : Form
  15. {
  16. DataHelper dh;
  17. LogStringBuilder sql = new LogStringBuilder();
  18. AutoSizeFormClass asc = new AutoSizeFormClass();
  19. DataTable Dbfind;
  20. DataTable dt;
  21. ExcelHandler eh;
  22. List<String> sb = new List<string>();
  23. public Special_Reset()
  24. {
  25. InitializeComponent();
  26. }
  27. private void Special_BoxSplit_Load(object sender, EventArgs e)
  28. {
  29. eh = new ExcelHandler();
  30. dh = SystemInf.dh;
  31. asc.controllInitializeSize(this);
  32. cd_stepcode.FormName = Name;
  33. cd_stepcode.TableName = "craftdetail left join step on st_code=cd_stepcode left join craft on cd_crid=cr_id";
  34. cd_stepcode.SetValueField = new string[] { "cd_stepcode", "cd_stepno" };
  35. cd_stepcode.SelectField = "cd_stepname # 工序名称 ,cd_stepcode # 工序编号,cd_stepno # 执行顺序";
  36. cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "' and cr_prodcode='" + ms_prodcode.Text + "' order by cd_stepno";
  37. cd_stepcode.DBTitle = "回流工序";
  38. cd_stepcode.DbChange += Cd_stepcode_DbChange;
  39. }
  40. private void Cd_stepcode_DbChange(object sender, EventArgs e)
  41. {
  42. Dbfind = cd_stepcode.ReturnData;
  43. BaseUtil.SetFormValue(this.Controls, Dbfind);
  44. }
  45. private void ReSN(string sncode, string stepcode)
  46. {
  47. string stname = dh.getFieldDataByCondition("step", "st_name", "st_code = '" + stepcode + "'").ToString();
  48. dh.ExecuteSql("update makeserial set ms_status=1,ms_outboxcode='',ms_nextstepcode= '"+ stepcode + "' where ms_sncode='" + sncode + "'", "update");
  49. dh.ExecuteSql("delete makebad where mb_sncode = '" + sncode + "' and mb_status = 0", "delete");
  50. if (checkBox1.Checked)
  51. {
  52. dh.ExecuteSql("update makeserial set ms_mac='',ms_bt='',ms_beforesn='' where ms_sncode='" + sncode + "'", "update");
  53. dh.ExecuteSql("delete MAKESNRELATION where sn = '" + sncode + "'", "delete");
  54. dh.ExecuteSql("delete sninfo where si_sn = '" + sncode + "'", "delete");
  55. }
  56. sql.Clear();
  57. sql.Append("update craftmaterial set cm_status=-1,cm_lastdeco=-1,cm_dropman='" + User.UserCode + "',");
  58. sql.Append("cm_dropdate =sysdate,CM_REMARK = '重置站点拆解',cm_dropstep='" + User.CurrentStepCode + "',");
  59. sql.Append("cm_dropsccode='" + User.UserSourceCode + "' where cm_sncode = '" + sncode + "' and cm_stepcode in (select cd_stepcode from craftdetail left join step on st_code=cd_stepcode left join craft on cd_crid=cr_id where ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "' and cr_prodcode='" + ms_prodcode.Text + "' and cd_detno >=" + cd_stepno.Text + " )");
  60. dh.ExecuteSql(sql.GetString(), "update");
  61. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "站点重置", "站点重置至" + stname, sncode, "");
  62. }
  63. private void Split_Click(object sender, EventArgs e)
  64. {
  65. if (sb.Count == 0|| cd_stepcode.Text == "")
  66. {
  67. OperatResult.AppendText(">>采集数与回流工位不能为空\n", Color.Red);
  68. return;
  69. }
  70. string Delete = MessageBox.Show(this.ParentForm, "是否确认重置站点?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  71. if (Delete == "Yes")
  72. {
  73. if (serBtn.Checked)
  74. {
  75. for (int i = 0; i < sb.Count; i++)
  76. {
  77. ReSN(sb[i].ToString(), cd_stepcode.Text);
  78. OperatResult.AppendText("SN:" + sb[i].ToString()+ "回流至"+ cd_stepcode.Text + "完成\n", Color.Green);
  79. }
  80. WeighRecord.Clear();
  81. sb.Clear();
  82. }
  83. else if(bigboxBtn.Checked)
  84. {
  85. string stname = dh.getFieldDataByCondition("step", "st_name", "st_code = '" + cd_stepcode.Text + "'").ToString();
  86. for (int i = 0; i < sb.Count; i++)
  87. {
  88. DataTable dt2 = (DataTable)dh.ExecuteSql("select ms_sncode from makeserial where ms_outboxcode = '" + sb[i].ToString() + "'", "select");
  89. for (int k = 0; k < dt2.Rows.Count; k++)
  90. {
  91. ReSN(dt2.Rows[k]["ms_sncode"].ToString(), cd_stepcode.Text);
  92. }
  93. dh.ExecuteSql("insert into PACKAGEBACKUP select * from package where pa_outboxcode='" + sb[i].ToString() + "'", "insert");
  94. dh.ExecuteSql("insert into PACKAGEBACKUPDETAIL select * from packagedetail where pd_outboxcode='" + sb[i].ToString() + "'", "insert");
  95. dh.ExecuteSql("delete from package where pa_outboxcode = '" + sb[i].ToString() + "'", "delete");
  96. //删除箱的明细
  97. dh.ExecuteSql("delete from packagedetail where pd_outboxcode='" + sb[i].ToString() + "'", "delete");
  98. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "站点重置", "站点重置至" + stname, sb[i].ToString(), "");
  99. OperatResult.AppendText("卡通箱:" + sb[i].ToString() + "回流至" + cd_stepcode.Text + "完成\n", Color.Green);
  100. }
  101. WeighRecord.Clear();
  102. sb.Clear();
  103. }
  104. sql.Clear();
  105. sql.Append("MERGE INTO makecraftdetail USING (select mcd_macode,mcd_detno,mcd_stepcode,mcd_stepname,nvl(count(distinct A.ms_sncode),0) n,nvl(count(distinct B.ms_sncode),0) bn,(select nvl(count(distinct sp_sncode),0) from STEPPASSED where SP_MAKECODE = mcd_macode AND SP_STEPCODE = mcd_stepcode) inqty from MAKECRAFTdetail");
  106. sql.Append(" left join makeserial A on mcd_macode = A.ms_makecode and mcd_stepcode = A.ms_nextstepcode AND A.MS_STATUS = 1 LEFT JOIN MAKESERIAL B ON mcd_macode = B.ms_makecode AND MCD_STEPCODE = B.MS_STEPCODE AND B.MS_STATUS = 3 where mcd_macode = '"+ ms_makecode.Text + "' group by mcd_macode,mcd_detno, mcd_stepcode, mcd_stepname order by mcd_detno asc) A");
  107. sql.Append(" ON (makecraftdetail.MCD_MACODE = A.MCD_MACODE and makecraftdetail.mcd_stepcode = A.mcd_stepcode) ");
  108. sql.Append(" WHEN MATCHED THEN UPDATE SET makecraftdetail.mcd_inqty = A.inqty,makecraftdetail.mcd_outqty = A.inqty,makecraftdetail.mcd_okqty = A.inqty ");
  109. dh.ExecuteSql(sql.GetString(), "update");
  110. }
  111. }
  112. private void bigboxBtn_Click(object sender, EventArgs e)
  113. {
  114. if (((RadioButton)sender).Checked == true)
  115. {
  116. if (WeighRecord.Items.Count > 0)
  117. {
  118. string logout_confirm = MessageBox.Show(this.ParentForm, "是否更换采集项(已录入信息会清空)?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  119. if (logout_confirm == "Yes")
  120. {
  121. WeighRecord.Items.Clear();
  122. sb.Clear();
  123. ms_makecode.Text = "";
  124. ms_prodcode.Text = "";
  125. cr_code.Text = "";
  126. cd_stepcode.Text = "";
  127. }
  128. else
  129. {
  130. serBtn.Checked = bigboxBtn.Checked;
  131. bigboxBtn.Checked = !serBtn.Checked;
  132. }
  133. }
  134. if (((RadioButton)sender).Name == "serBtn")
  135. {
  136. input.Focus();
  137. OperatResult.AppendText("请输入序列号进行采集\n", Color.Black, input);
  138. }
  139. else if (((RadioButton)sender).Name == "bigboxBtn")
  140. {
  141. input.Focus();
  142. OperatResult.AppendText("请输入箱号进行采集\n", Color.Black, input);
  143. }
  144. }
  145. }
  146. private void cr_code_TextChanged(object sender, EventArgs e)
  147. {
  148. cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "' and cr_prodcode='" + ms_prodcode.Text + "' order by cd_stepno";
  149. }
  150. private void input_KeyDown(object sender, KeyEventArgs e)
  151. {
  152. if (e.KeyCode == Keys.Enter)
  153. {
  154. if (serBtn.Checked)
  155. {
  156. dt = (DataTable)dh.ExecuteSql("select ms_makecode,ms_prodcode,ms_sncode,ms_craftcode cr_code,ms_status,ms_outboxcode from makeserial where ms_sncode = '" + input.Text + "'", "select");
  157. if (dt.Rows.Count > 0)
  158. {
  159. if (ms_makecode.Text != "" && dt.Rows[0]["ms_makecode"].ToString() != ms_makecode.Text)
  160. {
  161. OperatResult.AppendText("SN:" + input.Text + "所属工单" + dt.Rows[0]["ms_makecode"].ToString() + "与当前工单" + ms_makecode.Text + "不一致\n", Color.Red, input);
  162. return;
  163. }
  164. if (dt.Rows[0]["ms_status"].ToString() == "3")
  165. {
  166. OperatResult.AppendText("SN:" + input.Text + "为不良品,不允许采集\n", Color.Red, input);
  167. return;
  168. }
  169. if (dt.Rows[0]["ms_outboxcode"].ToString() != "")
  170. {
  171. OperatResult.AppendText("SN:" + input.Text + "已装箱" + dt.Rows[0]["ms_outboxcode"].ToString() + ",不允许采集\n", Color.Red, input);
  172. return;
  173. }
  174. BaseUtil.SetFormValue(this.Controls, dt);
  175. if (sb.Contains(dt.Rows[0]["ms_sncode"].ToString()))
  176. {
  177. OperatResult.AppendText("SN:" + input.Text + "已采集\n", Color.Red, input);
  178. return;
  179. }
  180. WeighRecord.Items.Add(dt.Rows[0]["ms_sncode"].ToString());
  181. sb.Add(dt.Rows[0]["ms_sncode"].ToString());
  182. OperatResult.AppendText("SN:" + input.Text + "采集\n", Color.Green, input);
  183. cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "' and cr_prodcode='" + ms_prodcode.Text + "' order by cd_stepno";
  184. }
  185. else
  186. {
  187. OperatResult.AppendText("SN:" + input.Text + "不存在\n", Color.Red, input);
  188. return;
  189. }
  190. }
  191. else if (bigboxBtn.Checked)
  192. {
  193. dt = (DataTable)dh.ExecuteSql("select pa_makecode ms_makecode,pa_prodcode ms_prodcode,pa_outboxcode,pa_mothercode,ma_craftcode cr_code from package left join make on pa_makecode = ma_code where pa_outboxcode = '"+input.Text+"' and pa_type = '1'", "select");
  194. if (dt.Rows.Count > 0)
  195. {
  196. if (ms_makecode.Text != "" && dt.Rows[0]["ms_makecode"].ToString() != ms_makecode.Text)
  197. {
  198. OperatResult.AppendText("SN:" + input.Text + "所属工单" + dt.Rows[0]["ms_makecode"].ToString() + "与当前工单" + ms_makecode.Text + "不一致\n", Color.Red, input);
  199. return;
  200. }
  201. if (dt.Rows[0]["pa_mothercode"].ToString() != "")
  202. {
  203. OperatResult.AppendText("卡通箱:" + input.Text + "已装栈板" + dt.Rows[0]["pa_mothercode"].ToString() + ",不允许采集\n", Color.Red, input);
  204. return;
  205. }
  206. BaseUtil.SetFormValue(this.Controls, dt);
  207. if (sb.Contains(dt.Rows[0]["pa_outboxcode"].ToString()))
  208. {
  209. OperatResult.AppendText("卡通箱:" + input.Text + "已采集\n", Color.Red, input);
  210. return;
  211. }
  212. WeighRecord.Items.Add(dt.Rows[0]["pa_outboxcode"].ToString());
  213. sb.Add(dt.Rows[0]["pa_outboxcode"].ToString());
  214. OperatResult.AppendText("卡通箱:" + input.Text + "采集\n", Color.Green, input);
  215. cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "' and cr_prodcode='" + ms_prodcode.Text + "' order by cd_stepno";
  216. }
  217. else
  218. {
  219. OperatResult.AppendText("卡通箱:" + input.Text + "不存在\n", Color.Red, input);
  220. return;
  221. }
  222. }
  223. }
  224. }
  225. private void 数据清空_Click(object sender, EventArgs e)
  226. {
  227. BaseUtil.CleanControls(this.Controls);
  228. WeighRecord.Items.Clear();
  229. sb.Clear();
  230. }
  231. private void excelim_Click(object sender, EventArgs e)
  232. {
  233. DialogResult result = openFileDialog1.ShowDialog();
  234. if (result == DialogResult.OK)
  235. {
  236. DataTable ddtt;
  237. ddtt = eh.ImportExcel(openFileDialog1.FileName, "test");
  238. if (ddtt.Rows.Count > 0)
  239. {
  240. for (int i = 0; i < ddtt.Rows.Count; i++)
  241. {
  242. input.Text = ddtt.Rows[i][0].ToString();
  243. input_KeyDown(sender, new KeyEventArgs(Keys.Enter));
  244. }
  245. }
  246. }
  247. }
  248. }
  249. }