void add_dj(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.QualityFinalInspsctionDJEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into R_PQDJ(");
strSql.Append("DJ001,DJ002,DJ003,DJ004,DJ005,DJ006,DJ007,DJ008)");
strSql.Append(" values (");
strSql.Append("@DJ001,@DJ002,@DJ003,@DJ004,@DJ005,@DJ006,@DJ007,@DJ008)");
SqlParameter [] parameters =
{
new SqlParameter("@DJ001", SqlDbType.NVarChar, 20),
new SqlParameter("@DJ002", SqlDbType.NVarChar, 50),
new SqlParameter("@DJ003", SqlDbType.NVarChar, 50),
new SqlParameter("@DJ004", SqlDbType.NVarChar, 50),
new SqlParameter("@DJ005", SqlDbType.NVarChar, 50),
new SqlParameter("@DJ006", SqlDbType.NVarChar, 20),
new SqlParameter("@DJ007", SqlDbType.Date, 3),
new SqlParameter("@DJ008", SqlDbType.Int, 4)
};
parameters [0].Value = model.DJ001;
parameters [1].Value = model.DJ002;
parameters [2].Value = model.DJ003;
parameters [3].Value = model.DJ004;
parameters [4].Value = model.DJ005;
parameters [5].Value = model.DJ006;
parameters [6].Value = model.DJ007;
parameters [7].Value = model.DJ008;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// save data to database
/// </summary>
/// <param name="table"></param>
/// <param name="_di"></param>
/// <param name="bodyList"></param>
/// <param name="logins"></param>
/// <returns></returns>
public bool Save(DataTable table, MulaolaoLibrary.QualityFinalInspsctionDIEntity _di, List <string> bodyList, string logins)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
if (_di.idx > 0)
{
edit_di(SQLString, strSql, _di);
SQLString.Add(Drity.DrityOfComparation("R_101", "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表头"), null);
}
else
{
_di.DI001 = getOddNum( );
add_di(SQLString, strSql, _di);
SQLString.Add(Drity.DrityOfComparation("R_101", "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表头"), null);
}
MulaolaoLibrary.QualityFinalInspsctionDJEntity model = new MulaolaoLibrary.QualityFinalInspsctionDJEntity( );
model.DJ001 = _di.DI001;
for (int i = 0; i < table.Rows.Count; i++)
{
model.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
model.DJ002 = table.Rows [i] ["DJ002"].ToString( );
model.DJ003 = table.Rows [i] ["DJ003"].ToString( );
model.DJ004 = table.Rows [i] ["DJ004"].ToString( );
model.DJ005 = table.Rows [i] ["DJ005"].ToString( );
model.DJ006 = table.Rows [i] ["DJ006"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["DJ007"].ToString( )))
{
model.DJ007 = null;
}
else
{
model.DJ007 = Convert.ToDateTime(table.Rows [i] ["DJ007"].ToString( ));
}
model.DJ008 = string.IsNullOrEmpty(table.Rows [i] ["DJ008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DJ008"].ToString( ));
if (model.idx > 0)
{
edit_dj(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_101" + i, "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表身"), null);
}
else
{
add_dj(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_101" + i, "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表身"), null);
}
}
if (bodyList.Count > 0)
{
foreach (string s in bodyList)
{
model.idx = Convert.ToInt32(s);
delete_dj(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_101" + model.idx, "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "删除", "删除表身"), null);
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void add_dj(MulaolaoLibrary.QualityFinalInspsctionDJEntity model, ArrayList SQLString)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("INSERT INTO R_PQDJ (DJ001,DJ002,DJ003,DJ004) VALUES ('{0}','{1}','{2}','{3}')", model.DJ001, model.DJ002, model.DJ003, model.DJ004);
SQLString.Add(strSql.ToString( ));
}
void add_di(MulaolaoLibrary.QualityFinalInspsctionDJEntity model, ArrayList SQLString)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("INSERT INTO R_PQDI (DI001) VALUES ('{0}')", model.DJ001);
SQLString.Add(strSql.ToString( ));
}
void delete_dj(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.QualityFinalInspsctionDJEntity model)
{
strSql = new StringBuilder( );
strSql.Append("delete from R_PQDJ ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.idx;
SQLString.Add(strSql, parameters);
}
public FormQualityFinalInspsction( )
{
InitializeComponent( );
_di = new MulaolaoLibrary.QualityFinalInspsctionDIEntity( );
_dj = new MulaolaoLibrary.QualityFinalInspsctionDJEntity( );
_bll = new MulaolaoBll.Bll.QualityFinalInspsctionBll( );
tableView = new DataTable( );
GridViewMoHuSelect.SetFilter(secView);
GridViewMoHuSelect.SetFilter(gridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 });
MulaolaoBll.UserInfoMation.tableName = this.Name;
Power(this);
UnEnable( );
secDI003.Properties.DataSource = _bll.getSupplier( );
secDI003.Properties.DisplayMember = "PQF04";
secDI003.Properties.ValueMember = "PQF01";
}
void edit_dj(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.QualityFinalInspsctionDJEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update R_PQDJ set ");
strSql.Append("DJ001=@DJ001,");
strSql.Append("DJ002=@DJ002,");
strSql.Append("DJ003=@DJ003,");
strSql.Append("DJ004=@DJ004,");
strSql.Append("DJ005=@DJ005,");
strSql.Append("DJ006=@DJ006,");
strSql.Append("DJ007=@DJ007,");
strSql.Append("DJ008=@DJ008 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@DJ001", SqlDbType.NVarChar, 20),
new SqlParameter("@DJ002", SqlDbType.NVarChar, 50),
new SqlParameter("@DJ003", SqlDbType.NVarChar, 50),
new SqlParameter("@DJ004", SqlDbType.NVarChar, 50),
new SqlParameter("@DJ005", SqlDbType.NVarChar, 50),
new SqlParameter("@DJ006", SqlDbType.NVarChar, 20),
new SqlParameter("@DJ007", SqlDbType.Date, 3),
new SqlParameter("@DJ008", SqlDbType.Int, 4),
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.DJ001;
parameters [1].Value = model.DJ002;
parameters [2].Value = model.DJ003;
parameters [3].Value = model.DJ004;
parameters [4].Value = model.DJ005;
parameters [5].Value = model.DJ006;
parameters [6].Value = model.DJ007;
parameters [7].Value = model.DJ008;
parameters [8].Value = model.idx;
SQLString.Add(strSql, parameters);
}
void addViewToDataBase(string oddNum)
{
ArrayList SQLString = new ArrayList( );
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT COUNT(1) FROM R_PQDJ WHERE DJ001='{0}'", oddNum);
if (SqlHelper.Exists(strSql.ToString( )) == true)
{
return;
}
MulaolaoLibrary.QualityFinalInspsctionDJEntity _dj = new MulaolaoLibrary.QualityFinalInspsctionDJEntity( );
_dj.DJ001 = oddNum;
add_di(_dj, SQLString);
_dj.DJ002 = "极严重缺陷不允许";
_dj.DJ003 = "木质虫蛀、霉烂、利器、蚊虫";
_dj.DJ004 = "不应出现，管理措施符合情况";
add_dj(_dj, SQLString);
_dj.DJ002 = "极严重缺陷不允许";
_dj.DJ003 = "童床、摇篮等绳索";
_dj.DJ004 = "不应松脱、断裂";
add_dj(_dj, SQLString);
_dj.DJ002 = "极严重缺陷不允许";
_dj.DJ003 = "可拆卸小零件";
_dj.DJ004 = "不得容入小圆桶";
add_dj(_dj, SQLString);
_dj.DJ002 = "极严重缺陷不允许";
_dj.DJ003 = "不可拆卸小零件";
_dj.DJ004 = "90N力不脱落";
add_dj(_dj, SQLString);
_dj.DJ002 = "极严重缺陷不允许";
_dj.DJ003 = "尖端、快口";
_dj.DJ004 = "不应有危机安全的尖端和快口";
add_dj(_dj, SQLString);
_dj.DJ002 = "极严重缺陷不允许";
_dj.DJ003 = "塑料袋厚度";
_dj.DJ004 = "≥0.038mm";
add_dj(_dj, SQLString);
_dj.DJ002 = "极严重缺陷不允许";
_dj.DJ003 = "警告标识、标签和使用说明";
_dj.DJ004 = "品质检验规程相关要求";
add_dj(_dj, SQLString);
_dj.DJ002 = "严重缺陷AQL=1.5";
_dj.DJ003 = "含水率";
_dj.DJ004 = "应小于14%，是否有R - 122表记录";
add_dj(_dj, SQLString);
_dj.DJ002 = "严重缺陷AQL=1.5";
_dj.DJ003 = "木质基质";
_dj.DJ004 = "不得有黑点、结疤、裂纹、明显色差";
add_dj(_dj, SQLString);
_dj.DJ002 = "严重缺陷AQL=1.5";
_dj.DJ003 = "产品功能";
_dj.DJ004 = "不应出现功能性缺陷";
add_dj(_dj, SQLString);
_dj.DJ002 = "严重缺陷AQL=1.5";
_dj.DJ003 = "装配质量";
_dj.DJ004 = "装配平整、牢固、活动灵活，无卡滞";
add_dj(_dj, SQLString);
_dj.DJ002 = "轻微缺陷AQL=4.0";
_dj.DJ003 = "木制零件外观";
_dj.DJ004 = "形状一致、无起翘、变形、毛刺、划痕";
add_dj(_dj, SQLString);
_dj.DJ002 = "轻微缺陷AQL=4.0";
_dj.DJ003 = "塑料零件外观";
_dj.DJ004 = "不得有气孔、裂痕、变形、溢边";
add_dj(_dj, SQLString);
_dj.DJ002 = "轻微缺陷AQL=4.0";
_dj.DJ003 = "镀膜零件外观";
_dj.DJ004 = "不得有气泡、剥落、露底";
add_dj(_dj, SQLString);
_dj.DJ002 = "轻微缺陷AQL=4.0";
_dj.DJ003 = "表面涂层";
_dj.DJ004 = "不得有堆漆、染色、剥落、露底、泛白、色差";
add_dj(_dj, SQLString);
_dj.DJ002 = "轻微缺陷AQL=4.0";
_dj.DJ003 = "印刷、彩绘";
_dj.DJ004 = "印刷位置、色泽、图案、唛头文字符合封样要求";
add_dj(_dj, SQLString);
_dj.DJ002 = "轻微缺陷AQL=4.0";
_dj.DJ003 = "清洁度";
_dj.DJ004 = "不得有污迹、灰尘、头发、杂物";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = "跌落测试";
_dj.DJ004 = "EN71测试标准：850mm×5times";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = "跌落测试";
_dj.DJ004 = "ASTM测试标准0 - 18：1370mm×10times＜1.4kg 18 - 36：910mm×4times＜1.8kg 36 - 96：910mm×4times＜4.5kg";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = "拉力测试";
_dj.DJ004 = "EN71测试标准：￠≤6mm 50N￠＞6mm 90N";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = "拉力测试";
_dj.DJ004 = "ASTM测试标准:0-18：44.5N 18 - 96：66.8N";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = "扭力测试";
_dj.DJ004 = "EN71测试标准：0.34Nm";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = "扭力测试";
_dj.DJ004 = "ASTM测试标准：0-18：0.23Nm 18 - 36：0.34Nm 36 - 96：0.45Nm";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = "压力测试";
_dj.DJ004 = "EN71测试标准：110N";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = "压力测试";
_dj.DJ004 = "ASTM测试标准：0-18：89N 18-36：111.3N 36-96：133.5N";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = "摔箱测试";
_dj.DJ004 = "产品功能须正常；产品表面、包装本身不能有较大受损；产品配件不能松动或脱落";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = string.Empty;
_dj.DJ004 = "主要原材料、配件是否齐全";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = string.Empty;
_dj.DJ004 = "包装方法是否符合封样要求";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = string.Empty;
_dj.DJ004 = "包装产品标识是否清楚";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = string.Empty;
_dj.DJ004 = "与登记产品是否一致，部件数量是否齐全、相符";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = string.Empty;
_dj.DJ004 = "包装人员岗前是否培训";
add_dj(_dj, SQLString);
_dj.DJ002 = string.Empty;
_dj.DJ003 = string.Empty;
_dj.DJ004 = "其他";
add_dj(_dj, SQLString);
SqlHelper.ExecuteSqlTran(SQLString);
}
