public FormTestResultRecordOne( )
{
InitializeComponent( );
_cu = new MulaolaoLibrary.TestResultRecordOneCUEntity( );
_cv = new MulaolaoLibrary.TestResultRecordOneCVEntity( );
_cw = new MulaolaoLibrary.TestResultRecordOneCWEntity( );
_bll = new MulaolaoBll.Bll.TestResultRecordOneBll( );
tableView = new DataTable( );
tableOneView = new DataTable( );
MulaolaoBll.UserInfoMation.tableName = this.Name;
GridViewMoHuSelect.SetFilter(secView);
GridViewMoHuSelect.SetFilter(gridView1);
GridViewMoHuSelect.SetFilter(gridView2);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, gridView2 });
Power(this);
UnEnable( );
secCV002.Properties.DataSource = _bll.getProInfo( );
secCV002.Properties.DisplayMember = "PQF04";
secCV002.Properties.ValueMember = "PQF01";
reCheckBox.DataSource = _bll.getProNum( );
reCheckBox.DisplayMember = "CW001";
tableOneView = _bll.getTableViewOne( );
gridControl2.DataSource = tableOneView;
}
void delete_cu(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestResultRecordOneCUEntity model)
{
strSql = new StringBuilder( );
strSql.Append("delete from R_PQCU ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.idx;
SQLString.Add(strSql, parameters);
}
void add_cu(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestResultRecordOneCUEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into R_PQCU(");
strSql.Append("CU001,CU002,CU003,CU004,CU005,CU006,CU007,CU008,CU009,CU010,CU028,CU011,CU012,CU013,CU014,CU015,CU016,CU017,CU018,CU019,CU020,CU021,CU022,CU023,CU024,CU025,CU026,CU027)");
strSql.Append(" values (");
strSql.Append("@CU001,@CU002,@CU003,@CU004,@CU005,@CU006,@CU007,@CU008,@CU009,@CU010,@CU028,@CU011,@CU012,@CU013,@CU014,@CU015,@CU016,@CU017,@CU018,@CU019,@CU020,@CU021,@CU022,@CU023,@CU024,@CU025,@CU026,@CU027)");
SqlParameter [] parameters =
{
new SqlParameter("@CU001", SqlDbType.NVarChar, 20),
new SqlParameter("@CU002", SqlDbType.NVarChar, 20),
new SqlParameter("@CU003", SqlDbType.NVarChar, 20),
new SqlParameter("@CU004", SqlDbType.NVarChar, 20),
new SqlParameter("@CU005", SqlDbType.Date, 3),
new SqlParameter("@CU006", SqlDbType.Date, 3),
new SqlParameter("@CU007", SqlDbType.NVarChar, 20),
new SqlParameter("@CU008", SqlDbType.NVarChar, 20),
new SqlParameter("@CU009", SqlDbType.Date, 3),
new SqlParameter("@CU010", SqlDbType.NVarChar, 20),
new SqlParameter("@CU028", SqlDbType.NVarChar, 20),
new SqlParameter("@CU011", SqlDbType.Date, 3),
new SqlParameter("@CU012", SqlDbType.NVarChar, 20),
new SqlParameter("@CU013", SqlDbType.NVarChar, 20),
new SqlParameter("@CU014", SqlDbType.Date, 3),
new SqlParameter("@CU015", SqlDbType.NVarChar, 20),
new SqlParameter("@CU016", SqlDbType.NVarChar, 20),
new SqlParameter("@CU017", SqlDbType.Date, 3),
new SqlParameter("@CU018", SqlDbType.NVarChar, 20),
new SqlParameter("@CU019", SqlDbType.NVarChar, 20),
new SqlParameter("@CU020", SqlDbType.Date, 3),
new SqlParameter("@CU021", SqlDbType.NVarChar, 20),
new SqlParameter("@CU022", SqlDbType.NVarChar, 20),
new SqlParameter("@CU023", SqlDbType.Date, 3),
new SqlParameter("@CU024", SqlDbType.NVarChar, 20),
new SqlParameter("@CU025", SqlDbType.NVarChar, 20),
new SqlParameter("@CU026", SqlDbType.NVarChar, 20),
new SqlParameter("@CU027", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.CU001;
parameters [1].Value = model.CU002;
parameters [2].Value = model.CU003;
parameters [3].Value = model.CU004;
parameters [4].Value = model.CU005;
parameters [5].Value = model.CU006;
parameters [6].Value = model.CU007;
parameters [7].Value = model.CU008;
parameters [8].Value = model.CU009;
parameters [9].Value = model.CU010;
parameters [10].Value = model.CU028;
parameters [11].Value = model.CU011;
parameters [12].Value = model.CU012;
parameters [13].Value = model.CU013;
parameters [14].Value = model.CU014;
parameters [15].Value = model.CU015;
parameters [16].Value = model.CU016;
parameters [17].Value = model.CU017;
parameters [18].Value = model.CU018;
parameters [19].Value = model.CU019;
parameters [20].Value = model.CU020;
parameters [21].Value = model.CU021;
parameters [22].Value = model.CU022;
parameters [23].Value = model.CU023;
parameters [24].Value = model.CU024;
parameters [25].Value = model.CU025;
parameters [26].Value = model.CU026;
parameters [27].Value = model.CU027;
SQLString.Add(strSql, parameters);
}
void edit_cu(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestResultRecordOneCUEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update R_PQCU set ");
strSql.Append("CU001=@CU001,");
strSql.Append("CU002=@CU002,");
strSql.Append("CU003=@CU003,");
strSql.Append("CU004=@CU004,");
strSql.Append("CU005=@CU005,");
strSql.Append("CU006=@CU006,");
strSql.Append("CU007=@CU007,");
strSql.Append("CU008=@CU008,");
strSql.Append("CU009=@CU009,");
strSql.Append("CU010=@CU010,");
strSql.Append("CU028=@CU028,");
strSql.Append("CU011=@CU011,");
strSql.Append("CU012=@CU012,");
strSql.Append("CU013=@CU013,");
strSql.Append("CU014=@CU014,");
strSql.Append("CU015=@CU015,");
strSql.Append("CU016=@CU016,");
strSql.Append("CU017=@CU017,");
strSql.Append("CU018=@CU018,");
strSql.Append("CU019=@CU019,");
strSql.Append("CU020=@CU020,");
strSql.Append("CU021=@CU021,");
strSql.Append("CU022=@CU022,");
strSql.Append("CU023=@CU023,");
strSql.Append("CU024=@CU024,");
strSql.Append("CU025=@CU025,");
strSql.Append("CU026=@CU026,");
strSql.Append("CU027=@CU027 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@CU001", SqlDbType.NVarChar, 20),
new SqlParameter("@CU002", SqlDbType.NVarChar, 20),
new SqlParameter("@CU003", SqlDbType.NVarChar, 20),
new SqlParameter("@CU004", SqlDbType.NVarChar, 20),
new SqlParameter("@CU005", SqlDbType.Date, 3),
new SqlParameter("@CU006", SqlDbType.Date, 3),
new SqlParameter("@CU007", SqlDbType.NVarChar, 20),
new SqlParameter("@CU008", SqlDbType.NVarChar, 20),
new SqlParameter("@CU009", SqlDbType.Date, 3),
new SqlParameter("@CU010", SqlDbType.NVarChar, 20),
new SqlParameter("@CU028", SqlDbType.NVarChar, 20),
new SqlParameter("@CU011", SqlDbType.Date, 3),
new SqlParameter("@CU012", SqlDbType.NVarChar, 20),
new SqlParameter("@CU013", SqlDbType.NVarChar, 20),
new SqlParameter("@CU014", SqlDbType.Date, 3),
new SqlParameter("@CU015", SqlDbType.NVarChar, 20),
new SqlParameter("@CU016", SqlDbType.NVarChar, 20),
new SqlParameter("@CU017", SqlDbType.Date, 3),
new SqlParameter("@CU018", SqlDbType.NVarChar, 20),
new SqlParameter("@CU019", SqlDbType.NVarChar, 20),
new SqlParameter("@CU020", SqlDbType.Date, 3),
new SqlParameter("@CU021", SqlDbType.NVarChar, 20),
new SqlParameter("@CU022", SqlDbType.NVarChar, 20),
new SqlParameter("@CU023", SqlDbType.Date, 3),
new SqlParameter("@CU024", SqlDbType.NVarChar, 20),
new SqlParameter("@CU025", SqlDbType.NVarChar, 20),
new SqlParameter("@CU026", SqlDbType.NVarChar, 20),
new SqlParameter("@CU027", SqlDbType.NVarChar, 20),
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.CU001;
parameters [1].Value = model.CU002;
parameters [2].Value = model.CU003;
parameters [3].Value = model.CU004;
parameters [4].Value = model.CU005;
parameters [5].Value = model.CU006;
parameters [6].Value = model.CU007;
parameters [7].Value = model.CU008;
parameters [8].Value = model.CU009;
parameters [9].Value = model.CU010;
parameters [10].Value = model.CU028;
parameters [11].Value = model.CU011;
parameters [12].Value = model.CU012;
parameters [13].Value = model.CU013;
parameters [14].Value = model.CU014;
parameters [15].Value = model.CU015;
parameters [16].Value = model.CU016;
parameters [17].Value = model.CU017;
parameters [18].Value = model.CU018;
parameters [19].Value = model.CU019;
parameters [20].Value = model.CU020;
parameters [21].Value = model.CU021;
parameters [22].Value = model.CU022;
parameters [23].Value = model.CU023;
parameters [24].Value = model.CU024;
parameters [25].Value = model.CU025;
parameters [26].Value = model.CU026;
parameters [27].Value = model.CU027;
parameters [28].Value = model.idx;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// save data to r_pqcv r_pqcu r_pqcw
/// </summary>
/// <param name="tableOnt"></param>
/// <param name="tableTwo"></param>
/// <param name="_cv"></param>
/// <param name="bodyList"></param>
/// <param name="coeList"></param>
/// <param name="logins"></param>
/// <returns></returns>
public bool Save(DataTable tableOnt, DataTable tableTwo, MulaolaoLibrary.TestResultRecordOneCVEntity _cv, List <string> bodyList, List <string> coeList, string logins)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
if (_cv.idx < 1)
{
_cv.CV001 = getOddNum( );
add_cv(SQLString, strSql, _cv);
SQLString.Add(Drity.DrityOfComparation("R_368", "粘接(R_368)", logins, Drity.GetDt( ), _cv.CV001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表头"), null);
}
else
{
edit_cv(SQLString, strSql, _cv);
SQLString.Add(Drity.DrityOfComparation("R_368", "粘接(R_368)", logins, Drity.GetDt( ), _cv.CV001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表头"), null);
}
MulaolaoLibrary.TestResultRecordOneCUEntity model = new MulaolaoLibrary.TestResultRecordOneCUEntity( );
model.CU001 = _cv.CV001;
for (int i = 0; i < tableOnt.Rows.Count; i++)
{
model.CU002 = tableOnt.Rows [i] ["CU002"].ToString( );
model.CU003 = tableOnt.Rows [i] ["CU003"].ToString( );
model.CU004 = tableOnt.Rows [i] ["CU004"].ToString( );
if (string.IsNullOrEmpty(tableOnt.Rows [i] ["CU005"].ToString( )))
{
model.CU005 = null;
}
else
{
model.CU005 = Convert.ToDateTime(tableOnt.Rows [i] ["CU005"].ToString( ));
}
if (string.IsNullOrEmpty(tableOnt.Rows [i] ["CU006"].ToString( )))
{
model.CU006 = null;
}
else
{
model.CU006 = Convert.ToDateTime(tableOnt.Rows [i] ["CU006"].ToString( ));
}
model.CU007 = tableOnt.Rows [i] ["CU007"].ToString( );
model.CU008 = tableOnt.Rows [i] ["CU008"].ToString( );
if (string.IsNullOrEmpty(tableOnt.Rows [i] ["CU009"].ToString( )))
{
model.CU009 = null;
}
else
{
model.CU009 = Convert.ToDateTime(tableOnt.Rows [i] ["CU009"].ToString( ));
}
model.CU010 = tableOnt.Rows [i] ["CU010"].ToString( );
model.CU028 = tableOnt.Rows [i] ["CU028"].ToString( );
if (string.IsNullOrEmpty(tableOnt.Rows [i] ["CU011"].ToString( )))
{
model.CU011 = null;
}
else
{
model.CU011 = Convert.ToDateTime(tableOnt.Rows [i] ["CU011"].ToString( ));
}
model.CU012 = tableOnt.Rows [i] ["CU012"].ToString( );
model.CU013 = tableOnt.Rows [i] ["CU013"].ToString( );
if (string.IsNullOrEmpty(tableOnt.Rows [i] ["CU014"].ToString( )))
{
model.CU014 = null;
}
else
{
model.CU014 = Convert.ToDateTime(tableOnt.Rows [i] ["CU014"].ToString( ));
}
model.CU015 = tableOnt.Rows [i] ["CU015"].ToString( );
model.CU016 = tableOnt.Rows [i] ["CU016"].ToString( );
if (string.IsNullOrEmpty(tableOnt.Rows [i] ["CU017"].ToString( )))
{
model.CU017 = null;
}
else
{
model.CU017 = Convert.ToDateTime(tableOnt.Rows [i] ["CU017"].ToString( ));
}
model.CU018 = tableOnt.Rows [i] ["CU018"].ToString( );
model.CU019 = tableOnt.Rows [i] ["CU019"].ToString( );
if (string.IsNullOrEmpty(tableOnt.Rows [i] ["CU020"].ToString( )))
{
model.CU020 = null;
}
else
{
model.CU020 = Convert.ToDateTime(tableOnt.Rows [i] ["CU020"].ToString( ));
}
model.CU021 = tableOnt.Rows [i] ["CU021"].ToString( );
model.CU022 = tableOnt.Rows [i] ["CU022"].ToString( );
if (string.IsNullOrEmpty(tableOnt.Rows [i] ["CU023"].ToString( )))
{
model.CU023 = null;
}
else
{
model.CU023 = Convert.ToDateTime(tableOnt.Rows [i] ["CU023"].ToString( ));
}
model.CU024 = tableOnt.Rows [i] ["CU024"].ToString( );
model.CU025 = tableOnt.Rows [i] ["CU025"].ToString( );
model.CU026 = tableOnt.Rows [i] ["CU026"].ToString( );
model.CU027 = tableOnt.Rows [i] ["CU027"].ToString( );
model.idx = string.IsNullOrEmpty(tableOnt.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(tableOnt.Rows [i] ["idx"].ToString( ));
if (model.idx < 1)
{
add_cu(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_368-" + i, "粘接(R_368)", logins, Drity.GetDt( ), model.CU001, strSql.ToString( ).Replace("'", "''"), "新增", "新增单身"), null);
}
else
{
edit_cu(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_368-" + i, "粘接(R_368)", logins, Drity.GetDt( ), model.CU001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑单身"), null);
}
}
if (bodyList.Count > 0)
{
foreach (string s in bodyList)
{
model.idx = Convert.ToInt32(s);
delete_cu(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_368-" + model.idx, "粘接(R_368)", logins, Drity.GetDt( ), model.CU001, strSql.ToString( ).Replace("'", "''"), "删除", "删除单身"), null);
}
}
MulaolaoLibrary.TestResultRecordOneCWEntity _cw = new MulaolaoLibrary.TestResultRecordOneCWEntity( );
for (int i = 0; i < tableTwo.Rows.Count; i++)
{
_cw.idx = string.IsNullOrEmpty(tableTwo.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(tableTwo.Rows [i] ["idx"].ToString( ));
_cw.CW001 = tableTwo.Rows [i] ["CW001"].ToString( );
_cw.CW002 = tableTwo.Rows [i] ["CW002"].ToString( );
if (_cw.idx > 0)
{
edit_cw(SQLString, strSql, _cw);
SQLString.Add(Drity.DrityOfComparation("R_368-" + i, "粘接(R_368)", logins, Drity.GetDt( ), model.CU001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑系数"), null);
}
else
{
add_cw(SQLString, strSql, _cw);
SQLString.Add(Drity.DrityOfComparation("R_368-" + i, "粘接(R_368)", logins, Drity.GetDt( ), model.CU001, strSql.ToString( ).Replace("'", "''"), "新增", "新增系数"), null);
}
}
if (coeList.Count > 0)
{
foreach (string s in coeList)
{
_cw.idx = Convert.ToInt32(s);
delete_cw(SQLString, strSql, _cw);
SQLString.Add(Drity.DrityOfComparation("R_368-" + _cw.idx, "粘接(R_368)", logins, Drity.GetDt( ), model.CU001, strSql.ToString( ).Replace("'", "''"), "删除", "删除系数"), null);
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
