private void btn_Click(object sender, EventArgs e) { SiftingDataEntity.MainEntity model = new SiftingDataEntity.MainEntity( ); state = btn.Text; if (state.Equals("审核")) { model.DEL014 = true; } else { model.DEL014 = false; } model.DEL011 = txtRAA001.Text; result = _bll.Examine(model); if (result) { XtraMessageBox.Show(state + "成功"); //if ( state . Equals ( "审核" ) ) // btn . Text = "反审核"; //else if ( state . Equals ( "反审核" ) ) // btn . Text = "审核"; examine(state); } else { XtraMessageBox.Show(state + "失败"); } }
void Edits(Hashtable SQLString, StringBuilder strSql, SiftingDataEntity.MainEntity model) { strSql = new StringBuilder( ); strSql.Append("update JIFMAI set "); strSql.Append("MAI001=@MAI001,"); strSql.Append("MAI002=@MAI002,"); strSql.Append("MAI003=@MAI003,"); strSql.Append("MAI004=@MAI004 "); //strSql . Append ( "MAI005=@MAI005 " ); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@MAI001", SqlDbType.Date, 3), new SqlParameter("@MAI002", SqlDbType.NVarChar, 50), new SqlParameter("@MAI003", SqlDbType.NVarChar, 50), new SqlParameter("@MAI004", SqlDbType.Int, 4), //new SqlParameter("@MAI005", SqlDbType.NVarChar,200), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.MAI001; parameters [1].Value = model.MAI002; parameters [2].Value = model.MAI003; parameters [3].Value = model.MAI004; //parameters [ 4 ] . Value = model . MAI005; parameters [4].Value = model.idx; SQLString.Add(strSql, parameters); }
void EditIbb(Hashtable SQLString, SiftingDataEntity.MainEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("UPDATE DCSIBB SET IBB965='{0}' WHERE IBB001='{1}' AND IBB002='{2}'", model.DEL015, model.DEL017, model.DEL018); SQLString.Add(strSql, null); }
/// <summary> /// 保存 /// </summary> /// <param name="table"></param> /// <param name="oderNum"></param> /// <returns></returns> public bool Save(DataTable table, string oderNum, string remark) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); SiftingDataEntity.MainEntity model = new SiftingDataEntity.MainEntity( ); model.DEL013 = remark; for (int i = 0; i < table.Rows.Count; i++) { model.DEL011 = oderNum; model.DEL001 = table.Rows [i] ["DEL001"].ToString( ); model.DEL002 = table.Rows [i] ["DEL002"].ToString( ); model.DEL003 = table.Rows [i] ["DEL003"].ToString( ); model.DEL004 = table.Rows [i] ["DEL004"].ToString( ); model.DEL005 = table.Rows [i] ["DEL005"].ToString( ); model.DEL006 = table.Rows [i] ["DEL006"].ToString( ); model.DEL007 = string.IsNullOrEmpty(table.Rows [i] ["DEL007"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["DEL007"].ToString( )); model.DEL008 = string.IsNullOrEmpty(table.Rows [i] ["DEL008"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["DEL008"].ToString( )); model.DEL009 = string.IsNullOrEmpty(table.Rows [i] ["DEL009"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["DEL009"].ToString( )); model.DEL010 = table.Rows [i] ["DEL010"].ToString( ); /* string . IsNullOrEmpty ( table . Rows [ i ] [ "DEL010" ] . ToString ( ) ) == true ? 0 : Convert . ToDecimal ( table . Rows [ i ] [ "DEL010" ] . ToString ( ) );*/ model.DEL012 = table.Rows [i] ["DEL012"].ToString( ); Add(SQLString, strSql, model); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
public FormMain( ) { InitializeComponent( ); _bll = new SiftingDataBll.Bll.MainBll( ); model = new SiftingDataEntity.MainEntity( ); dtNow = _bll.getTimeNow( ).ToString("yyyyMMdd"); barManager1.Items.Remove(toolExport); gridView1.OptionsBehavior.Editable = false; partTable = _bll.getTablePartNum( ); partNum.DataSource = partTable; partNum.DisplayMember = "MAI002"; partNum.ValueMember = "MAI002"; DataTable table = _bll.getTableInfo( ); txtMAI002.Properties.DataSource = table.DefaultView.ToTable(true, "MAI002"); txtMAI002.Properties.DisplayMember = "MAI002"; txtMAI003.Properties.DataSource = table.DefaultView.ToTable(true, "MAI003"); txtMAI003.Properties.DisplayMember = "MAI003"; GridViewMoHuSelect.SetFilter(repositoryItemGridLookUpEdit1View); }
void Delete(Hashtable SQLString, StringBuilder strSql, SiftingDataEntity.MainEntity model) { strSql = new StringBuilder( ); strSql.Append("delete from JIFMAI "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.idx; SQLString.Add(strSql, parameters); }
void Edit(Hashtable SQLString, StringBuilder strSql, SiftingDataEntity.MainEntity model) { strSql = new StringBuilder( ); strSql.Append("update QIXDEL set "); strSql.Append("DEL001=@DEL001,"); strSql.Append("DEL002=@DEL002,"); strSql.Append("DEL003=@DEL003,"); strSql.Append("DEL004=@DEL004,"); strSql.Append("DEL005=@DEL005,"); strSql.Append("DEL006=@DEL006,"); strSql.Append("DEL007=@DEL007,"); strSql.Append("DEL008=@DEL008,"); strSql.Append("DEL009=@DEL009,"); strSql.Append("DEL010=@DEL010,"); strSql.Append("DEL011=@DEL011,"); strSql.Append("DEL012=@DEL012,"); strSql.Append("DEL013=@DEL013 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@DEL001", SqlDbType.NVarChar, 50), new SqlParameter("@DEL002", SqlDbType.NVarChar, 50), new SqlParameter("@DEL003", SqlDbType.NVarChar, 50), new SqlParameter("@DEL004", SqlDbType.NVarChar, 50), new SqlParameter("@DEL005", SqlDbType.NVarChar, 50), new SqlParameter("@DEL006", SqlDbType.NVarChar, 50), new SqlParameter("@DEL007", SqlDbType.Decimal, 9), new SqlParameter("@DEL008", SqlDbType.Decimal, 9), new SqlParameter("@DEL009", SqlDbType.Decimal, 9), new SqlParameter("@DEL010", SqlDbType.NVarChar, 50), new SqlParameter("@DEL011", SqlDbType.NVarChar, 50), new SqlParameter("@DEL012", SqlDbType.NVarChar, 50), new SqlParameter("@DEL013", SqlDbType.NVarChar, 250), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.DEL001; parameters [1].Value = model.DEL002; parameters [2].Value = model.DEL003; parameters [3].Value = model.DEL004; parameters [4].Value = model.DEL005; parameters [5].Value = model.DEL006; parameters [6].Value = model.DEL007; parameters [7].Value = model.DEL008; parameters [8].Value = model.DEL009; parameters [9].Value = model.DEL010; parameters [10].Value = model.DEL011; parameters [11].Value = model.DEL012; parameters [12].Value = model.DEL013; parameters [13].Value = model.id; SQLString.Add(strSql, parameters); }
private void btn_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtRAA001.Text)) { XtraMessageBox.Show("来源单号不可为空"); return; } SiftingDataEntity.MainEntity model = new SiftingDataEntity.MainEntity( ); state = btn.Text; if (state.Equals("审核")) { model.DEL014 = true; } else { model.DEL014 = false; } model.DEL011 = txtRAA001.Text; model.DEL015 = txtDEL015.Text; if (state.Equals("反审核")) { if (_bll.Exists(txtRAA001.Text, txtDEA002.Text) == false) { XtraMessageBox.Show("已经入库,不允许反审核"); return; } } result = _bll.Examine(model); if (result) { XtraMessageBox.Show(state + "成功"); //if ( state . Equals ( "审核" ) ) // btn . Text = "反审核"; //else if ( state . Equals ( "反审核" ) ) // btn . Text = "审核"; examine(state); if (state.Equals("反审核")) { toolEdit.Visibility = toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; } else { toolEdit.Visibility = toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; } } else { XtraMessageBox.Show(state + "失败"); } }
public FormMain( ) { InitializeComponent( ); _bll = new SiftingDataBll.Bll.MainBll( ); model = new SiftingDataEntity.MainEntity( ); getQueryForColumn( ); Utility.GridViewMoHuSelect.SetFilter(gridLookUpEdit1View); Utility.GridViewMoHuSelect.SetFilter(sunOfNumA); Utility.GridViewMoHuSelect.SetFilter(gridView2); Utility.GridViewMoHuSelect.SetFilter(gridView4); Utility.GridViewMoHuSelect.SetFilter(View4); controlUnEnable( ); }
/// <summary> /// 更改 /// </summary> /// <param name="table"></param> /// <param name="oderNum"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Update(DataTable table, string oderNum, List <int> idxList, string remark, string oddNum, string num, string piNum, string numOfOrder) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); SiftingDataEntity.MainEntity model = new SiftingDataEntity.MainEntity( ); model.DEL013 = remark; model.DEL015 = oderNum; for (int i = 0; i < table.Rows.Count; i++) { model.DEL011 = piNum; model.DEL016 = num; model.DEL017 = oddNum; model.DEL001 = table.Rows [i] ["DEL001"].ToString( ); model.DEL002 = table.Rows [i] ["DEL002"].ToString( ); model.DEL003 = table.Rows [i] ["DEL003"].ToString( ); model.DEL004 = table.Rows [i] ["DEL004"].ToString( ); model.DEL005 = table.Rows [i] ["DEL005"].ToString( ); model.DEL006 = table.Rows [i] ["DEL006"].ToString( ); model.DEL007 = string.IsNullOrEmpty(table.Rows [i] ["DEL007"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["DEL007"].ToString( )); model.DEL008 = string.IsNullOrEmpty(table.Rows [i] ["DEL008"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["DEL008"].ToString( )); model.DEL009 = string.IsNullOrEmpty(table.Rows [i] ["DEL009"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["DEL009"].ToString( )); model.DEL010 = table.Rows [i] ["DEL010"].ToString( ); /* string . IsNullOrEmpty ( table . Rows [ i ] [ "DEL010" ] . ToString ( ) ) == true ? 0 : Convert . ToDecimal ( table . Rows [ i ] [ "DEL010" ] . ToString ( ) );*/ model.id = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); model.DEL012 = table.Rows [i] ["DEL012"].ToString( ); model.DEL018 = numOfOrder; if (model.id < 1) { Add(SQLString, strSql, model); } else { Edit(SQLString, strSql, model); } } if (idxList != null && idxList.Count > 0) { foreach (int i in idxList) { model.id = i; if (model.id > 0) { Remove(SQLString, strSql, model); } } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
void Add(Hashtable SQLString, StringBuilder strSql, SiftingDataEntity.MainEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into QIXDEL("); strSql.Append("DEL001,DEL002,DEL003,DEL004,DEL005,DEL006,DEL007,DEL008,DEL009,DEL010,DEL011,DEL012,DEL013,DEL015,DEL016,DEL017,DEL018)"); strSql.Append(" values ("); strSql.Append("@DEL001,@DEL002,@DEL003,@DEL004,@DEL005,@DEL006,@DEL007,@DEL008,@DEL009,@DEL010,@DEL011,@DEL012,@DEL013,@DEL015,@DEL016,@DEL017,@DEL018)"); SqlParameter [] parameters = { new SqlParameter("@DEL001", SqlDbType.NVarChar, 50), new SqlParameter("@DEL002", SqlDbType.NVarChar, 50), new SqlParameter("@DEL003", SqlDbType.NVarChar, 50), new SqlParameter("@DEL004", SqlDbType.NVarChar, 50), new SqlParameter("@DEL005", SqlDbType.NVarChar, 50), new SqlParameter("@DEL006", SqlDbType.NVarChar, 50), new SqlParameter("@DEL007", SqlDbType.Decimal, 9), new SqlParameter("@DEL008", SqlDbType.Decimal, 9), new SqlParameter("@DEL009", SqlDbType.Decimal, 9), new SqlParameter("@DEL010", SqlDbType.NVarChar, 50), new SqlParameter("@DEL011", SqlDbType.NVarChar, 50), new SqlParameter("@DEL012", SqlDbType.NVarChar, 50), new SqlParameter("@DEL013", SqlDbType.NVarChar, 250), new SqlParameter("@DEL015", SqlDbType.NVarChar, 50), new SqlParameter("@DEL016", SqlDbType.NVarChar, 50), new SqlParameter("@DEL017", SqlDbType.NVarChar, 50), new SqlParameter("@DEL018", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.DEL001; parameters [1].Value = model.DEL002; parameters [2].Value = model.DEL003; parameters [3].Value = model.DEL004; parameters [4].Value = model.DEL005; parameters [5].Value = model.DEL006; parameters [6].Value = model.DEL007; parameters [7].Value = model.DEL008; parameters [8].Value = model.DEL009; parameters [9].Value = model.DEL010; parameters [10].Value = model.DEL011; parameters [11].Value = model.DEL012; parameters [12].Value = model.DEL013; parameters [13].Value = model.DEL015; parameters [14].Value = model.DEL016; parameters [15].Value = model.DEL017; parameters [16].Value = model.DEL018; SQLString.Add(strSql, parameters); }
/// <summary> /// 删除数据 /// </summary> /// <param name="table"></param> /// <returns></returns> public bool Delete(DataTable table) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); SiftingDataEntity.MainEntity model = new SiftingDataEntity.MainEntity( ); for (int i = 0; i < table.Rows.Count; i++) { model.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); if (model.idx > 0) { Delete(SQLString, strSql, model); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 审核 反审核 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Examine(SiftingDataEntity.MainEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE QIXDEL SET DEL014=@DEL014 WHERE DEL011=@DEL011"); SqlParameter [] parameter = { new SqlParameter("@DEL011", SqlDbType.NVarChar, 50), new SqlParameter("@DEL014", SqlDbType.Bit) }; parameter [0].Value = model.DEL011; parameter [1].Value = model.DEL014; int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter); return(rows > 0 ? true : false); }
/// <summary> /// 保存数据 /// </summary> /// <param name="table"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Save(DataTable table, List <string> idxList) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); SiftingDataEntity.MainEntity model = new SiftingDataEntity.MainEntity( ); for (int i = 0; i < table.Rows.Count; i++) { model.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); model.MAI001 = string.IsNullOrEmpty(table.Rows [i] ["MAI001"].ToString( )) == true ? DateTime.Now : Convert.ToDateTime(table.Rows [i] ["MAI001"].ToString( )); model.MAI002 = table.Rows [i] ["MAI002"].ToString( ); model.MAI003 = table.Rows [i] ["MAI003"].ToString( ); model.MAI004 = string.IsNullOrEmpty(table.Rows [i] ["MAI004"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["MAI004"].ToString( )); //model . MAI005 = table . Rows [ i ] [ "MAI005" ] . ToString ( ); if (model.idx < 1) { if (Exists(model.MAI002)) { Edit(SQLString, strSql, model); } else { Add(SQLString, strSql, model); } } else { Edits(SQLString, strSql, model); } } if (idxList.Count > 0) { foreach (string i in idxList) { model.idx = Convert.ToInt32(i); if (model.idx > 0) { Delete(SQLString, strSql, model); } } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
public FormMain( ) { InitializeComponent( ); _bll = new SiftingDataBll.Bll.MainBll( ); model = new SiftingDataEntity.MainEntity( ); barTool.LinksPersistInfo.RemoveAt(toolCanecl.Id); barTool.LinksPersistInfo.RemoveAt(toolSave.Id); barTool.LinksPersistInfo.RemoveAt(toolDelete.Id); barTool.LinksPersistInfo.RemoveAt(toolEdit.Id); barTool.LinksPersistInfo.RemoveAt(toolAdd.Id); getQueryForColumn( ); Utility.GridViewMoHuSelect.SetFilter(gridLookUpEdit1View); Utility.GridViewMoHuSelect.SetFilter(sunOfNumA); Utility.GridViewMoHuSelect.SetFilter(gridView2); Utility.GridViewMoHuSelect.SetFilter(gridView3); Utility.GridViewMoHuSelect.SetFilter(gridView4); controlUnEnable( ); layoutControlItem13.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; }
void Add(Hashtable SQLString, StringBuilder strSql, SiftingDataEntity.MainEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into JIFMAI("); strSql.Append("MAI001,MAI002,MAI003,MAI004)"); strSql.Append(" values ("); strSql.Append("@MAI001,@MAI002,@MAI003,@MAI004)"); SqlParameter [] parameters = { new SqlParameter("@MAI001", SqlDbType.Date, 3), new SqlParameter("@MAI002", SqlDbType.NVarChar, 50), new SqlParameter("@MAI003", SqlDbType.NVarChar, 50), new SqlParameter("@MAI004", SqlDbType.Int, 4) //, //new SqlParameter("@MAI005", SqlDbType.NVarChar,200) }; parameters [0].Value = model.MAI001; parameters [1].Value = model.MAI002; parameters [2].Value = model.MAI003; parameters [3].Value = model.MAI004; //parameters [ 4 ] . Value = model . MAI005; SQLString.Add(strSql, parameters); }
/// <summary> /// 审核 反审核 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Examine(SiftingDataEntity.MainEntity model) { return(dal.Examine(model)); }
void Delete(ArrayList SQLString, StringBuilder strSql, SiftingDataEntity.MainEntity model) { strSql = new StringBuilder( ); strSql.AppendFormat("DELETE FROM JIFMAI WHERE idx={0}", model.idx); SQLString.Add(strSql); }