void EditBody(Dictionary <object, object> SQLString, LineProductMesEntityu.LEDNewsPaperBodyEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update MIKLED set ");
strSql.Append("LED002=@LED002,");
strSql.Append("LED003=@LED003,");
strSql.Append("LED004=@LED004,");
strSql.Append("LED005=@LED005,");
strSql.Append("LED006=@LED006,");
strSql.Append("LED007=@LED007,");
strSql.Append("LED008=@LED008,");
strSql.Append("LED009=@LED009,");
strSql.Append("LED010=@LED010,");
strSql.Append("LED011=@LED011,");
strSql.Append("LED012=@LED012,");
strSql.Append("LED013=@LED013,");
strSql.Append("LED014=@LED014,");
strSql.Append("LED015=@LED015,");
strSql.Append("LED016=@LED016 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@LED003", SqlDbType.NVarChar, 20),
new SqlParameter("@LED004", SqlDbType.NVarChar, 20),
new SqlParameter("@LED005", SqlDbType.DateTime),
new SqlParameter("@LED006", SqlDbType.DateTime),
new SqlParameter("@LED007", SqlDbType.Decimal, 9),
new SqlParameter("@LED008", SqlDbType.DateTime),
new SqlParameter("@LED009", SqlDbType.DateTime),
new SqlParameter("@LED010", SqlDbType.Decimal, 9),
new SqlParameter("@LED011", SqlDbType.NVarChar, 100),
new SqlParameter("@LED012", SqlDbType.NVarChar, 5),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@LED002", SqlDbType.NVarChar, 20),
new SqlParameter("@LED013", SqlDbType.NVarChar, 20),
new SqlParameter("@LED014", SqlDbType.Decimal),
new SqlParameter("@LED015", SqlDbType.Decimal),
new SqlParameter("@LED016", SqlDbType.Decimal)
};
parameters [0].Value = model.LED003;
parameters [1].Value = model.LED004;
parameters [2].Value = model.LED005;
parameters [3].Value = model.LED006;
parameters [4].Value = model.LED007;
parameters [5].Value = model.LED008;
parameters [6].Value = model.LED009;
parameters [7].Value = model.LED010;
parameters [8].Value = model.LED011;
parameters [9].Value = model.LED012;
parameters [10].Value = model.idx;
parameters [11].Value = model.LED002;
parameters [12].Value = model.LED013;
parameters [13].Value = model.LED014;
parameters [14].Value = model.LED015;
parameters [15].Value = model.LED016;
SQLString.Add(strSql, parameters);
}
void AddBody(Dictionary <object, object> SQLString, LineProductMesEntityu.LEDNewsPaperBodyEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into MIKLED(");
strSql.Append("LED001,LED002,LED003,LED004,LED005,LED006,LED007,LED008,LED009,LED010,LED011,LED012,LED013,LED014,LED015,LED016)");
strSql.Append(" values (");
strSql.Append("@LED001,@LED002,@LED003,@LED004,@LED005,@LED006,@LED007,@LED008,@LED009,@LED010,@LED011,@LED012,@LED013,@LED014,@LED015,@LED016)");
SqlParameter [] parameters =
{
new SqlParameter("@LED001", SqlDbType.NVarChar, 20),
new SqlParameter("@LED002", SqlDbType.NVarChar, 20),
new SqlParameter("@LED003", SqlDbType.NVarChar, 20),
new SqlParameter("@LED004", SqlDbType.NVarChar, 20),
new SqlParameter("@LED005", SqlDbType.DateTime),
new SqlParameter("@LED006", SqlDbType.DateTime),
new SqlParameter("@LED007", SqlDbType.Decimal, 9),
new SqlParameter("@LED008", SqlDbType.DateTime),
new SqlParameter("@LED009", SqlDbType.DateTime),
new SqlParameter("@LED010", SqlDbType.Decimal, 9),
new SqlParameter("@LED011", SqlDbType.NVarChar, 100),
new SqlParameter("@LED012", SqlDbType.NVarChar, 5),
new SqlParameter("@LED013", SqlDbType.NVarChar, 20),
new SqlParameter("@LED014", SqlDbType.Decimal, 9),
new SqlParameter("@LED015", SqlDbType.Decimal, 9),
new SqlParameter("@LED016", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.LED001;
parameters [1].Value = model.LED002;
parameters [2].Value = model.LED003;
parameters [3].Value = model.LED004;
parameters [4].Value = model.LED005;
parameters [5].Value = model.LED006;
parameters [6].Value = model.LED007;
parameters [7].Value = model.LED008;
parameters [8].Value = model.LED009;
parameters [9].Value = model.LED010;
parameters [10].Value = model.LED011;
parameters [11].Value = model.LED012;
parameters [12].Value = model.LED013;
parameters [13].Value = model.LED014;
parameters [14].Value = model.LED015;
parameters [15].Value = model.LED016;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableView"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.LEDNewsPaperHeaderEntity model, DataTable tableView, DataTable tableViewOne, List <string> idxList, List <string> idxListOne)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
EditHeader(SQLString, model);
LineProductMesEntityu.LEDNewsPaperBodyEntity modelBody = new LineProductMesEntityu.LEDNewsPaperBodyEntity( );
modelBody.LED001 = model.LEC001;
foreach (DataRow row in tableView.Rows)
{
modelBody.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
modelBody.LED002 = row ["LED002"].ToString( );
modelBody.LED003 = row ["LED003"].ToString( );
modelBody.LED004 = row ["LED004"].ToString( );
if (row ["LED005"] == null || row ["LED005"].ToString( ) == string.Empty)
{
modelBody.LED005 = null;
}
else
{
modelBody.LED005 = Convert.ToDateTime(row ["LED005"].ToString( ));
}
if (row ["LED006"] == null || row ["LED006"].ToString( ) == string.Empty)
{
modelBody.LED006 = null;
}
else
{
modelBody.LED006 = Convert.ToDateTime(row ["LED006"].ToString( ));
}
modelBody.LED007 = string.IsNullOrEmpty(row ["LED007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED007"].ToString( ));
if (row ["LED008"] == null || row ["LED008"].ToString( ) == string.Empty)
{
modelBody.LED008 = null;
}
else
{
modelBody.LED008 = Convert.ToDateTime(row ["LED008"].ToString( ));
}
if (row ["LED009"] == null || row ["LED009"].ToString( ) == string.Empty)
{
modelBody.LED009 = null;
}
else
{
modelBody.LED009 = Convert.ToDateTime(row ["LED009"].ToString( ));
}
modelBody.LED010 = string.IsNullOrEmpty(row ["LED010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED010"].ToString( ));
modelBody.LED011 = row ["LED011"].ToString( );
modelBody.LED012 = row ["LED012"].ToString( );
modelBody.LED013 = row ["LED013"].ToString( );
modelBody.LED014 = string.IsNullOrEmpty(row ["LED014"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED014"].ToString( ));
modelBody.LED015 = string.IsNullOrEmpty(row ["LED015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED015"].ToString( ));
modelBody.LED016 = string.IsNullOrEmpty(row ["LED016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED016"].ToString( ));
if (modelBody.idx < 1)
{
AddBody(SQLString, modelBody);
}
else
{
EditBody(SQLString, modelBody);
}
}
foreach (string s in idxList)
{
Delete(SQLString, s);
}
LineProductMesEntityu.LEENewsPaperBodyEntity body = new LineProductMesEntityu.LEENewsPaperBodyEntity( );
body.LEE001 = model.LEC001;
foreach (DataRow row in tableViewOne.Rows)
{
body.LEE002 = row ["LEE002"].ToString( );
body.LEE003 = row ["LEE003"].ToString( );
body.LEE004 = row ["LEE004"].ToString( );
body.LEE005 = row ["LEE005"].ToString( );
body.LEE006 = row ["LEE006"].ToString( );
body.LEE007 = string.IsNullOrEmpty(row ["LEE007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEE007"].ToString( ));
body.LEE008 = string.IsNullOrEmpty(row ["LEE008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEE008"].ToString( ));
body.LEE009 = string.IsNullOrEmpty(row ["LEE009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEE009"].ToString( ));
body.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
if (body.idx < 1)
{
AddBodyOne(SQLString, body);
}
else
{
EditBodyOne(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.LEDNewsPaperHeaderEntity model, DataTable tableView, DataTable tableViewOne)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
model.LEC001 = getOddNum( );
UserInfoMation.oddNum = model.LEC001;
model.LEC022 = UserInfoMation.userName;
AddHeader(SQLString, model);
LineProductMesEntityu.LEDNewsPaperBodyEntity modelBody = new LineProductMesEntityu.LEDNewsPaperBodyEntity( );
modelBody.LED001 = model.LEC001;
foreach (DataRow row in tableView.Rows)
{
modelBody.LED002 = row ["LED002"].ToString( );
modelBody.LED003 = row ["LED003"].ToString( );
modelBody.LED004 = row ["LED004"].ToString( );
if (row ["LED005"] == null || row ["LED005"].ToString( ) == string.Empty)
{
modelBody.LED005 = null;
}
else
{
modelBody.LED005 = Convert.ToDateTime(row ["LED005"].ToString( ));
}
if (row ["LED006"] == null || row ["LED006"].ToString( ) == string.Empty)
{
modelBody.LED006 = null;
}
else
{
modelBody.LED006 = Convert.ToDateTime(row ["LED006"].ToString( ));
}
modelBody.LED007 = string.IsNullOrEmpty(row ["LED007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED007"].ToString( ));
if (row ["LED008"] == null || row ["LED008"].ToString( ) == string.Empty)
{
modelBody.LED008 = null;
}
else
{
modelBody.LED008 = Convert.ToDateTime(row ["LED008"].ToString( ));
}
if (row ["LED009"] == null || row ["LED009"].ToString( ) == string.Empty)
{
modelBody.LED009 = null;
}
else
{
modelBody.LED009 = Convert.ToDateTime(row ["LED009"].ToString( ));
}
modelBody.LED010 = string.IsNullOrEmpty(row ["LED010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED010"].ToString( ));
modelBody.LED011 = row ["LED011"].ToString( );
modelBody.LED012 = row ["LED012"].ToString( );
modelBody.LED013 = row ["LED013"].ToString( );
modelBody.LED014 = string.IsNullOrEmpty(row ["LED014"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED014"].ToString( ));
modelBody.LED015 = string.IsNullOrEmpty(row ["LED015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED015"].ToString( ));
modelBody.LED016 = string.IsNullOrEmpty(row ["LED016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LED016"].ToString( ));
AddBody(SQLString, modelBody);
}
LineProductMesEntityu.LEENewsPaperBodyEntity body = new LineProductMesEntityu.LEENewsPaperBodyEntity( );
body.LEE001 = model.LEC001;
foreach (DataRow row in tableViewOne.Rows)
{
body.LEE002 = row ["LEE002"].ToString( );
body.LEE003 = row ["LEE003"].ToString( );
body.LEE004 = row ["LEE004"].ToString( );
body.LEE005 = row ["LEE005"].ToString( );
body.LEE006 = row ["LEE006"].ToString( );
body.LEE007 = string.IsNullOrEmpty(row ["LEE007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEE007"].ToString( ));
body.LEE008 = string.IsNullOrEmpty(row ["LEE008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["LEE008"].ToString( ));
body.LEE009 = string.IsNullOrEmpty(row ["LEE009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["LEE009"].ToString( ));
AddBodyOne(SQLString, body);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
