void AddBody(Dictionary <object, object> SQLString, LineProductMesEntityu.LEDNewsBodyEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into MIKLEG(");
strSql.Append("LEG001,LEG002,LEG003,LEG004,LEG005,LEG006,LEG007,LEG008,LEG009,LEG010,LEG011,LEG012,LEG013,LEG014,LEG015,LEG016,LEG017)");
strSql.Append(" values (");
strSql.Append("@LEG001,@LEG002,@LEG003,@LEG004,@LEG005,@LEG006,@LEG007,@LEG008,@LEG009,@LEG010,@LEG011,@LEG012,@LEG013,@LEG014,@LEG015,@LEG016,@LEG017)");
SqlParameter [] parameters =
{
new SqlParameter("@LEG001", SqlDbType.NVarChar, 20),
new SqlParameter("@LEG002", SqlDbType.NVarChar, 20),
new SqlParameter("@LEG003", SqlDbType.NVarChar, 20),
new SqlParameter("@LEG004", SqlDbType.NVarChar, 20),
new SqlParameter("@LEG005", SqlDbType.DateTime),
new SqlParameter("@LEG006", SqlDbType.DateTime),
new SqlParameter("@LEG007", SqlDbType.Decimal, 9),
new SqlParameter("@LEG008", SqlDbType.DateTime),
new SqlParameter("@LEG009", SqlDbType.DateTime),
new SqlParameter("@LEG010", SqlDbType.Decimal, 9),
new SqlParameter("@LEG011", SqlDbType.NVarChar, 100),
new SqlParameter("@LEG012", SqlDbType.NVarChar, 5),
new SqlParameter("@LEG013", SqlDbType.NVarChar, 20),
new SqlParameter("@LEG014", SqlDbType.Decimal, 9),
new SqlParameter("@LEG015", SqlDbType.Decimal, 9),
new SqlParameter("@LEG016", SqlDbType.Decimal, 9),
new SqlParameter("@LEG017", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.LEG001;
parameters [1].Value = model.LEG002;
parameters [2].Value = model.LEG003;
parameters [3].Value = model.LEG004;
parameters [4].Value = model.LEG005;
parameters [5].Value = model.LEG006;
parameters [6].Value = model.LEG007;
parameters [7].Value = model.LEG008;
parameters [8].Value = model.LEG009;
parameters [9].Value = model.LEG010;
parameters [10].Value = model.LEG011;
parameters [11].Value = model.LEG012;
parameters [12].Value = model.LEG013;
parameters [13].Value = model.LEG014;
parameters [14].Value = model.LEG015;
parameters [15].Value = model.LEG016;
parameters [16].Value = model.LEG017;
SQLString.Add(strSql, parameters);
}
void EditBody(Dictionary <object, object> SQLString, LineProductMesEntityu.LEDNewsBodyEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update MIKLEG set ");
strSql.Append("LEG002=@LEG002,");
strSql.Append("LEG003=@LEG003,");
strSql.Append("LEG004=@LEG004,");
strSql.Append("LEG005=@LEG005,");
strSql.Append("LEG006=@LEG006,");
strSql.Append("LEG007=@LEG007,");
strSql.Append("LEG008=@LEG008,");
strSql.Append("LEG009=@LEG009,");
strSql.Append("LEG010=@LEG010,");
strSql.Append("LEG011=@LEG011,");
strSql.Append("LEG012=@LEG012,");
strSql.Append("LEG013=@LEG013,");
strSql.Append("LEG014=@LEG014,");
strSql.Append("LEG015=@LEG015,");
strSql.Append("LEG016=@LEG016,");
strSql.Append("LEG017=@LEG017 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@LEG003", SqlDbType.NVarChar, 20),
new SqlParameter("@LEG004", SqlDbType.NVarChar, 20),
new SqlParameter("@LEG005", SqlDbType.DateTime),
new SqlParameter("@LEG006", SqlDbType.DateTime),
new SqlParameter("@LEG007", SqlDbType.Decimal, 9),
new SqlParameter("@LEG008", SqlDbType.DateTime),
new SqlParameter("@LEG009", SqlDbType.DateTime),
new SqlParameter("@LEG010", SqlDbType.Decimal, 9),
new SqlParameter("@LEG011", SqlDbType.NVarChar, 100),
new SqlParameter("@LEG012", SqlDbType.NVarChar, 5),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@LEG002", SqlDbType.NVarChar, 20),
new SqlParameter("@LEG013", SqlDbType.NVarChar, 20),
new SqlParameter("@LEG014", SqlDbType.Decimal),
new SqlParameter("@LEG015", SqlDbType.Decimal),
new SqlParameter("@LEG016", SqlDbType.Decimal),
new SqlParameter("@LEG017", SqlDbType.Decimal)
};
parameters [0].Value = model.LEG003;
parameters [1].Value = model.LEG004;
parameters [2].Value = model.LEG005;
parameters [3].Value = model.LEG006;
parameters [4].Value = model.LEG007;
parameters [5].Value = model.LEG008;
parameters [6].Value = model.LEG009;
parameters [7].Value = model.LEG010;
parameters [8].Value = model.LEG011;
parameters [9].Value = model.LEG012;
parameters [10].Value = model.idx;
parameters [11].Value = model.LEG002;
parameters [12].Value = model.LEG013;
parameters [13].Value = model.LEG014;
parameters [14].Value = model.LEG015;
parameters [15].Value = model.LEG016;
parameters [16].Value = model.LEG017;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableView"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.LEDNewsHeaderEntity model, DataTable tableView, DataTable tableViewTwo, List <string> idxList, List <string> idxListOne)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
EditHeader(SQLString, model);
LineProductMesEntityu.LEDNewsBodyEntity modelBody = new LineProductMesEntityu.LEDNewsBodyEntity( );
modelBody.LEG001 = model.LEF001;
foreach (DataRow row in tableView.Rows)
{
modelBody.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
modelBody.LEG002 = row ["LEG002"].ToString( );
modelBody.LEG003 = row ["LEG003"].ToString( );
modelBody.LEG004 = row ["LEG004"].ToString( );
if (row ["LEG005"] == null || row ["LEG005"].ToString( ) == string.Empty)
{
modelBody.LEG005 = null;
}
else
{
modelBody.LEG005 = Convert.ToDateTime(row ["LEG005"].ToString( ));
}
if (row ["LEG006"] == null || row ["LEG006"].ToString( ) == string.Empty)
{
modelBody.LEG006 = null;
}
else
{
modelBody.LEG006 = Convert.ToDateTime(row ["LEG006"].ToString( ));
}
modelBody.LEG007 = string.IsNullOrEmpty(row ["LEG007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG007"].ToString( ));
if (row ["LEG008"] == null || row ["LEG008"].ToString( ) == string.Empty)
{
modelBody.LEG008 = null;
}
else
{
modelBody.LEG008 = Convert.ToDateTime(row ["LEG008"].ToString( ));
}
if (row ["LEG009"] == null || row ["LEG009"].ToString( ) == string.Empty)
{
modelBody.LEG009 = null;
}
else
{
modelBody.LEG009 = Convert.ToDateTime(row ["LEG009"].ToString( ));
}
modelBody.LEG010 = string.IsNullOrEmpty(row ["LEG010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG010"].ToString( ));
modelBody.LEG011 = row ["LEG011"].ToString( );
modelBody.LEG012 = row ["LEG012"].ToString( );
modelBody.LEG013 = row ["LEG013"].ToString( );
modelBody.LEG014 = string.IsNullOrEmpty(row ["LEG014"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG014"].ToString( ));
modelBody.LEG015 = string.IsNullOrEmpty(row ["LEG015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG015"].ToString( ));
modelBody.LEG016 = string.IsNullOrEmpty(row ["LEG016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG016"].ToString( ));
if (row ["LEG017"] == null || row ["LEG017"].ToString( ) == string.Empty)
{
modelBody.LEG017 = null;
}
else
{
modelBody.LEG017 = Convert.ToDecimal(row ["LEG017"].ToString( ));
}
if (modelBody.idx < 1)
{
AddBody(SQLString, modelBody);
}
else
{
EditBody(SQLString, modelBody);
}
}
foreach (string s in idxList)
{
Delete(SQLString, s);
}
LineProductMesEntityu.LEHNewsBodyEntity body = new LineProductMesEntityu.LEHNewsBodyEntity( );
body.LEH001 = model.LEF001;
foreach (DataRow row in tableViewTwo.Rows)
{
body.LEH002 = row ["LEH002"].ToString( );
body.LEH003 = row ["LEH003"].ToString( );
body.LEH004 = row ["LEH004"].ToString( );
body.LEH005 = row ["LEH005"].ToString( );
body.LEH006 = row ["LEH006"].ToString( );
body.LEH007 = string.IsNullOrEmpty(row ["LEH007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEH007"].ToString( ));
body.LEH008 = string.IsNullOrEmpty(row ["LEH008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEH008"].ToString( ));
body.LEH009 = string.IsNullOrEmpty(row ["LEH009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEH009"].ToString( ));
body.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
body.LEH010 = row ["LEH010"].ToString( );
if (body.idx < 1)
{
AddBodyOne(SQLString, body);
}
else
{
EidtBodyOne(SQLString, body);
}
}
foreach (string s in idxListOne)
{
DeleteOne(SQLString, s);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
/// <summary>
/// 新增数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableView"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.LEDNewsHeaderEntity model, DataTable tableView, DataTable tableViewTwo)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
model.LEF001 = getOddNum( );
model.LEF022 = UserInfoMation.userName;
UserInfoMation.oddNum = model.LEF001;
AddHeader(SQLString, model);
LineProductMesEntityu.LEDNewsBodyEntity modelBody = new LineProductMesEntityu.LEDNewsBodyEntity( );
modelBody.LEG001 = model.LEF001;
foreach (DataRow row in tableView.Rows)
{
modelBody.LEG002 = row ["LEG002"].ToString( );
modelBody.LEG003 = row ["LEG003"].ToString( );
modelBody.LEG004 = row ["LEG004"].ToString( );
if (row ["LEG005"] == null || row ["LEG005"].ToString( ) == string.Empty)
{
modelBody.LEG005 = null;
}
else
{
modelBody.LEG005 = Convert.ToDateTime(row ["LEG005"].ToString( ));
}
if (row ["LEG006"] == null || row ["LEG006"].ToString( ) == string.Empty)
{
modelBody.LEG006 = null;
}
else
{
modelBody.LEG006 = Convert.ToDateTime(row ["LEG006"].ToString( ));
}
modelBody.LEG007 = string.IsNullOrEmpty(row ["LEG007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG007"].ToString( ));
if (row ["LEG008"] == null || row ["LEG008"].ToString( ) == string.Empty)
{
modelBody.LEG008 = null;
}
else
{
modelBody.LEG008 = Convert.ToDateTime(row ["LEG008"].ToString( ));
}
if (row ["LEG009"] == null || row ["LEG009"].ToString( ) == string.Empty)
{
modelBody.LEG009 = null;
}
else
{
modelBody.LEG009 = Convert.ToDateTime(row ["LEG009"].ToString( ));
}
modelBody.LEG010 = string.IsNullOrEmpty(row ["LEG010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG010"].ToString( ));
modelBody.LEG011 = row ["LEG011"].ToString( );
modelBody.LEG012 = row ["LEG012"].ToString( );
modelBody.LEG013 = row ["LEG013"].ToString( );
modelBody.LEG014 = string.IsNullOrEmpty(row ["LEG014"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG014"].ToString( ));
modelBody.LEG015 = string.IsNullOrEmpty(row ["LEG015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG015"].ToString( ));
modelBody.LEG016 = string.IsNullOrEmpty(row ["LEG016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEG016"].ToString( ));
if (row ["LEG017"] == null || row ["LEG017"].ToString( ) == string.Empty)
{
modelBody.LEG017 = null;
}
else
{
modelBody.LEG017 = Convert.ToDecimal(row ["LEG017"].ToString( ));
}
AddBody(SQLString, modelBody);
}
LineProductMesEntityu.LEHNewsBodyEntity body = new LineProductMesEntityu.LEHNewsBodyEntity( );
body.LEH001 = model.LEF001;
foreach (DataRow row in tableViewTwo.Rows)
{
body.LEH002 = row ["LEH002"].ToString( );
body.LEH003 = row ["LEH003"].ToString( );
body.LEH004 = row ["LEH004"].ToString( );
body.LEH005 = row ["LEH005"].ToString( );
body.LEH006 = row ["LEH006"].ToString( );
body.LEH007 = string.IsNullOrEmpty(row ["LEH007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEH007"].ToString( ));
body.LEH008 = string.IsNullOrEmpty(row ["LEH008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEH008"].ToString( ));
body.LEH009 = string.IsNullOrEmpty(row ["LEH009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEH009"].ToString( ));
body.LEH010 = row ["LEH010"].ToString( );
AddBodyOne(SQLString, body);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
