/// <summary>
/// 保存数据
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public bool Edit(DataTable table)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
MulaolaoLibrary.MaterialEntity _model = new MulaolaoLibrary.MaterialEntity( );
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.EB002 = table.Rows [i] ["EB002"].ToString( );
_model.EB024 = string.IsNullOrEmpty(table.Rows [i] ["EB024"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["EB024"].ToString( ));
_model.EB025 = string.IsNullOrEmpty(table.Rows [i] ["EB025"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["EB025"].ToString( ));
_model.EB026 = string.IsNullOrEmpty(table.Rows [i] ["EB026"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["EB026"].ToString( ));
_model.EB027 = string.IsNullOrEmpty(table.Rows [i] ["EB027"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["EB027"].ToString( ));
_model.EB028 = string.IsNullOrEmpty(table.Rows [i] ["EB028"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["EB028"].ToString( ));
_model.EB031 = string.IsNullOrEmpty(table.Rows [i] ["EB031"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["EB031"].ToString( ));
_model.EB029 = table.Rows [i] ["EB029"].ToString( );
_model.EB030 = table.Rows [i] ["EB030"].ToString( );
editAll(SQLString, strSql, _model);
}
}
else
{
return(false);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void addCarton(MulaolaoLibrary.MaterialEntity _model, StringBuilder strSql, Hashtable SQLString)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQEB (");
strSql.Append("EB001,EB002,EB003,EB004,EB005,EB021,EB022,EB023) ");
strSql.Append("VALUES (");
strSql.Append("@EB001,@EB002,@EB003,@EB004,@EB005,@EB021,@EB022,@EB023) ");
SqlParameter [] parameter =
{
new SqlParameter("@EB001", SqlDbType.NVarChar, 50),
new SqlParameter("@EB002", SqlDbType.NVarChar, 50),
new SqlParameter("@EB003", SqlDbType.NVarChar, 50),
new SqlParameter("@EB004", SqlDbType.Int, 4),
new SqlParameter("@EB005", SqlDbType.Date, 3),
new SqlParameter("@EB021", SqlDbType.Decimal, 18),
new SqlParameter("@EB022", SqlDbType.Decimal, 18),
new SqlParameter("@EB023", SqlDbType.Decimal, 18)
};
parameter [0].Value = _model.EB001;
parameter [1].Value = _model.EB002;
parameter [2].Value = _model.EB003;
parameter [3].Value = _model.EB004;
parameter [4].Value = _model.EB005;
parameter [5].Value = _model.EB021;
parameter [6].Value = _model.EB022;
parameter [7].Value = _model.EB023;
SQLString.Add(strSql, parameter);
}
/// <summary>
/// 是否存在此流水号
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
bool Exists(MulaolaoLibrary.MaterialEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT COUNT(1) FROM R_PQEB WHERE EB002='{0}'", _model.EB002);
return(SqlHelper.Exists(strSql.ToString( )));
}
public FormMaterial( )
{
InitializeComponent( );
_bll = new MulaolaoBll.Bll.MaterialBLL( );
_entity = new MulaolaoLibrary.MaterialEntity( );
GridViewMoHuSelect.SetFilter(bandedGridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { this.bandedGridView1 });
MulaolaoBll.UserInfoMation.tableName = this.Name;
toolSave.Enabled = true;
toolExport.Enabled = true;
}
void editCarton(MulaolaoLibrary.MaterialEntity _model, StringBuilder strSql, Hashtable SQLString)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQEB SET ");
strSql.Append("EB021=@EB021,");
strSql.Append("EB022=@EB022,");
strSql.Append("EB023=@EB023 ");
strSql.Append("WHERE EB002=@EB002");
SqlParameter [] parameter =
{
new SqlParameter("@EB002", SqlDbType.NVarChar, 50),
new SqlParameter("@EB021", SqlDbType.Decimal, 18),
new SqlParameter("@EB022", SqlDbType.Decimal, 18),
new SqlParameter("@EB023", SqlDbType.Decimal, 18)
};
parameter [0].Value = _model.EB002;
parameter [1].Value = _model.EB021;
parameter [2].Value = _model.EB022;
parameter [3].Value = _model.EB023;
SQLString.Add(strSql, parameter);
}
void editOutSource(MulaolaoLibrary.MaterialEntity _model, StringBuilder strSql, Hashtable SQLString)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQEB SET ");
strSql.Append("EB018=@EB018,");
strSql.Append("EB019=@EB019,");
strSql.Append("EB020=@EB020 ");
strSql.Append("WHERE EB002=@EB002");
SqlParameter [] parameter =
{
new SqlParameter("@EB002", SqlDbType.NVarChar, 50),
new SqlParameter("@EB018", SqlDbType.Decimal, 18),
new SqlParameter("@EB019", SqlDbType.Decimal, 18),
new SqlParameter("@EB020", SqlDbType.Decimal, 18)
};
parameter [0].Value = _model.EB002;
parameter [1].Value = _model.EB018;
parameter [2].Value = _model.EB019;
parameter [3].Value = _model.EB020;
SQLString.Add(strSql, parameter);
}
void editCarWood(MulaolaoLibrary.MaterialEntity _model, StringBuilder strSql, Hashtable SQLString)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQEB SET ");
strSql.Append("EB015=@EB015,");
strSql.Append("EB016=@EB016,");
strSql.Append("EB017=@EB017 ");
strSql.Append("WHERE EB002=@EB002");
SqlParameter [] parameter =
{
new SqlParameter("@EB002", SqlDbType.NVarChar, 50),
new SqlParameter("@EB015", SqlDbType.Decimal, 18),
new SqlParameter("@EB016", SqlDbType.Decimal, 18),
new SqlParameter("@EB017", SqlDbType.Decimal, 18)
};
parameter [0].Value = _model.EB002;
parameter [1].Value = _model.EB015;
parameter [2].Value = _model.EB016;
parameter [3].Value = _model.EB017;
SQLString.Add(strSql, parameter);
}
void editAll(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.MaterialEntity _model)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQEB SET ");
strSql.Append("EB024=@EB024,");
strSql.Append("EB025=@EB025,");
strSql.Append("EB026=@EB026,");
strSql.Append("EB027=@EB027,");
strSql.Append("EB028=@EB028,");
strSql.Append("EB029=@EB029,");
strSql.Append("EB030=@EB030,");
strSql.Append("EB031=@EB031 ");
strSql.Append("WHERE EB002=@EB002 ");
SqlParameter [] parameter =
{
new SqlParameter("@EB002", SqlDbType.NVarChar, 50),
new SqlParameter("@EB024", SqlDbType.Decimal, 18),
new SqlParameter("@EB025", SqlDbType.Decimal, 18),
new SqlParameter("@EB026", SqlDbType.Decimal, 18),
new SqlParameter("@EB027", SqlDbType.Decimal, 18),
new SqlParameter("@EB028", SqlDbType.Decimal, 18),
new SqlParameter("@EB029", SqlDbType.NVarChar, 50),
new SqlParameter("@EB030", SqlDbType.NVarChar, 50),
new SqlParameter("@EB031", SqlDbType.Decimal, 18),
};
parameter [0].Value = _model.EB002;
parameter [1].Value = _model.EB024;
parameter [2].Value = _model.EB025;
parameter [3].Value = _model.EB026;
parameter [4].Value = _model.EB027;
parameter [5].Value = _model.EB028;
parameter [6].Value = _model.EB029;
parameter [7].Value = _model.EB030;
parameter [8].Value = _model.EB031;
SQLString.Add(strSql, parameter);
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
public bool Save(string strWhere, string num)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
MulaolaoLibrary.MaterialEntity _model = new MulaolaoLibrary.MaterialEntity( );
#region 木材
DataTable table = getWood(strWhere, num);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.EB001 = table.Rows [i] ["AM003"].ToString( );
_model.EB002 = table.Rows [i] ["AM002"].ToString( );
_model.EB003 = table.Rows [i] ["AM005"].ToString( );
_model.EB004 = string.IsNullOrEmpty(table.Rows [i] ["AM006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["AM006"].ToString( ));
if (string.IsNullOrEmpty(table.Rows [i] ["PQF31"].ToString( )))
{
_model.EB005 = null;
}
else
{
_model.EB005 = Convert.ToDateTime(table.Rows [i] ["PQF31"].ToString( ));
}
_model.EB006 = string.IsNullOrEmpty(table.Rows [i] ["GS04"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["GS04"].ToString( ));
_model.EB007 = string.IsNullOrEmpty(table.Rows [i] ["SWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["SWOODNOW"].ToString( ));
_model.EB008 = string.IsNullOrEmpty(table.Rows [i] ["YWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["YWOODNOW"].ToString( ));
if (Exists(_model))
{
editWood(_model, strSql, SQLString);
}
else
{
addWood(_model, strSql, SQLString);
}
}
}
#endregion
#region 胶板料
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
table = getJM(strWhere, num);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.EB001 = table.Rows [i] ["AM003"].ToString( );
_model.EB002 = table.Rows [i] ["AM002"].ToString( );
_model.EB003 = table.Rows [i] ["AM005"].ToString( );
_model.EB004 = string.IsNullOrEmpty(table.Rows [i] ["AM006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["AM006"].ToString( ));
if (string.IsNullOrEmpty(table.Rows [i] ["PQF31"].ToString( )))
{
_model.EB005 = null;
}
else
{
_model.EB005 = Convert.ToDateTime(table.Rows [i] ["PQF31"].ToString( ));
}
_model.EB009 = string.IsNullOrEmpty(table.Rows [i] ["GS04"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["GS04"].ToString( ));
_model.EB010 = string.IsNullOrEmpty(table.Rows [i] ["SWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["SWOODNOW"].ToString( ));
_model.EB011 = string.IsNullOrEmpty(table.Rows [i] ["YWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["YWOODNOW"].ToString( ));
if (Exists(_model))
{
editJM(_model, strSql, SQLString);
}
else
{
addJM(_model, strSql, SQLString);
}
}
}
}
else
{
return(false);
}
#endregion
#region 塑铁布
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
table = getPlastic(strWhere, num);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.EB001 = table.Rows [i] ["AM003"].ToString( );
_model.EB002 = table.Rows [i] ["AM002"].ToString( );
_model.EB003 = table.Rows [i] ["AM005"].ToString( );
_model.EB004 = string.IsNullOrEmpty(table.Rows [i] ["AM006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["AM006"].ToString( ));
if (string.IsNullOrEmpty(table.Rows [i] ["PQF31"].ToString( )))
{
_model.EB005 = null;
}
else
{
_model.EB005 = Convert.ToDateTime(table.Rows [i] ["PQF31"].ToString( ));
}
_model.EB012 = string.IsNullOrEmpty(table.Rows [i] ["GS04"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["GS04"].ToString( ));
_model.EB013 = string.IsNullOrEmpty(table.Rows [i] ["SWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["SWOODNOW"].ToString( ));
_model.EB014 = string.IsNullOrEmpty(table.Rows [i] ["YWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["YWOODNOW"].ToString( ));
if (Exists(_model))
{
editPlastic(_model, strSql, SQLString);
}
else
{
addPlastic(_model, strSql, SQLString);
}
}
}
}
else
{
return(false);
}
#endregion
#region 车木件
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
table = getCarWood(strWhere, num);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.EB001 = table.Rows [i] ["AM003"].ToString( );
_model.EB002 = table.Rows [i] ["AM002"].ToString( );
_model.EB003 = table.Rows [i] ["AM005"].ToString( );
_model.EB004 = string.IsNullOrEmpty(table.Rows [i] ["AM006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["AM006"].ToString( ));
if (string.IsNullOrEmpty(table.Rows [i] ["PQF31"].ToString( )))
{
_model.EB005 = null;
}
else
{
_model.EB005 = Convert.ToDateTime(table.Rows [i] ["PQF31"].ToString( ));
}
_model.EB015 = string.IsNullOrEmpty(table.Rows [i] ["GS04"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["GS04"].ToString( ));
_model.EB016 = string.IsNullOrEmpty(table.Rows [i] ["SWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["SWOODNOW"].ToString( ));
_model.EB017 = string.IsNullOrEmpty(table.Rows [i] ["YWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["YWOODNOW"].ToString( ));
if (Exists(_model))
{
editCarWood(_model, strSql, SQLString);
}
else
{
addCarWood(_model, strSql, SQLString);
}
}
}
}
else
{
return(false);
}
#endregion
#region 委外
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
table = getOutSource(strWhere);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.EB001 = table.Rows [i] ["AM003"].ToString( );
_model.EB002 = table.Rows [i] ["AM002"].ToString( );
_model.EB003 = table.Rows [i] ["AM005"].ToString( );
_model.EB004 = string.IsNullOrEmpty(table.Rows [i] ["AM006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["AM006"].ToString( ));
if (string.IsNullOrEmpty(table.Rows [i] ["PQF31"].ToString( )))
{
_model.EB005 = null;
}
else
{
_model.EB005 = Convert.ToDateTime(table.Rows [i] ["PQF31"].ToString( ));
}
_model.EB018 = 0;
_model.EB019 = string.IsNullOrEmpty(table.Rows [i] ["SWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["SWOODNOW"].ToString( ));
_model.EB020 = string.IsNullOrEmpty(table.Rows [i] ["YWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["YWOODNOW"].ToString( ));
if (Exists(_model))
{
editOutSource(_model, strSql, SQLString);
}
else
{
addOutSource(_model, strSql, SQLString);
}
}
}
}
else
{
return(false);
}
#endregion
#region 纸箱
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
table = getCarton(strWhere, num);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.EB001 = table.Rows [i] ["AM003"].ToString( );
_model.EB002 = table.Rows [i] ["AM002"].ToString( );
_model.EB003 = table.Rows [i] ["AM005"].ToString( );
_model.EB004 = string.IsNullOrEmpty(table.Rows [i] ["AM006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["AM006"].ToString( ));
if (string.IsNullOrEmpty(table.Rows [i] ["PQF31"].ToString( )))
{
_model.EB005 = null;
}
else
{
_model.EB005 = Convert.ToDateTime(table.Rows [i] ["PQF31"].ToString( ));
}
_model.EB021 = string.IsNullOrEmpty(table.Rows [i] ["GS04"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["GS04"].ToString( ));
_model.EB022 = string.IsNullOrEmpty(table.Rows [i] ["SWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["SWOODNOW"].ToString( ));
_model.EB023 = string.IsNullOrEmpty(table.Rows [i] ["YWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["YWOODNOW"].ToString( ));
if (Exists(_model))
{
editCarton(_model, strSql, SQLString);
}
else
{
addCarton(_model, strSql, SQLString);
}
}
}
}
else
{
return(false);
}
#endregion
return(SqlHelper.ExecuteSqlTran(SQLString));
}
