/// <summary>
/// exists this year and month
/// </summary>
/// <param name="year"></param>
/// <param name="month"></param>
/// <returns></returns>
bool Exists(MulaolaoLibrary.CustomerInspectionTableDMEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM R_PQDM ");
strSql.AppendFormat("WHERE DM001={0} AND DM004={1} AND DM002='{2}' AND DM003='{3}'", model.DM001, model.DM004, model.DM002, model.DM003);
return(SqlHelper.Exists(strSql.ToString( )));
}
void editdm009(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerInspectionTableDMEntity model)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQDM SET ");
strSql.AppendFormat("DM009={0} ", model.DM009);
strSql.AppendFormat("WHERE DM001={0} AND DM004={1} AND DM002='{2}' AND DM003='{3}'", model.DM001, model.DM004, model.DM002, model.DM003);
SQLString.Add(strSql, null);
}
void adddm005(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerInspectionTableDMEntity model)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQDM (");
strSql.Append("DM001,DM002,DM003,DM004,DM005,DM006,DM007,DM008,DM009) ");
strSql.Append("VALUES (");
strSql.AppendFormat("{0},'{1}','{2}',{3},{4},{5},{6},{7},{8})", model.DM001, model.DM002, model.DM003, model.DM004, model.DM005, model.DM006, model.DM007, model.DM008, model.DM009);
SQLString.Add(strSql, null);
}
public FormCustomerInspectionTable( )
{
InitializeComponent( );
_dm = new MulaolaoLibrary.CustomerInspectionTableDMEntity( );
_bll = new MulaolaoBll.Bll.CustomerInspectionTableBll( );
GridViewMoHuSelect.SetFilter(gridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 });
MulaolaoBll.UserInfoMation.tableName = this.Name;
toolDelete.Enabled = true;
}
/// <summary>
/// read data from r_293 to view
/// </summary>
/// <param name="year"></param>
/// <returns></returns>
public bool Read(int year)
{
//398
//出货批次=直通批次+二次通过+条件接受
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("DELETE FROM R_PQDM WHERE DM001='{0}'", year);
SQLString.Add(strSql, null);
if (SQLString.Count > 0 && SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
MulaolaoLibrary.CustomerInspectionTableDMEntity model = new MulaolaoLibrary.CustomerInspectionTableDMEntity( );
model.DM001 = year;
//怡人 出货批次
DataTable da = getTableCount(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM005 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
if (model.DM004 > 0)
{
if (Exists(model))
{
editdm005(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
if (SQLString.Count > 0 && SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
//班组合计 出货批次
da = getTableCountAll(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM005 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
if (model.DM004 > 0)
{
if (Exists(model))
{
editdm005(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
}
}
if (SQLString.Count > 0 && SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
// 怡人 通过
da = getTableOneCount(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM006 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
model.DM005 = 0;
model.DM007 = 0;
model.DM008 = 0;
model.DM009 = 0;
if (Exists(model))
{
editdm006(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
}
if (SQLString.Count > 0 && SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
//班组合计 通过
da = getTableOneCountAll(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM006 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
model.DM005 = 0;
model.DM007 = 0;
model.DM008 = 0;
model.DM009 = 0;
if (Exists(model))
{
editdm006(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
}
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
//怡人 二次通过
da = getTableThanOneCount(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM007 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
model.DM005 = 0;
model.DM006 = 0;
model.DM008 = 0;
model.DM009 = 0;
if (Exists(model))
{
editdm007(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
}
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
//班组合计 二次通过
da = getTableThanOneCountAll(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM007 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
model.DM005 = 0;
model.DM006 = 0;
model.DM008 = 0;
model.DM009 = 0;
if (Exists(model))
{
editdm007(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
}
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
//怡人 退货
da = getTableThCount(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM008 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
model.DM005 = 0;
model.DM006 = 0;
model.DM007 = 0;
model.DM009 = 0;
if (Exists(model))
{
editdm008(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
}
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
//班组合计 退货
da = getTableThCountAll(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM008 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
model.DM005 = 0;
model.DM006 = 0;
model.DM007 = 0;
model.DM009 = 0;
if (Exists(model))
{
editdm008(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
}
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
//怡人 条件接收
da = getTableTjCount(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM009 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
model.DM005 = 0;
model.DM006 = 0;
model.DM007 = 0;
model.DM008 = 0;
if (Exists(model))
{
editdm009(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
}
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
//班组合计 条件接收
da = getTableTjCountAll(year);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
model.DM002 = da.Rows [i] ["DK007"].ToString( );
model.DM003 = da.Rows [i] ["DK008"].ToString( );
model.DM004 = string.IsNullOrEmpty(da.Rows [i] ["DK015"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["DK015"].ToString( ));
model.DM009 = string.IsNullOrEmpty(da.Rows [i] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["COUN"].ToString( ));
model.DM005 = 0;
model.DM006 = 0;
model.DM007 = 0;
model.DM008 = 0;
if (Exists(model))
{
editdm009(SQLString, strSql, model);
}
else
{
adddm005(SQLString, strSql, model);
}
}
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
}
else
{
return(false);
}
return(true);
}
