void edit_cp(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.FeedTestCPEntity model) { strSql = new StringBuilder( ); strSql.Append("update R_PQCP set "); strSql.Append("CP001=@CP001,"); strSql.Append("CP002=@CP002,"); strSql.Append("CP003=@CP003,"); strSql.Append("CP004=@CP004,"); strSql.Append("CP005=@CP005,"); strSql.Append("CP006=@CP006 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@CP001", SqlDbType.NVarChar, 20), new SqlParameter("@CP002", SqlDbType.Int, 4), new SqlParameter("@CP003", SqlDbType.NVarChar, 20), new SqlParameter("@CP004", SqlDbType.NVarChar, 20), new SqlParameter("@CP005", SqlDbType.Decimal, 9), new SqlParameter("@CP006", SqlDbType.NVarChar, 20), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.CP001; parameters [1].Value = model.CP002; parameters [2].Value = model.CP003; parameters [3].Value = model.CP004; parameters [4].Value = model.CP005; parameters [5].Value = model.CP006; parameters [6].Value = model.idx; SQLString.Add(strSql, parameters); }
void delete_cp(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.FeedTestCPEntity model) { strSql = new StringBuilder( ); strSql.AppendFormat("DELETE FROM R_PQCP WHERE idx={0}", model.idx); SQLString.Add(strSql, null); }
void add_cp(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.FeedTestCPEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into R_PQCP("); strSql.Append("CP001,CP002,CP003,CP004,CP005,CP006)"); strSql.Append(" values ("); strSql.Append("@CP001,@CP002,@CP003,@CP004,@CP005,@CP006)"); SqlParameter [] parameters = { new SqlParameter("@CP001", SqlDbType.NVarChar, 20), new SqlParameter("@CP002", SqlDbType.Int, 4), new SqlParameter("@CP003", SqlDbType.NVarChar, 20), new SqlParameter("@CP004", SqlDbType.NVarChar, 20), new SqlParameter("@CP005", SqlDbType.Decimal, 9), new SqlParameter("@CP006", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.CP001; parameters [1].Value = model.CP002; parameters [2].Value = model.CP003; parameters [3].Value = model.CP004; parameters [4].Value = model.CP005; parameters [5].Value = model.CP006; SQLString.Add(strSql, parameters); }
private void gridControl1_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == 13) { int [] rows = gridView1.GetSelectedRows( ); if (rows.Length > 0) { foreach (int i in rows) { MulaolaoLibrary.FeedTestCPEntity _cp = new MulaolaoLibrary.FeedTestCPEntity( ); DataRow row = gridView1.GetDataRow(i); _cp.CP001 = row ["TAB"].ToString( ); _cp.CP002 = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( )); _cp.CP003 = row ["ONE"].ToString( ); _cp.CP004 = row ["TWO"].ToString( ); _cp.CP005 = string.IsNullOrEmpty(row ["TRE"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["TRE"].ToString( )); modelCP.Add(_cp); } this.DialogResult = DialogResult.OK; } else { MessageBox.Show("请选择零件"); } } }
/// <summary> /// edit data to r_pqcn r_pqco r_pqcp /// </summary> /// <param name="table"></param> /// <param name="_cn"></param> /// <param name="ModelCp"></param> /// <param name="strList"></param> /// <returns></returns> public bool Edit(DataTable table, MulaolaoLibrary.FeedTestCNEntity _cn, List <MulaolaoLibrary.FeedTestCPEntity> ModelCp, List <string> strList) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); edit_cn(SQLString, strSql, _cn); MulaolaoLibrary.FeedTestCOEntity _co = new MulaolaoLibrary.FeedTestCOEntity( ); _co.CO001 = _cn.CN001; for (int i = 0; i < table.Rows.Count; i++) { _co.CO002 = table.Rows [i] ["CO002"].ToString( ); _co.CO003 = string.IsNullOrEmpty(table.Rows [i] ["CO003"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO003"].ToString( )); _co.CO004 = string.IsNullOrEmpty(table.Rows [i] ["CO004"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO004"].ToString( )); _co.CO005 = table.Rows [i] ["CO005"].ToString( ); _co.CO006 = table.Rows [i] ["CO006"].ToString( ); _co.CO007 = string.IsNullOrEmpty(table.Rows [i] ["CO007"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO007"].ToString( )); _co.CO008 = string.IsNullOrEmpty(table.Rows [i] ["CO008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO008"].ToString( )); _co.CO009 = string.IsNullOrEmpty(table.Rows [i] ["CO009"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO009"].ToString( )); _co.CO010 = string.IsNullOrEmpty(table.Rows [i] ["CO010"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO010"].ToString( )); _co.CO011 = table.Rows [i] ["CO011"].ToString( ); _co.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); if (_co.idx > 0) { edit_co(SQLString, strSql, _co); } else { add_co(SQLString, strSql, _co); } } if (strList.Count > 0) { foreach (string s in strList) { _co.idx = Convert.ToInt32(s); delete_co(SQLString, strSql, _co); } } DataTable ta = getCP(_cn.CN001); foreach (MulaolaoLibrary.FeedTestCPEntity cp in ModelCp) { cp.CP001 = _cn.CN001; if (cp.idx == 0) { delete_cp(SQLString, strSql, cp); } else { if (Exists(cp.idx)) { edit_cp(SQLString, strSql, cp); } } } if (ta != null && ta.Rows.Count > 0) { MulaolaoLibrary.FeedTestCPEntity cp = new MulaolaoLibrary.FeedTestCPEntity( ); cp.CP001 = _cn.CN001; for (int i = 0; i < ta.Rows.Count; i++) { bool result = false; cp.idx = string.IsNullOrEmpty(ta.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(ta.Rows [i] ["idx"].ToString( )); if (cp.idx > 0) { foreach (MulaolaoLibrary.FeedTestCPEntity cpM in ModelCp) { if (cp.idx == cpM.idx) { result = true; break; } } if (result == false) { delete_cp(SQLString, strSql, cp); } } } } return(SqlHelper.ExecuteSqlTran(SQLString)); }