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));
}
