void EditHeader(Dictionary <object, object> SQLString, LineProductMesEntityu.LogisticsNewHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE MIKLGN SET LGN005=@LGN005,LGN006=@LGN006,LGN007=@LGN007,LGN009=@LGN009,LGN010=@LGN010,LGN011=@LGN011,LGN012=@LGN012 WHERE LGN001=@LGN001");
SqlParameter [] parameters =
{
new SqlParameter("@LGN001", SqlDbType.NVarChar, 20),
new SqlParameter("@LGN005", SqlDbType.Decimal, 9),
new SqlParameter("@LGN006", SqlDbType.Decimal, 9),
new SqlParameter("@LGN007", SqlDbType.NVarChar, 20),
new SqlParameter("@LGN009", SqlDbType.DateTime),
new SqlParameter("@LGN010", SqlDbType.DateTime),
new SqlParameter("@LGN011", SqlDbType.Decimal, 9),
new SqlParameter("@LGN012", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.LGN001;
parameters [1].Value = model.LGN005;
parameters [2].Value = model.LGN006;
parameters [3].Value = model.LGN007;
parameters [4].Value = model.LGN009;
parameters [5].Value = model.LGN010;
parameters [6].Value = model.LGN011;
parameters [7].Value = model.LGN012;
SQLString.Add(strSql, parameters);
}
void AddHeader(Dictionary <object, object> SQLString, LineProductMesEntityu.LogisticsNewHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into MIKLGN(");
strSql.Append("LGN001,LGN002,LGN005,LGN006,LGN007,LGN008,LGN009,LGN010,LGN011,LGN012)");
strSql.Append(" values (");
strSql.Append("@LGN001,@LGN002,@LGN005,@LGN006,@LGN007,@LGN008,@LGN009,@LGN010,@LGN011,@LGN012)");
SqlParameter [] parameters =
{
new SqlParameter("@LGN001", SqlDbType.NVarChar, 20),
new SqlParameter("@LGN002", SqlDbType.Date, 3),
new SqlParameter("@LGN005", SqlDbType.Decimal, 9),
new SqlParameter("@LGN006", SqlDbType.Decimal, 9),
new SqlParameter("@LGN007", SqlDbType.NVarChar, 20),
new SqlParameter("@LGN008", SqlDbType.NVarChar, 20),
new SqlParameter("@LGN009", SqlDbType.DateTime),
new SqlParameter("@LGN010", SqlDbType.DateTime),
new SqlParameter("@LGN011", SqlDbType.Decimal, 9),
new SqlParameter("@LGN012", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.LGN001;
parameters [1].Value = model.LGN002;
parameters [2].Value = model.LGN005;
parameters [3].Value = model.LGN006;
parameters [4].Value = model.LGN007;
parameters [5].Value = model.LGN008;
parameters [6].Value = model.LGN009;
parameters [7].Value = model.LGN010;
parameters [8].Value = model.LGN011;
parameters [9].Value = model.LGN012;
SQLString.Add(strSql, parameters);
}
public LineProductMesEntityu.LogisticsNewHeaderEntity getModel(DataRow row)
{
LineProductMesEntityu.LogisticsNewHeaderEntity model = new LineProductMesEntityu.LogisticsNewHeaderEntity( );
if (row != null)
{
if (row ["LGN001"] != null && row ["LGN001"].ToString( ) != string.Empty)
{
model.LGN001 = row ["LGN001"].ToString( );
}
if (row ["LGN002"] != null && row ["LGN002"].ToString( ) != string.Empty)
{
model.LGN002 = Convert.ToDateTime(row ["LGN002"].ToString( ));
}
if (row ["LGN003"] != null && row ["LGN003"].ToString( ) != string.Empty)
{
model.LGN003 = Convert.ToBoolean(row ["LGN003"].ToString( ));
}
if (row ["LGN004"] != null && row ["LGN004"].ToString( ) != string.Empty)
{
model.LGN004 = Convert.ToBoolean(row ["LGN004"].ToString( ));
}
if (row ["LGN005"] != null && row ["LGN005"].ToString( ) != string.Empty)
{
model.LGN005 = Convert.ToDecimal(row ["LGN005"].ToString( ));
}
if (row ["LGN006"] != null && row ["LGN006"].ToString( ) != string.Empty)
{
model.LGN006 = Convert.ToDecimal(row ["LGN006"].ToString( ));
}
if (row ["LGN007"] != null && row ["LGN007"].ToString( ) != string.Empty)
{
model.LGN007 = row ["LGN007"].ToString( );
}
if (row ["LGN008"] != null && row ["LGN008"].ToString( ) != string.Empty)
{
model.LGN008 = row ["LGN008"].ToString( );
}
if (row ["LGN009"] != null && row ["LGN009"].ToString( ) != string.Empty)
{
model.LGN009 = Convert.ToDateTime(row ["LGN009"].ToString( ));
}
if (row ["LGN010"] != null && row ["LGN010"].ToString( ) != string.Empty)
{
model.LGN010 = Convert.ToDateTime(row ["LGN010"].ToString( ));
}
if (row ["LGN011"] != null && row ["LGN011"].ToString( ) != string.Empty)
{
model.LGN011 = Convert.ToDecimal(row ["LGN011"].ToString( ));
}
if (row ["LGN012"] != null && row ["LGN012"].ToString( ) != string.Empty)
{
model.LGN012 = Convert.ToDecimal(row ["LGN012"].ToString( ));
}
}
return(model);
}
/// <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>
/// <param name="tableOne"></param>
/// <param name="tableTwo"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.LogisticsNewHeaderEntity model, DataTable tableOne, DataTable tableTwo)
{
return(dal.Save(model, tableOne, tableTwo));
}
/// <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)
{
return(dal.Edit(model, tableOne, tableTwo, listOne, listTwo));
}
