public FormTestResultRecord( )
{
InitializeComponent( );
_cr = new MulaolaoLibrary.TestResultRecordCREntity( );
_cs = new MulaolaoLibrary.TestResultRecordCSEntity( );
_ct = new MulaolaoLibrary.TestResultRecordCTEntity( );
_bll = new MulaolaoBll.Bll.TestResultRecordBll( );
tableView = new DataTable( );
tableViewOne = new DataTable( );
GridViewMoHuSelect.SetFilter(secView);
GridViewMoHuSelect.SetFilter(gridView1);
GridViewMoHuSelect.SetFilter(gridView2);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, gridView2 });
MulaolaoBll.UserInfoMation.tableName = this.Name;
Power(this);
UnEnable( );
secPro.Properties.DataSource = _bll.getProInfo( );
secPro.Properties.DisplayMember = "PQF04";
secPro.Properties.ValueMember = "PQF01";
reCheckBox.DataSource = _bll.getTableOfNum( );
reCheckBox.DisplayMember = "CT";
tableViewOne = _bll.getTableViewOne( );
gridControl2.DataSource = tableViewOne;
}
void setValue( )
{
tableView = _bll.getTableView(" CS001='" + _cs.CS001 + "'");
gridControl1.DataSource = tableView;
_cr = _bll.getModel(_cr.CR001);
setValueHead( );
}
public MulaolaoLibrary.TestResultRecordCREntity getModel(DataRow row)
{
MulaolaoLibrary.TestResultRecordCREntity model = new MulaolaoLibrary.TestResultRecordCREntity( );
if (row != null)
{
if (row ["idx"] != null && row["idx"].ToString() != "")
{
model.idx = int.Parse(row ["idx"].ToString( ));
}
if (row ["CR001"] != null)
{
model.CR001 = row ["CR001"].ToString( );
}
if (row ["CR002"] != null)
{
model.CR002 = row ["CR002"].ToString( );
}
if (row ["CR003"] != null)
{
model.CR003 = row ["CR003"].ToString( );
}
if (row ["CR004"] != null)
{
model.CR004 = row ["CR004"].ToString( );
}
if (row ["CR005"] != null)
{
model.CR005 = row ["CR005"].ToString( );
}
if (row ["CR006"] != null)
{
model.CR006 = row ["CR006"].ToString( );
}
if (row ["CR007"] != null)
{
model.CR007 = row ["CR007"].ToString( );
}
if (row ["CR008"] != null)
{
model.CR008 = row ["CR008"].ToString( );
}
if (row ["CR009"] != null)
{
model.CR009 = row ["CR009"].ToString( );
}
if (row ["CR010"] != null)
{
model.CR010 = row ["CR010"].ToString( );
}
if (row ["CR011"] != null)
{
model.CR011 = row ["CR011"].ToString( );
}
}
return(model);
}
void edit_cr(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestResultRecordCREntity model)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQCR SET ");
strSql.Append("CR001=@CR001,");
strSql.Append("CR002=@CR002,");
strSql.Append("CR003=@CR003,");
strSql.Append("CR004=@CR004,");
strSql.Append("CR005=@CR005,");
strSql.Append("CR006=@CR006,");
strSql.Append("CR007=@CR007,");
strSql.Append("CR008=@CR008,");
strSql.Append("CR009=@CR009,");
strSql.Append("CR010=@CR010,");
strSql.Append("CR011=@CR011 ");
strSql.Append("WHERE idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@CR001", SqlDbType.NVarChar, 20),
new SqlParameter("@CR002", SqlDbType.NVarChar, 50),
new SqlParameter("@CR003", SqlDbType.NVarChar, 20),
new SqlParameter("@CR004", SqlDbType.NVarChar, 20),
new SqlParameter("@CR005", SqlDbType.NVarChar, 20),
new SqlParameter("@CR006", SqlDbType.NVarChar, 50),
new SqlParameter("@CR007", SqlDbType.NVarChar, 20),
new SqlParameter("@CR008", SqlDbType.NVarChar, 20),
new SqlParameter("@CR009", SqlDbType.NVarChar, 20),
new SqlParameter("@CR010", SqlDbType.NVarChar, 20),
new SqlParameter("@CR011", SqlDbType.NVarChar, 20),
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.CR001;
parameters [1].Value = model.CR002;
parameters [2].Value = model.CR003;
parameters [3].Value = model.CR004;
parameters [4].Value = model.CR005;
parameters [5].Value = model.CR006;
parameters [6].Value = model.CR007;
parameters [7].Value = model.CR008;
parameters [8].Value = model.CR009;
parameters [9].Value = model.CR010;
parameters [10].Value = model.CR011;
parameters [11].Value = model.idx;
SQLString.Add(strSql, parameters);
}
void add_cr(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestResultRecordCREntity model)
{
strSql = new StringBuilder( );
strSql = new StringBuilder( );
strSql.Append("insert into R_PQCR(");
strSql.Append("CR001,CR002,CR003,CR004,CR005,CR006,CR007,CR008,CR009,CR010,CR011)");
strSql.Append(" values (");
strSql.Append("@CR001,@CR002,@CR003,@CR004,@CR005,@CR006,@CR007,@CR008,@CR009,@CR010,@CR011)");
SqlParameter [] parameters =
{
new SqlParameter("@CR001", SqlDbType.NVarChar, 20),
new SqlParameter("@CR002", SqlDbType.NVarChar, 50),
new SqlParameter("@CR003", SqlDbType.NVarChar, 20),
new SqlParameter("@CR004", SqlDbType.NVarChar, 20),
new SqlParameter("@CR005", SqlDbType.NVarChar, 20),
new SqlParameter("@CR006", SqlDbType.NVarChar, 50),
new SqlParameter("@CR007", SqlDbType.NVarChar, 20),
new SqlParameter("@CR008", SqlDbType.NVarChar, 20),
new SqlParameter("@CR009", SqlDbType.NVarChar, 20),
new SqlParameter("@CR010", SqlDbType.NVarChar, 20),
new SqlParameter("@CR011", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.CR001;
parameters [1].Value = model.CR002;
parameters [2].Value = model.CR003;
parameters [3].Value = model.CR004;
parameters [4].Value = model.CR005;
parameters [5].Value = model.CR006;
parameters [6].Value = model.CR007;
parameters [7].Value = model.CR008;
parameters [8].Value = model.CR009;
parameters [9].Value = model.CR010;
parameters [10].Value = model.CR011;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// save data to databse
/// </summary>
/// <param name="table">单身</param>
/// <param name="_cr">单头</param>
/// <param name="tableOne">系数</param>
/// <param name="coeList">系数删除</param>
/// <param name="bodyList">单身删除</param>
/// <param name="logins">登录人</param>
/// <returns></returns>
public bool Save(DataTable table, MulaolaoLibrary.TestResultRecordCREntity _cr, DataTable tableOne, List <string> coeList, List <string> bodyList, string logins)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
if (_cr.idx < 1)
{
_cr.CR001 = getOddNum( );
add_cr(SQLString, strSql, _cr);
SQLString.Add(Drity.DrityOfComparation("R_418", "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表头"), null);
}
else
{
edit_cr(SQLString, strSql, _cr);
SQLString.Add(Drity.DrityOfComparation("R_418", "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表头"), null);
}
MulaolaoLibrary.TestResultRecordCSEntity _cs = new MulaolaoLibrary.TestResultRecordCSEntity( );
_cs.CS001 = _cr.CR001;
for (int i = 0; i < table.Rows.Count; i++)
{
if (string.IsNullOrEmpty(table.Rows [i] ["CS002"].ToString( )))
{
_cs.CS002 = null;
}
else
{
_cs.CS002 = Convert.ToDateTime(table.Rows [i] ["CS002"].ToString( ));
}
_cs.CS003 = table.Rows [i] ["CS003"].ToString( );
_cs.CS004 = table.Rows [i] ["CS004"].ToString( );
_cs.CS005 = table.Rows [i] ["CS005"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["CS006"].ToString( )))
{
_cs.CS006 = null;
}
else
{
_cs.CS006 = Convert.ToDateTime(table.Rows [i] ["CS006"].ToString( ));
}
_cs.CS007 = string.IsNullOrEmpty(table.Rows [i] ["CS007"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CS007"].ToString( ));
_cs.CS008 = string.IsNullOrEmpty(table.Rows [i] ["CS008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CS008"].ToString( ));
_cs.CS009 = table.Rows [i] ["CS009"].ToString( );
_cs.CS010 = table.Rows [i] ["CS010"].ToString( );
_cs.CS011 = table.Rows [i] ["CS011"].ToString( );
_cs.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
if (_cs.idx < 1)
{
add_cs(SQLString, strSql, _cs);
SQLString.Add(Drity.DrityOfComparation("R_418-" + i, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "新增单身"), null);
}
else
{
edit_cs(SQLString, strSql, _cs);
SQLString.Add(Drity.DrityOfComparation("R_418-" + i, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "编辑单身"), null);
}
}
if (bodyList.Count > 0)
{
foreach (string s in bodyList)
{
delete_cs(SQLString, strSql, _cs);
SQLString.Add(Drity.DrityOfComparation("R_418-" + s, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "删除单身"), null);
}
}
MulaolaoLibrary.TestResultRecordCTEntity _ct = new MulaolaoLibrary.TestResultRecordCTEntity( );
for (int i = 0; i < tableOne.Rows.Count; i++)
{
_ct.CT001 = tableOne.Rows [i] ["CT001"].ToString( );
_ct.CT002 = tableOne.Rows [i] ["CT002"].ToString( );
_ct.CT003 = tableOne.Rows [i] ["CT003"].ToString( );
_ct.CT004 = tableOne.Rows [i] ["CT004"].ToString( );
_ct.CT005 = tableOne.Rows [i] ["CT005"].ToString( );
_ct.CT006 = tableOne.Rows [i] ["CT006"].ToString( );
_ct.CT007 = tableOne.Rows [i] ["CT007"].ToString( );
_ct.CT009 = tableOne.Rows [i] ["CT009"].ToString( );
_ct.CT010 = tableOne.Rows [i] ["CT010"].ToString( );
_ct.CT011 = tableOne.Rows [i] ["CT011"].ToString( );
_ct.CT012 = tableOne.Rows [i] ["CT012"].ToString( );
_ct.CT013 = tableOne.Rows [i] ["CT013"].ToString( );
_ct.CT014 = tableOne.Rows [i] ["CT014"].ToString( );
_ct.idx = string.IsNullOrEmpty(tableOne.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(tableOne.Rows [i] ["idx"].ToString( ));
if (_ct.idx < 1)
{
add_ct(SQLString, strSql, _ct);
SQLString.Add(Drity.DrityOfComparation("R_418-" + i, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "新增系数"), null);
}
else
{
edit_ct(SQLString, strSql, _ct);
SQLString.Add(Drity.DrityOfComparation("R_418-" + i, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "编辑系数"), null);
}
}
if (coeList.Count > 0)
{
foreach (string s in coeList)
{
_ct.idx = Convert.ToInt32(s);
delete_dt(SQLString, strSql, _ct);
SQLString.Add(Drity.DrityOfComparation("R_418-" + s, "产品粘接、组装人员牢固度安全常态抽测结果记录(R_418)", logins, Drity.GetDt( ), _cr.CR001, strSql.ToString( ).Replace("'", "''"), "新增", "删除系数"), null);
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// save data to databse
/// </summary>
/// <param name="table">单身</param>
/// <param name="_cr">单头</param>
/// <param name="tableOne">系数</param>
/// <param name="coeList">系数删除</param>
/// <param name="bodyList">单身删除</param>
/// <param name="logins">登录人</param>
/// <returns></returns>
public bool Save(DataTable table, MulaolaoLibrary.TestResultRecordCREntity _cr, DataTable tableOne, List <string> coeList, List <string> bodyList, string logins)
{
return(_dal.Save(table, _cr, tableOne, coeList, bodyList, logins));
}
