/// <summary> /// 出库 /// </summary> /// <param name="da"></param> /// <param name="state"></param> /// <returns></returns> public bool signOfStorage(DataTable da, CodeSanEntity.ControlStoEntity _entity) { if (da != null && da.Rows.Count > 0) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); CodeSanEntity.StoEntity _model = new CodeSanEntity.StoEntity( ); //13 样品 14 返工类别 --其它出库 if (_entity.Type.Equals("13") || _entity.Type.Equals("14")) { CodeSanEntity.JSKLIA _modelTre = new CodeSanEntity.JSKLIA( ); CodeSanEntity.JSKLIB _modelFor = new CodeSanEntity.JSKLIB( ); LIALIB(da, SQLString, strSql, _modelTre, _modelFor, _entity.User, _entity.Type, _model); } //15 销货 else if (_entity.Type.Equals("15")) { CodeSanEntity.JSKKEA _modelOne = new CodeSanEntity.JSKKEA( ); CodeSanEntity.JSKKEB _modelTwo = new CodeSanEntity.JSKKEB( ); KEAKEB(da, SQLString, strSql, _modelOne, _modelTwo, _entity.User, _entity.Type, _model); } else { return(false); } return(SqlHelper.ExecuteSqlTran(SQLString)); } else { return(false); } }
public SmobilerFormSto( ) : base( ) { //This call is required by the SmobilerForm. InitializeComponent( ); this.labelTitle.Text = Utils.BaseColumn.storage; model = new CodeSanEntity.StoEntity( ); _bll = new CodeSanBll.Bll.ScanBll( ); }
/// <summary> /// 编辑条码记录表状态 /// </summary> /// <param name="SQLString"></param> /// <param name="strSql"></param> /// <returns></returns> string EditHDTBAR(StringBuilder strSql, CodeSanEntity.StoEntity _model) { strSql = new StringBuilder( ); strSql.Append("UPDATE HDTBAR SET "); strSql.Append("BAR013='T',"); strSql.Append("BAR016='F',"); strSql.AppendFormat("BAR010='{0}',", _model.BAR010); strSql.AppendFormat("BAR009='{0}',", _model.BAR009); strSql.AppendFormat("BAR015='{0}',", DateTime.Now); strSql.AppendFormat("BAR020='{0}'", _model.BAR020); strSql.AppendFormat(" WHERE BAR008='{0}'", _model.BAR008); return(strSql.ToString( )); }
/// <summary> /// 扫描 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnScan_Press(object sender, EventArgs e) { try { SmobilerFormSto form = new SmobilerFormSto { model = model }; Form.Show(form, (MobileForm sender1, object args) => { if (form.ShowResult == ShowResult.Yes) { model = form.model; Bind( ); } }); } catch (Exception ex) { Toast(ex.Message); } }
void LIALIB(DataTable dt, ArrayList SQLString, StringBuilder strSql, CodeSanEntity.JSKLIA _modelTre, CodeSanEntity.JSKLIB _modelFor, string personNum, string orderType, CodeSanEntity.StoEntity _model) { SQLString.Clear( ); _modelTre.LIA001 = _model.BAR010 = storageOfOddNumJSKLIA( ); _modelTre.LIA002 = "条码"; _modelTre.LIA003 = DateTime.Now.ToString("yyyyMMdd"); _modelTre.LIA004 = orderType; _modelTre.LIA005 = personNum; _modelTre.LIA012 = "F"; DataTable da = GetDataTableJSKLIA(personNum); if (da != null && da.Rows.Count > 0) { _modelTre.LIA016 = da.Rows[0]["DBA005"].ToString( ); } else { _modelTre.LIA016 = string.Empty; } SQLString.Add(IsertJSKLIA(_modelTre, strSql)); _modelFor.LIB001 = _modelTre.LIA001; List <string> strList = new List <string> ( ); for (int i = 0; i < dt.Rows.Count; i++) { _model.BAR009 = dt.Rows[i]["IBB001"].ToString( ); _model.BAR008 = dt.Rows[i]["BAR008"].ToString( ); _model.BAR020 = string.IsNullOrEmpty(dt.Rows[i]["BAR020"].ToString( )) == true ? 0 : Convert.ToInt32(dt.Rows[i]["BAR020"].ToString( )); _model.BAR020 += getCkNum(_model.BAR008); SQLString.Add(EditHDTBAR(strSql, _model)); } string[] fileNames = { "BAR001", "BAR007" }; DataTable ds = distinct(dt, fileNames); for (int k = 0; k < ds.Rows.Count; k++) { _modelFor.LIB003 = ds.Rows[k]["BAR001"].ToString( ); //if (!string.IsNullOrEmpty(dt.Select("BAR001='" + _modelFor.LIB003 + "'").Length.ToString())) // _modelFor.LIB008 = dt.Select("BAR001='" + _modelFor.LIB003 + "'").Length; //else // _modelFor.LIB008 = 0; _modelFor.LIB008 = string.IsNullOrEmpty(dt.Rows[k]["BAR020"].ToString( )) == true ? 0 : Convert.ToInt32(dt.Rows[k]["BAR020"].ToString( )); if (strList.Count < 1) { _modelFor.LIB002 = "001"; } else { _modelFor.LIB002 = maxStrList(strList).ToString( ); if (Convert.ToInt32(_modelFor.LIB002) < 9) { _modelFor.LIB002 = "00" + (Convert.ToInt32(_modelFor.LIB002) + 1).ToString( ); } else if (Convert.ToInt32(_modelFor.LIB002) >= 9 && Convert.ToInt32(_modelFor.LIB002) < 99) { _modelFor.LIB002 = "0" + (Convert.ToInt32(_modelFor.LIB002) + 1).ToString( ); } else { _modelFor.LIB002 = (Convert.ToInt32(_modelFor.LIB002) + 1).ToString( ); } } strList.Add(_modelFor.LIB002); DataTable de = GetDataTableJSKLIB(_modelFor.LIB003); if (de != null && de.Rows.Count > 0) { _modelFor.LIB004 = de.Rows[0]["DEA002"].ToString( ); _modelFor.LIB005 = de.Rows[0]["DEA003"].ToString( ); _modelFor.LIB006 = de.Rows[0]["DEA008"].ToString( ); _modelFor.LIB024 = de.Rows[0]["DEA057"].ToString( ); _modelFor.LIB960 = de.Rows[0]["BAR007"].ToString( ); _modelFor.LIB980 = Math.Round(acreage(de.Rows[0]["DEA057"].ToString( )) * _modelFor.LIB008, 2); _modelFor.LIB961 = de.Rows[0]["DEA961"].ToString( ); _modelFor.LIB019 = de.Rows[0]["BAR007"].ToString( ); //_modelFor.LIB008 = string.IsNullOrEmpty(de.Rows[0]["COUN"].ToString()) == true ? 0 : Convert.ToInt32(de.Rows[0]["COUN"].ToString()); } else { _modelFor.LIB004 = string.Empty; _modelFor.LIB005 = string.Empty; _modelFor.LIB006 = string.Empty; _modelFor.LIB024 = string.Empty; _modelFor.LIB960 = string.Empty; _modelFor.LIB980 = 0; _modelFor.LIB961 = string.Empty; _modelFor.LIB019 = string.Empty; //_modelFor.LIB008 = 0; } _modelFor.LIB007 = -1; _modelFor.LIB011 = "F"; _modelFor.LIB020 = 1; _modelFor.LIB021 = 1; _modelFor.LIB022 = _modelFor.LIB005; _modelFor.LIB023 = _modelFor.LIB008; SQLString.Add(IsertJSKLIB(_modelFor, strSql)); } }
void KEAKEB(DataTable dt, ArrayList SQLString, StringBuilder strSql, CodeSanEntity.JSKKEA _modelOne, CodeSanEntity.JSKKEB _modelTwo, string personNum, string orderType, CodeSanEntity.StoEntity _model) { try { SQLString.Clear( ); DataTable da, de; int num = 0; List <string> strCount = new List <string> ( ); List <string> strList = new List <string> ( ); for (int i = 0; i < dt.Rows.Count; i++) { num = 0; _model.BAR009 = dt.Rows[i]["IBB001"].ToString( ).Trim( ); if (i == 0) { strCount.Add(_model.BAR009); _modelOne.KEA001 = _model.BAR010 = storageOfOddNum( ); } else { if (!strCount.Contains(_model.BAR009)) { _modelOne.KEA001 = _model.BAR010 = (Convert.ToInt64(_modelOne.KEA001) + 1).ToString( ); strCount.Add(_model.BAR009); } } _model.BAR008 = dt.Rows[i]["BAR008"].ToString( ); _model.BAR020 = string.IsNullOrEmpty(dt.Rows[i]["BAR020"].ToString( )) == true ? 0 : Convert.ToInt32(dt.Rows[i]["BAR020"].ToString( )); num = Convert.ToInt32(_model.BAR020); _model.BAR020 += getCkNum(_model.BAR008); _modelOne.KEA002 = "条码"; _modelOne.KEA003 = DateTime.Now.ToString("yyyyMMdd"); da = GetDataTableJSKKEA(_model.BAR009); if (da != null && da.Rows.Count > 0) { _modelOne.KEA004 = da.Rows[0]["IBA004"].ToString( ); _modelOne.KEA005 = da.Rows[0]["DFA001"].ToString( ); _modelOne.KEA006 = ""; _modelOne.KEA007 = da.Rows[0]["IBA006"].ToString( ); _modelOne.KEA008 = "RMB"; _modelOne.KEA040 = "F"; } else { _modelOne.KEA004 = string.Empty; _modelOne.KEA005 = string.Empty; _modelOne.KEA006 = string.Empty; _modelOne.KEA007 = string.Empty; _modelOne.KEA008 = string.Empty; _modelOne.KEA040 = string.Empty; } string str = InsertJSKKEA(_modelOne, strSql); if (SQLString.Count < 1) { SQLString.Add(str); } else { if (!SQLString.Contains(str)) { SQLString.Add(str); } } str = ""; str = EditHDTBAR(strSql, _model); if (SQLString.Count < 1) { SQLString.Add(str); } else { if (!SQLString.Contains(str)) { SQLString.Add(str); } } _modelTwo.KEB001 = _modelOne.KEA001; de = GetDataTableJSKKEB(_model.BAR009, _model.BAR008); if (de != null && de.Rows.Count > 0) { for (int k = 0; k < de.Rows.Count; k++) { if (strList.Count < 1) { _modelTwo.KEB002 = "001"; } else { _modelTwo.KEB002 = maxStrList(strList).ToString( ); if (Convert.ToInt32(_modelTwo.KEB002) < 9) { _modelTwo.KEB002 = "00" + (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString( ); } else if (Convert.ToInt32(_modelTwo.KEB002) >= 9 && Convert.ToInt32(_modelTwo.KEB002) < 99) { _modelTwo.KEB002 = "0" + (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString( ); } else { _modelTwo.KEB002 = (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString( ); } } strList.Add(_modelTwo.KEB002); _modelTwo.KEB003 = de.Rows[k]["IBB003"].ToString( ); _modelTwo.KEB004 = de.Rows[k]["IBB004"].ToString( ); _modelTwo.KEB005 = de.Rows[k]["IBB005"].ToString( ); _modelTwo.KEB006 = de.Rows[k]["DEA008"].ToString( ); //_modelTwo.KEB007 = string.IsNullOrEmpty(de.Rows[k]["IBB006"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB006"].ToString()); _modelTwo.KEB037 = _modelTwo.KEB007 = num; _modelTwo.KEB009 = string.IsNullOrEmpty(de.Rows[k]["IBB008"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB008"].ToString( )); _modelTwo.KEB010 = string.IsNullOrEmpty(de.Rows[k]["IBB009"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB009"].ToString( )); _modelTwo.KEB011 = string.IsNullOrEmpty(de.Rows[k]["IBB010"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB010"].ToString( )); _modelTwo.KEB012 = string.IsNullOrEmpty(de.Rows[k]["IBB011"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB011"].ToString( )); _modelTwo.KEB013 = de.Rows[k]["IBB012"].ToString( ); _modelTwo.KEB015 = "32"; _modelTwo.KEB016 = dt.Rows[i]["IBB001"].ToString( ); _modelTwo.KEB017 = de.Rows[k]["IBB002"].ToString( ); _modelTwo.KEB019 = string.IsNullOrEmpty(de.Rows[k]["IBB021"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB021"].ToString( )); _modelTwo.KEB020 = string.IsNullOrEmpty(de.Rows[k]["IBB022"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB022"].ToString( )); _modelTwo.KEB021 = "F"; _modelTwo.KEB029 = string.IsNullOrEmpty(de.Rows[k]["IBB031"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB031"].ToString( )); _modelTwo.KEB030 = string.IsNullOrEmpty(de.Rows[k]["IBB032"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB032"].ToString( )); _modelTwo.KEB031 = string.IsNullOrEmpty(de.Rows[k]["IBB033"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB033"].ToString( )); _modelTwo.KEB034 = 1; _modelTwo.KEB035 = 1; _modelTwo.KEB036 = de.Rows[k]["IBB038"].ToString( ); //_modelTwo.KEB037 = string.IsNullOrEmpty(de.Rows[k]["IBB039"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB039"].ToString()); _modelTwo.KEB039 = string.IsNullOrEmpty(de.Rows[k]["IBB040"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB040"].ToString( )); _modelTwo.KEB040 = de.Rows[k]["IBB041"].ToString( ); _modelTwo.KEB041 = de.Rows[k]["BAR007"].ToString( ); _modelTwo.KEB960 = de.Rows[k]["BAR007"].ToString( ); _modelTwo.KEB980 = Math.Round(acreage(de.Rows[k]["DEA057"].ToString( )) * _modelTwo.KEB007, 2); _modelTwo.KEB961 = de.Rows[k]["DEA961"].ToString( ); str = ""; str = IsertJSKKEB(_modelTwo, strSql); if (SQLString.Count < 1) { SQLString.Add(str); } else { if (!SQLString.Contains(str)) { SQLString.Add(str); } } } } else { if (strList.Count < 1) { _modelTwo.KEB002 = "001"; } else { _modelTwo.KEB002 = maxStrList(strList).ToString( ); if (Convert.ToInt32(_modelTwo.KEB002) < 9) { _modelTwo.KEB002 = "00" + (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString( ); } else if (Convert.ToInt32(_modelTwo.KEB002) >= 9 && Convert.ToInt32(_modelTwo.KEB002) < 99) { _modelTwo.KEB002 = "0" + (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString( ); } else { _modelTwo.KEB002 = (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString( ); } } strList.Add(_modelTwo.KEB002); _modelTwo.KEB003 = string.Empty; _modelTwo.KEB004 = string.Empty; _modelTwo.KEB005 = string.Empty; _modelTwo.KEB006 = string.Empty; _modelTwo.KEB007 = 0; _modelTwo.KEB009 = 0; _modelTwo.KEB010 = 0; _modelTwo.KEB011 = 0; _modelTwo.KEB012 = 0; _modelTwo.KEB013 = string.Empty; _modelTwo.KEB015 = "32"; _modelTwo.KEB016 = string.Empty; _modelTwo.KEB017 = string.Empty; _modelTwo.KEB019 = 0; _modelTwo.KEB020 = 0; _modelTwo.KEB021 = "F"; _modelTwo.KEB029 = 0; _modelTwo.KEB030 = 0; _modelTwo.KEB031 = 0; _modelTwo.KEB034 = 1; _modelTwo.KEB035 = 1; _modelTwo.KEB036 = string.Empty; _modelTwo.KEB037 = 0; _modelTwo.KEB039 = 0; _modelTwo.KEB040 = string.Empty; _modelTwo.KEB960 = string.Empty; _modelTwo.KEB980 = 0; _modelTwo.KEB961 = string.Empty; str = ""; str = IsertJSKKEB(_modelTwo, strSql); if (SQLString.Count < 1) { SQLString.Add(str); } else { if (!SQLString.Contains(str)) { SQLString.Add(str); } } } } } catch (Exception ex) { throw new Exception(ex.Message + "\n\r" + ex.StackTrace); } }