void EditBodyTwo(Dictionary <object, object> SQLString, LineProductMesEntityu.LogisticsNewBodyTwoEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update MIKLGP set ");
strSql.Append("LGP002=@LGP002,");
strSql.Append("LGP003=@LGP003,");
strSql.Append("LGP004=@LGP004,");
strSql.Append("LGP005=@LGP005,");
strSql.Append("LGP006=@LGP006,");
strSql.Append("LGP007=@LGP007,");
strSql.Append("LGP008=@LGP008,");
strSql.Append("LGP009=@LGP009,");
strSql.Append("LGP010=@LGP010,");
strSql.Append("LGP011=@LGP011,");
strSql.Append("LGP012=@LGP012,");
strSql.Append("LGP013=@LGP013,");
strSql.Append("LGP014=@LGP014,");
strSql.Append("LGP015=@LGP015 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@LGP003", SqlDbType.NVarChar, 20),
new SqlParameter("@LGP004", SqlDbType.NVarChar, 20),
new SqlParameter("@LGP005", SqlDbType.NVarChar, 5),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@LGP002", SqlDbType.NVarChar, 20),
new SqlParameter("@LGP006", SqlDbType.NVarChar, 20),
new SqlParameter("@LGP007", SqlDbType.DateTime, 3),
new SqlParameter("@LGP008", SqlDbType.DateTime, 3),
new SqlParameter("@LGP009", SqlDbType.DateTime, 3),
new SqlParameter("@LGP010", SqlDbType.DateTime, 3),
new SqlParameter("@LGP011", SqlDbType.Decimal, 9),
new SqlParameter("@LGP012", SqlDbType.Decimal, 9),
new SqlParameter("@LGP013", SqlDbType.Decimal, 9),
new SqlParameter("@LGP014", SqlDbType.Decimal, 9),
new SqlParameter("@LGP015", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.LGP003;
parameters [1].Value = model.LGP004;
parameters [2].Value = model.LGP005;
parameters [3].Value = model.idx;
parameters [4].Value = model.LGP002;
parameters [5].Value = model.LGP006;
parameters [6].Value = model.LGP007;
parameters [7].Value = model.LGP008;
parameters [8].Value = model.LGP009;
parameters [9].Value = model.LGP010;
parameters [10].Value = model.LGP011;
parameters [11].Value = model.LGP012;
parameters [12].Value = model.LGP013;
parameters [13].Value = model.LGP014;
parameters [14].Value = model.LGP015;
SQLString.Add(strSql, parameters);
}
void AddBodyTwo(Dictionary <object, object> SQLString, LineProductMesEntityu.LogisticsNewBodyTwoEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into MIKLGP(");
strSql.Append("LGP001,LGP002,LGP003,LGP004,LGP005,LGP006,LGP007,LGP008,LGP009,LGP010,LGP011,LGP012,LGP013,LGP014,LGP015)");
strSql.Append(" values (");
strSql.Append("@LGP001,@LGP002,@LGP003,@LGP004,@LGP005,@LGP006,@LGP007,@LGP008,@LGP009,@LGP010,@LGP011,@LGP012,@LGP013,@LGP014,@LGP015)");
SqlParameter [] parameters =
{
new SqlParameter("@LGP001", SqlDbType.NVarChar, 20),
new SqlParameter("@LGP002", SqlDbType.NVarChar, 20),
new SqlParameter("@LGP003", SqlDbType.NVarChar, 20),
new SqlParameter("@LGP004", SqlDbType.NVarChar, 20),
new SqlParameter("@LGP005", SqlDbType.NVarChar, 5),
new SqlParameter("@LGP006", SqlDbType.NVarChar, 20),
new SqlParameter("@LGP007", SqlDbType.DateTime, 3),
new SqlParameter("@LGP008", SqlDbType.DateTime, 3),
new SqlParameter("@LGP009", SqlDbType.DateTime, 3),
new SqlParameter("@LGP010", SqlDbType.DateTime, 3),
new SqlParameter("@LGP011", SqlDbType.Decimal, 9),
new SqlParameter("@LGP012", SqlDbType.Decimal, 9),
new SqlParameter("@LGP013", SqlDbType.Decimal, 9),
new SqlParameter("@LGP014", SqlDbType.Decimal, 9),
new SqlParameter("@LGP015", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.LGP001;
parameters [1].Value = model.LGP002;
parameters [2].Value = model.LGP003;
parameters [3].Value = model.LGP004;
parameters [4].Value = model.LGP005;
parameters [5].Value = model.LGP006;
parameters [6].Value = model.LGP007;
parameters [7].Value = model.LGP008;
parameters [8].Value = model.LGP009;
parameters [9].Value = model.LGP010;
parameters [10].Value = model.LGP011;
parameters [11].Value = model.LGP012;
parameters [12].Value = model.LGP013;
parameters [13].Value = model.LGP014;
parameters [14].Value = model.LGP015;
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));
}
