void add_pqcg(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.StandardAuditFivCKEntity model, string logins)
{
strSql = new StringBuilder( );
strSql.Append("insert into R_PQCK(");
strSql.Append("CK001,CK002,CK003,CK004,CK005,CK006,CK007,CK008,CK009,CK010,CK011,CK012,CK013,CK014,CK015,CK016,CK017,CK018,CK021,CK022)");
strSql.Append(" values (");
strSql.Append("@CK001,@CK002,@CK003,@CK004,@CK005,@CK006,@CK007,@CK008,@CK009,@CK010,@CK011,@CK012,@CK013,@CK014,@CK015,@CK016,@CK017,@CK018,@CK021,@CK022)");
SqlParameter [] parameters =
{
new SqlParameter("@CK001", SqlDbType.NVarChar, 20),
new SqlParameter("@CK002", SqlDbType.NVarChar, 20),
new SqlParameter("@CK003", SqlDbType.NVarChar, 20),
new SqlParameter("@CK004", SqlDbType.NVarChar, 20),
new SqlParameter("@CK005", SqlDbType.Date, 3),
new SqlParameter("@CK006", SqlDbType.Date, 3),
new SqlParameter("@CK007", SqlDbType.NVarChar, 20),
new SqlParameter("@CK008", SqlDbType.NVarChar, 20),
new SqlParameter("@CK009", SqlDbType.NVarChar, 20),
new SqlParameter("@CK010", SqlDbType.NVarChar, 20),
new SqlParameter("@CK011", SqlDbType.NVarChar, 20),
new SqlParameter("@CK012", SqlDbType.NVarChar, 20),
new SqlParameter("@CK013", SqlDbType.NVarChar, 20),
new SqlParameter("@CK014", SqlDbType.Date, 3),
new SqlParameter("@CK015", SqlDbType.NVarChar, 20),
new SqlParameter("@CK016", SqlDbType.Date, 3),
new SqlParameter("@CK017", SqlDbType.NVarChar, 20),
new SqlParameter("@CK018", SqlDbType.Date, 3),
new SqlParameter("@CK021", SqlDbType.NVarChar, 100),
new SqlParameter("@CK022", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.CK001;
parameters [1].Value = model.CK002;
parameters [2].Value = model.CK003;
parameters [3].Value = model.CK004;
parameters [4].Value = model.CK005;
parameters [5].Value = model.CK006;
parameters [6].Value = model.CK007;
parameters [7].Value = model.CK008;
parameters [8].Value = model.CK009;
parameters [9].Value = model.CK010;
parameters [10].Value = model.CK011;
parameters [11].Value = model.CK012;
parameters [12].Value = model.CK013;
parameters [13].Value = model.CK014;
parameters [14].Value = model.CK015;
parameters [15].Value = model.CK016;
parameters [16].Value = model.CK017;
parameters [17].Value = model.CK018;
parameters [18].Value = model.CK021;
parameters [19].Value = model.CK022;
SQLString.Add(strSql, parameters);
//SQLString . Add ( Drity . DrityOfComparation ( "R_482" ,"滚、喷、涂漆生产首件标准样审核确认记录表(R_482)" ,logins ,Drity . GetDt ( ) ,model . CK001 ,strSql . ToString ( ) . Replace ( "'" ,"''" ) ,"新增" ,"新增" ) ,null );
}
void delete_pqcg(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.StandardAuditFivCKEntity model, string logins)
{
strSql = new StringBuilder( );
strSql.Append("delete from R_PQCK ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.idx;
SQLString.Add(strSql, parameters);
//SQLString . Add ( Drity . DrityOfComparation ( "R_482" ,"滚、喷、涂漆生产首件标准样审核确认记录表(R_482)" ,logins ,Drity . GetDt ( ) ,model . CK001 ,strSql . ToString ( ) . Replace ( "'" ,"''" ) ,"删除" ,"编辑删除" ) ,null );
}
public FormStandardAuditFiv( )
{
InitializeComponent( );
_cj = new MulaolaoLibrary.StandardAuditFivCJEntity( );
_ck = new MulaolaoLibrary.StandardAuditFivCKEntity( );
_bll = new MulaolaoBll.Bll.StandardAuditFivBll( );
tableView = new DataTable( );
printOne = new DataTable( );
printTwo = new DataTable( );
GridViewMoHuSelect.SetFilter(secView);
GridViewMoHuSelect.SetFilter(bandedGridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { bandedGridView1 });
Power(this);
UnEnable( );
MulaolaoBll.UserInfoMation.tableName = this.Name;
secPro.Properties.DataSource = _bll.getProInfo( );
secPro.Properties.DisplayMember = "PQF04";
secPro.Properties.ValueMember = "PQF01";
DataTable dt = _bll.getUser( );
if (dt != null && dt.Rows.Count > 0)
{
DataTable da = dt.Copy( ).DefaultView.ToTable(true, "CJ007");
for (int i = 0; i < da.Rows.Count; i++)
{
cmbUserOne.Properties.Items.Add(da.Rows [i] ["CJ007"].ToString( ));
}
da = dt.Copy( ).DefaultView.ToTable(true, "CJ008");
for (int i = 0; i < da.Rows.Count; i++)
{
cmbUserTwo.Properties.Items.Add(da.Rows [i] ["CJ008"].ToString( ));
}
da = dt.Copy( ).DefaultView.ToTable(true, "CJ009");
for (int i = 0; i < da.Rows.Count; i++)
{
cmbUserTre.Properties.Items.Add(da.Rows [i] ["CJ009"].ToString( ));
}
da = dt.Copy( ).DefaultView.ToTable(true, "CJ010");
for (int i = 0; i < da.Rows.Count; i++)
{
cmbUserFor.Properties.Items.Add(da.Rows [i] ["CJ010"].ToString( ));
}
}
}
void edit_pqcg(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.StandardAuditFivCKEntity model, string logins)
{
strSql = new StringBuilder( );
strSql.Append("update R_PQCK set ");
strSql.Append("CK001=@CK001,");
strSql.Append("CK002=@CK002,");
strSql.Append("CK003=@CK003,");
strSql.Append("CK004=@CK004,");
strSql.Append("CK005=@CK005,");
strSql.Append("CK006=@CK006,");
strSql.Append("CK007=@CK007,");
strSql.Append("CK008=@CK008,");
strSql.Append("CK009=@CK009,");
strSql.Append("CK010=@CK010,");
strSql.Append("CK011=@CK011,");
strSql.Append("CK012=@CK012,");
strSql.Append("CK013=@CK013,");
strSql.Append("CK014=@CK014,");
strSql.Append("CK015=@CK015,");
strSql.Append("CK016=@CK016,");
strSql.Append("CK017=@CK017,");
strSql.Append("CK018=@CK018,");
strSql.Append("CK021=@CK021,");
strSql.Append("CK022=@CK022 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@CK001", SqlDbType.NVarChar, 20),
new SqlParameter("@CK002", SqlDbType.NVarChar, 20),
new SqlParameter("@CK003", SqlDbType.NVarChar, 20),
new SqlParameter("@CK004", SqlDbType.NVarChar, 20),
new SqlParameter("@CK005", SqlDbType.Date, 3),
new SqlParameter("@CK006", SqlDbType.Date, 3),
new SqlParameter("@CK007", SqlDbType.NVarChar, 20),
new SqlParameter("@CK008", SqlDbType.NVarChar, 20),
new SqlParameter("@CK009", SqlDbType.NVarChar, 20),
new SqlParameter("@CK010", SqlDbType.NVarChar, 20),
new SqlParameter("@CK011", SqlDbType.NVarChar, 20),
new SqlParameter("@CK012", SqlDbType.NVarChar, 20),
new SqlParameter("@CK013", SqlDbType.NVarChar, 20),
new SqlParameter("@CK014", SqlDbType.Date, 3),
new SqlParameter("@CK015", SqlDbType.NVarChar, 20),
new SqlParameter("@CK016", SqlDbType.Date, 3),
new SqlParameter("@CK017", SqlDbType.NVarChar, 20),
new SqlParameter("@CK018", SqlDbType.Date, 3),
new SqlParameter("@CK021", SqlDbType.NVarChar, 100),
new SqlParameter("@CK022", SqlDbType.NVarChar, 20),
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.CK001;
parameters [1].Value = model.CK002;
parameters [2].Value = model.CK003;
parameters [3].Value = model.CK004;
parameters [4].Value = model.CK005;
parameters [5].Value = model.CK006;
parameters [6].Value = model.CK007;
parameters [7].Value = model.CK008;
parameters [8].Value = model.CK009;
parameters [9].Value = model.CK010;
parameters [10].Value = model.CK011;
parameters [11].Value = model.CK012;
parameters [12].Value = model.CK013;
parameters [13].Value = model.CK014;
parameters [14].Value = model.CK015;
parameters [15].Value = model.CK016;
parameters [16].Value = model.CK017;
parameters [17].Value = model.CK018;
parameters [18].Value = model.CK021;
parameters [19].Value = model.CK022;
parameters [20].Value = model.idx;
SQLString.Add(strSql, parameters);
//SQLString . Add ( Drity . DrityOfComparation ( "R_482" ,"滚、喷、涂漆生产首件标准样审核确认记录表(R_482)" ,logins ,Drity . GetDt ( ) ,model . CK001 ,strSql . ToString ( ) . Replace ( "'" ,"''" ) ,"编辑" ,"编辑" ) ,null );
}
/// <summary>
/// edit data from r_pqcb and r_pqcc to database
/// </summary>
/// <param name="table"></param>
/// <param name="_cb"></param>
/// <param name="logins"></param>
/// <param name="strList"></param>
/// <returns></returns>
public bool Edit(DataTable table, MulaolaoLibrary.StandardAuditFivCJEntity _cf, string logins, List <string> strList)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
edit_pqcf(SQLString, strSql, _cf);
SQLString.Add(Drity.DrityOfComparation("R_489", "电脑雕刻生产首件样审核确认记录表(R_489)", logins, Drity.GetDt( ), _cf.CJ001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑"), null);
MulaolaoLibrary.StandardAuditFivCKEntity _ce = new MulaolaoLibrary.StandardAuditFivCKEntity( );
_ce.CK001 = _cf.CJ001;
for (int i = 0; i < table.Rows.Count; i++)
{
_ce.CK002 = table.Rows [i] ["CK002"].ToString( );
_ce.CK003 = table.Rows [i] ["CK003"].ToString( );
_ce.CK004 = table.Rows [i] ["CK004"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["CK005"].ToString( )))
{
_ce.CK005 = null;
}
else
{
_ce.CK005 = Convert.ToDateTime(table.Rows [i] ["CK005"]);
}
if (string.IsNullOrEmpty(table.Rows [i] ["CK006"].ToString( )))
{
_ce.CK006 = null;
}
else
{
_ce.CK006 = Convert.ToDateTime(table.Rows [i] ["CK006"]);
}
_ce.CK007 = table.Rows [i] ["CK007"].ToString( );
_ce.CK008 = table.Rows [i] ["CK008"].ToString( );
_ce.CK009 = table.Rows [i] ["CK009"].ToString( );
_ce.CK010 = table.Rows [i] ["CK010"].ToString( );
_ce.CK011 = table.Rows [i] ["CK011"].ToString( );
_ce.CK012 = table.Rows [i] ["CK012"].ToString( );
_ce.CK013 = table.Rows [i] ["CK013"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["CK014"].ToString( )))
{
_ce.CK014 = null;
}
else
{
_ce.CK014 = Convert.ToDateTime(table.Rows [i] ["CK014"]);
}
_ce.CK015 = table.Rows [i] ["CK015"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["CK016"].ToString( )))
{
_ce.CK016 = null;
}
else
{
_ce.CK016 = Convert.ToDateTime(table.Rows [i] ["CK016"]);
}
_ce.CK017 = table.Rows [i] ["CK017"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["CK018"].ToString( )))
{
_ce.CK018 = null;
}
else
{
_ce.CK018 = Convert.ToDateTime(table.Rows [i] ["CK018"]);
}
_ce.CK021 = table.Rows [i] ["CK021"].ToString( );
_ce.CK022 = table.Rows [i] ["CK022"].ToString( );
_ce.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
if (_ce.idx < 1)
{
add_pqcg(SQLString, strSql, _ce, logins);
}
else
{
edit_pqcg(SQLString, strSql, _ce, logins);
}
}
foreach (string s in strList)
{
_ce.idx = Convert.ToInt32(s);
delete_pqcg(SQLString, strSql, _ce, logins);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// save data to r_pqcb and r_pqcc
/// </summary>
/// <param name="table"></param>
/// <param name="_cb"></param>
/// <returns></returns>
public bool Save(DataTable table, MulaolaoLibrary.StandardAuditFivCJEntity _cf, string logins)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
_cf.CJ001 = getOddNum( );
add_pqcf(SQLString, strSql, _cf);
SQLString.Add(Drity.DrityOfComparation("R_484", "动力段生产首件量.检具审核确认记录表(R_484)", logins, Drity.GetDt( ), _cf.CJ001, strSql.ToString( ).Replace("'", "''"), "新增", "新增"), null);
MulaolaoLibrary.StandardAuditFivCKEntity _ce = new MulaolaoLibrary.StandardAuditFivCKEntity( );
_ce.CK001 = _cf.CJ001;
for (int i = 0; i < table.Rows.Count; i++)
{
_ce.CK002 = table.Rows [i] ["CK002"].ToString( );
_ce.CK003 = table.Rows [i] ["CK003"].ToString( );
_ce.CK004 = table.Rows [i] ["CK004"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["CK005"].ToString( )))
{
_ce.CK005 = null;
}
else
{
_ce.CK005 = Convert.ToDateTime(table.Rows [i] ["CK005"]);
}
if (string.IsNullOrEmpty(table.Rows [i] ["CK006"].ToString( )))
{
_ce.CK006 = null;
}
else
{
_ce.CK006 = Convert.ToDateTime(table.Rows [i] ["CK006"]);
}
_ce.CK007 = table.Rows [i] ["CK007"].ToString( );
_ce.CK008 = table.Rows [i] ["CK008"].ToString( );
_ce.CK009 = table.Rows [i] ["CK009"].ToString( );
_ce.CK010 = table.Rows [i] ["CK010"].ToString( );
_ce.CK011 = table.Rows [i] ["CK011"].ToString( );
_ce.CK012 = table.Rows [i] ["CK012"].ToString( );
_ce.CK013 = table.Rows [i] ["CK013"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["CK014"].ToString( )))
{
_ce.CK014 = null;
}
else
{
_ce.CK014 = Convert.ToDateTime(table.Rows [i] ["CK014"]);
}
_ce.CK015 = table.Rows [i] ["CK015"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["CK016"].ToString( )))
{
_ce.CK016 = null;
}
else
{
_ce.CK016 = Convert.ToDateTime(table.Rows [i] ["CK016"]);
}
_ce.CK017 = table.Rows [i] ["CK017"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["CK018"].ToString( )))
{
_ce.CK018 = null;
}
else
{
_ce.CK018 = Convert.ToDateTime(table.Rows [i] ["CK018"]);
}
_ce.CK021 = table.Rows [i] ["CK021"].ToString( );
_ce.CK022 = table.Rows [i] ["CK022"].ToString( );
add_pqcg(SQLString, strSql, _ce, logins);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
