/// <summary> /// exists this year and month /// </summary> /// <param name="year"></param> /// <param name="month"></param> /// <returns></returns> bool Exists(MulaolaoLibrary.CustomerInspectionTableDMEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT COUNT(1) FROM R_PQDM "); strSql.AppendFormat("WHERE DM001={0} AND DM004={1} AND DM002='{2}' AND DM003='{3}'", model.DM001, model.DM004, model.DM002, model.DM003); return(SqlHelper.Exists(strSql.ToString( ))); }
void editdm009(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerInspectionTableDMEntity model) { strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQDM SET "); strSql.AppendFormat("DM009={0} ", model.DM009); strSql.AppendFormat("WHERE DM001={0} AND DM004={1} AND DM002='{2}' AND DM003='{3}'", model.DM001, model.DM004, model.DM002, model.DM003); SQLString.Add(strSql, null); }
void adddm005(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerInspectionTableDMEntity model) { strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQDM ("); strSql.Append("DM001,DM002,DM003,DM004,DM005,DM006,DM007,DM008,DM009) "); strSql.Append("VALUES ("); strSql.AppendFormat("{0},'{1}','{2}',{3},{4},{5},{6},{7},{8})", model.DM001, model.DM002, model.DM003, model.DM004, model.DM005, model.DM006, model.DM007, model.DM008, model.DM009); SQLString.Add(strSql, null); }
public FormCustomerInspectionTable( ) { InitializeComponent( ); _dm = new MulaolaoLibrary.CustomerInspectionTableDMEntity( ); _bll = new MulaolaoBll.Bll.CustomerInspectionTableBll( ); GridViewMoHuSelect.SetFilter(gridView1); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 }); MulaolaoBll.UserInfoMation.tableName = this.Name; toolDelete.Enabled = true; }
/// <summary> /// read data from r_293 to view /// </summary> /// <param name="year"></param> /// <returns></returns> public bool Read(int year) { //398 //出货批次=直通批次+二次通过+条件接受 Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("DELETE FROM R_PQDM WHERE DM001='{0}'", year); SQLString.Add(strSql, null); if (SQLString.Count > 0 && SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); MulaolaoLibrary.CustomerInspectionTableDMEntity model = new MulaolaoLibrary.CustomerInspectionTableDMEntity( ); model.DM001 = year; //怡人 出货批次 DataTable da = getTableCount(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM005 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); if (model.DM004 > 0) { if (Exists(model)) { editdm005(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } if (SQLString.Count > 0 && SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); //班组合计 出货批次 da = getTableCountAll(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM005 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); if (model.DM004 > 0) { if (Exists(model)) { editdm005(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } } } if (SQLString.Count > 0 && SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); // 怡人 通过 da = getTableOneCount(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM006 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); model.DM005 = 0; model.DM007 = 0; model.DM008 = 0; model.DM009 = 0; if (Exists(model)) { editdm006(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } } if (SQLString.Count > 0 && SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); //班组合计 通过 da = getTableOneCountAll(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM006 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); model.DM005 = 0; model.DM007 = 0; model.DM008 = 0; model.DM009 = 0; if (Exists(model)) { editdm006(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); //怡人 二次通过 da = getTableThanOneCount(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM007 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); model.DM005 = 0; model.DM006 = 0; model.DM008 = 0; model.DM009 = 0; if (Exists(model)) { editdm007(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); //班组合计 二次通过 da = getTableThanOneCountAll(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM007 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); model.DM005 = 0; model.DM006 = 0; model.DM008 = 0; model.DM009 = 0; if (Exists(model)) { editdm007(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); //怡人 退货 da = getTableThCount(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM008 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); model.DM005 = 0; model.DM006 = 0; model.DM007 = 0; model.DM009 = 0; if (Exists(model)) { editdm008(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); //班组合计 退货 da = getTableThCountAll(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM008 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); model.DM005 = 0; model.DM006 = 0; model.DM007 = 0; model.DM009 = 0; if (Exists(model)) { editdm008(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); //怡人 条件接收 da = getTableTjCount(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM009 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); model.DM005 = 0; model.DM006 = 0; model.DM007 = 0; model.DM008 = 0; if (Exists(model)) { editdm009(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); //班组合计 条件接收 da = getTableTjCountAll(year); if (da != null && da.Rows.Count > 0) { for (int i = 0; i < da.Rows.Count; i++) { model.DM002 = da.Rows [i] ["DK007"].ToString( ); model.DM003 = da.Rows [i] ["DK008"].ToString( ); model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( )); model.DM009 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( )); model.DM005 = 0; model.DM006 = 0; model.DM007 = 0; model.DM008 = 0; if (Exists(model)) { editdm009(SQLString, strSql, model); } else { adddm005(SQLString, strSql, model); } } } } return(SqlHelper.ExecuteSqlTran(SQLString)); } } else { return(false); } return(true); }