void AddBodyOne(Dictionary <object, object> SQLString, LineProductMesEntityu.LogisticsNewBodyOneEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into MIKLGO(");
strSql.Append("LOG001,LOG002,LOG003,LOG004,LOG005,LOG006,LOG007,LOG008,LOG009)");
strSql.Append(" values (");
strSql.Append("@LOG001,@LOG002,@LOG003,@LOG004,@LOG005,@LOG006,@LOG007,@LOG008,@LOG009)");
SqlParameter [] parameters =
{
new SqlParameter("@LOG001", SqlDbType.NVarChar, 20),
new SqlParameter("@LOG002", SqlDbType.NVarChar, 20),
new SqlParameter("@LOG003", SqlDbType.NVarChar, 20),
new SqlParameter("@LOG004", SqlDbType.NVarChar, 20),
new SqlParameter("@LOG005", SqlDbType.NVarChar, 50),
new SqlParameter("@LOG006", SqlDbType.Int, 4),
new SqlParameter("@LOG007", SqlDbType.Decimal, 9),
new SqlParameter("@LOG008", SqlDbType.Int, 4),
new SqlParameter("@LOG009", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.LOG001;
parameters [1].Value = model.LOG002;
parameters [2].Value = model.LOG003;
parameters [3].Value = model.LOG004;
parameters [4].Value = model.LOG005;
parameters [5].Value = model.LOG006;
parameters [6].Value = model.LOG007;
parameters [7].Value = model.LOG008;
parameters [8].Value = model.LOG009;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 完工数量是否多于数量
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(LineProductMesEntityu.LogisticsNewBodyOneEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT SUM(LOG008) LOG008 FROM MIKLGO WHERE LOG001!='{0}' AND LOG002='{1}' AND LOG003='{2}' ", model.LOG001, model.LOG002, model.LOG003);
DataTable table = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (table == null || table.Rows.Count < 1)
{
return(false);
}
int resu = string.IsNullOrEmpty(table.Rows [0] ["LOG008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [0] ["LOG008"].ToString( ));
if (resu + model.LOG008 > model.LOG006)
{
return(true);
}
return(false);
}
void EditBodyOne(Dictionary <object, object> SQLString, LineProductMesEntityu.LogisticsNewBodyOneEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update MIKLGO set ");
strSql.Append("LOG002=@LOG002,");
strSql.Append("LOG003=@LOG003,");
strSql.Append("LOG004=@LOG004,");
strSql.Append("LOG005=@LOG005,");
strSql.Append("LOG006=@LOG006,");
strSql.Append("LOG007=@LOG007,");
strSql.Append("LOG008=@LOG008,");
strSql.Append("LOG009=@LOG009");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@LOG004", SqlDbType.NVarChar, 20),
new SqlParameter("@LOG005", SqlDbType.NVarChar, 50),
new SqlParameter("@LOG006", SqlDbType.Int, 4),
new SqlParameter("@LOG007", SqlDbType.Decimal, 9),
new SqlParameter("@LOG008", SqlDbType.Int, 4),
new SqlParameter("@LOG009", SqlDbType.Decimal, 9),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@LOG002", SqlDbType.NVarChar, 20),
new SqlParameter("@LOG003", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.LOG004;
parameters [1].Value = model.LOG005;
parameters [2].Value = model.LOG006;
parameters [3].Value = model.LOG007;
parameters [4].Value = model.LOG008;
parameters [5].Value = model.LOG009;
parameters [6].Value = model.idx;
parameters [7].Value = model.LOG002;
parameters [8].Value = model.LOG003;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 编辑保存数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableOne"></param>
/// <param name="tableTwo"></param>
/// <param name="listOne"></param>
/// <param name="listTwo"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.LogisticsNewHeaderEntity model, DataTable tableOne, DataTable tableTwo, List <string> listOne, List <string> listTwo)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
StringBuilder strSql = new StringBuilder( );
EditHeader(SQLString, model);
LineProductMesEntityu.LogisticsNewBodyOneEntity bodyOne = new LineProductMesEntityu.LogisticsNewBodyOneEntity( );
bodyOne.LOG001 = model.LGN001;
foreach (DataRow row in tableOne.Rows)
{
bodyOne.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
bodyOne.LOG002 = row ["LOG002"].ToString( );
bodyOne.LOG003 = row ["LOG003"].ToString( );
bodyOne.LOG004 = row ["LOG004"].ToString( );
bodyOne.LOG005 = row ["LOG005"].ToString( );
bodyOne.LOG006 = string.IsNullOrEmpty(row ["LOG006"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LOG006"].ToString( ));
bodyOne.LOG007 = string.IsNullOrEmpty(row ["LOG007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LOG007"].ToString( ));
bodyOne.LOG008 = string.IsNullOrEmpty(row ["LOG008"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LOG008"].ToString( ));
bodyOne.LOG009 = string.IsNullOrEmpty(row ["LOG009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LOG009"].ToString( ));
if (bodyOne.idx < 0)
{
AddBodyOne(SQLString, bodyOne);
}
else
{
EditBodyOne(SQLString, bodyOne);
}
}
LineProductMesEntityu.LogisticsNewBodyTwoEntity bodyTwo = new LineProductMesEntityu.LogisticsNewBodyTwoEntity( );
bodyTwo.LGP001 = model.LGN001;
foreach (DataRow row in tableTwo.Rows)
{
bodyTwo.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
bodyTwo.LGP002 = row ["LGP002"].ToString( );
bodyTwo.LGP003 = row ["LGP003"].ToString( );
bodyTwo.LGP004 = row ["LGP004"].ToString( );
bodyTwo.LGP005 = row ["LGP005"].ToString( );
bodyTwo.LGP006 = row ["LGP006"].ToString( );
if (row ["LGP007"] == null || row ["LGP007"].ToString( ) == string.Empty)
{
bodyTwo.LGP007 = null;
}
else
{
bodyTwo.LGP007 = Convert.ToDateTime(row ["LGP007"]);
}
if (row ["LGP008"] == null || row ["LGP008"].ToString( ) == string.Empty)
{
bodyTwo.LGP008 = null;
}
else
{
bodyTwo.LGP008 = Convert.ToDateTime(row ["LGP008"]);
}
if (row ["LGP009"] == null || row ["LGP009"].ToString( ) == string.Empty)
{
bodyTwo.LGP009 = null;
}
else
{
bodyTwo.LGP009 = Convert.ToDateTime(row ["LGP009"]);
}
if (row ["LGP010"] == null || row ["LGP010"].ToString( ) == string.Empty)
{
bodyTwo.LGP010 = null;
}
else
{
bodyTwo.LGP010 = Convert.ToDateTime(row ["LGP010"]);
}
if (row ["LGP011"] == null || row ["LGP011"].ToString( ) == string.Empty)
{
bodyTwo.LGP011 = null;
}
else
{
bodyTwo.LGP011 = Convert.ToDecimal(row ["LGP011"]);
}
if (row ["LGP012"] == null || row ["LGP012"].ToString( ) == string.Empty)
{
bodyTwo.LGP012 = null;
}
else
{
bodyTwo.LGP012 = Convert.ToDecimal(row ["LGP012"]);
}
if (row ["LGP013"] == null || row ["LGP013"].ToString( ) == string.Empty)
{
bodyTwo.LGP013 = null;
}
else
{
bodyTwo.LGP013 = Convert.ToDecimal(row ["LGP013"]);
}
if (row ["LGP014"] == null || row ["LGP014"].ToString( ) == string.Empty)
{
bodyTwo.LGP014 = null;
}
else
{
bodyTwo.LGP014 = Convert.ToDecimal(row ["LGP014"]);
}
if (row ["LGP015"] == null || row ["LGP015"].ToString( ) == string.Empty)
{
bodyTwo.LGP015 = null;
}
else
{
bodyTwo.LGP015 = Convert.ToDecimal(row ["LGP015"]);
}
if (bodyTwo.idx < 0)
{
AddBodyTwo(SQLString, bodyTwo);
}
else
{
EditBodyTwo(SQLString, bodyTwo);
}
}
foreach (string s in listOne)
{
DeleteBodyOne(SQLString, s);
}
foreach (string s in listTwo)
{
DeleteBodyTwo(SQLString, s);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableOne"></param>
/// <param name="tableTwo"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.LogisticsNewHeaderEntity model, DataTable tableOne, DataTable tableTwo)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
StringBuilder strSql = new StringBuilder( );
model.LGN001 = getCode( );
model.LGN008 = UserInfoMation.userName;
AddHeader(SQLString, model);
UserInfoMation.oddNum = model.LGN001;
LineProductMesEntityu.LogisticsNewBodyOneEntity bodyOne = new LineProductMesEntityu.LogisticsNewBodyOneEntity( );
bodyOne.LOG001 = model.LGN001;
foreach (DataRow row in tableOne.Rows)
{
bodyOne.LOG002 = row ["LOG002"].ToString( );
bodyOne.LOG003 = row ["LOG003"].ToString( );
bodyOne.LOG004 = row ["LOG004"].ToString( );
bodyOne.LOG005 = row ["LOG005"].ToString( );
bodyOne.LOG006 = string.IsNullOrEmpty(row ["LOG006"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LOG006"].ToString( ));
bodyOne.LOG007 = string.IsNullOrEmpty(row ["LOG007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LOG007"].ToString( ));
bodyOne.LOG008 = string.IsNullOrEmpty(row ["LOG008"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LOG008"].ToString( ));
bodyOne.LOG009 = string.IsNullOrEmpty(row ["LOG009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LOG009"].ToString( ));
AddBodyOne(SQLString, bodyOne);
}
LineProductMesEntityu.LogisticsNewBodyTwoEntity bodyTwo = new LineProductMesEntityu.LogisticsNewBodyTwoEntity( );
bodyTwo.LGP001 = model.LGN001;
foreach (DataRow row in tableTwo.Rows)
{
bodyTwo.LGP002 = row ["LGP002"].ToString( );
bodyTwo.LGP003 = row ["LGP003"].ToString( );
bodyTwo.LGP004 = row ["LGP004"].ToString( );
bodyTwo.LGP005 = row ["LGP005"].ToString( );
bodyTwo.LGP006 = row ["LGP006"].ToString( );
if (row ["LGP007"] == null || row ["LGP007"].ToString( ) == string.Empty)
{
bodyTwo.LGP007 = null;
}
else
{
bodyTwo.LGP007 = Convert.ToDateTime(row ["LGP007"]);
}
if (row ["LGP008"] == null || row ["LGP008"].ToString( ) == string.Empty)
{
bodyTwo.LGP008 = null;
}
else
{
bodyTwo.LGP008 = Convert.ToDateTime(row ["LGP008"]);
}
if (row ["LGP009"] == null || row ["LGP009"].ToString( ) == string.Empty)
{
bodyTwo.LGP009 = null;
}
else
{
bodyTwo.LGP009 = Convert.ToDateTime(row ["LGP009"]);
}
if (row ["LGP010"] == null || row ["LGP010"].ToString( ) == string.Empty)
{
bodyTwo.LGP010 = null;
}
else
{
bodyTwo.LGP010 = Convert.ToDateTime(row ["LGP010"]);
}
if (row ["LGP011"] == null || row ["LGP011"].ToString( ) == string.Empty)
{
bodyTwo.LGP011 = null;
}
else
{
bodyTwo.LGP011 = Convert.ToDecimal(row ["LGP011"]);
}
if (row ["LGP012"] == null || row ["LGP012"].ToString( ) == string.Empty)
{
bodyTwo.LGP012 = null;
}
else
{
bodyTwo.LGP012 = Convert.ToDecimal(row ["LGP012"]);
}
if (row ["LGP013"] == null || row ["LGP013"].ToString( ) == string.Empty)
{
bodyTwo.LGP013 = null;
}
else
{
bodyTwo.LGP013 = Convert.ToDecimal(row ["LGP013"]);
}
if (row ["LGP014"] == null || row ["LGP014"].ToString( ) == string.Empty)
{
bodyTwo.LGP014 = null;
}
else
{
bodyTwo.LGP014 = Convert.ToDecimal(row ["LGP014"]);
}
if (row ["LGP015"] == null || row ["LGP015"].ToString( ) == string.Empty)
{
bodyTwo.LGP015 = null;
}
else
{
bodyTwo.LGP015 = Convert.ToDecimal(row ["LGP015"]);
}
AddBodyTwo(SQLString, bodyTwo);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
/// <summary>
/// 完工数量是否多于数量
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(LineProductMesEntityu.LogisticsNewBodyOneEntity model)
{
return(dal.Exists(model));
}
