/// <summary>
/// 总完工数量是否大于工单数量
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(LineProductMesEntityu.LEDNewsPaperHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT SUM(LEC014) LEC014 FROM MIKLEC WHERE LEC001!='{0}' AND LEC002='{1}' AND LEC018=0", model.LEC001, model.LEC002);
DataTable table = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (table == null || table.Rows.Count < 1)
{
return(true);
}
else
{
decimal result = string.IsNullOrEmpty(table.Rows [0] ["LEC014"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [0] ["LEC014"].ToString( ));
if (result + model.LEC014 > model.LEC007)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// 总完工数量是否大于工单数量
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(LineProductMesEntityu.LEDNewsPaperHeaderEntity model)
{
return(dal.Exists(model));
}
/// <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)
{
return(dal.Edit(model, tableView, tableViewOne, idxList, idxListOne));
}
/// <summary>
/// 新增数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableView"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.LEDNewsPaperHeaderEntity model, DataTable tableView, DataTable tableViewOne)
{
return(dal.Save(model, tableView, tableViewOne));
}
public LineProductMesEntityu.LEDNewsPaperHeaderEntity getModel(DataRow row)
{
LineProductMesEntityu.LEDNewsPaperHeaderEntity model = new LineProductMesEntityu.LEDNewsPaperHeaderEntity( );
if (row != null)
{
if (row ["idx"] != null && row ["idx"].ToString( ) != "")
{
model.idx = int.Parse(row ["idx"].ToString( ));
}
if (row ["LEC001"] != null)
{
model.LEC001 = row ["LEC001"].ToString( );
}
if (row ["LEC002"] != null)
{
model.LEC002 = row ["LEC002"].ToString( );
}
if (row ["LEC003"] != null)
{
model.LEC003 = row ["LEC003"].ToString( );
}
if (row ["LEC004"] != null)
{
model.LEC004 = row ["LEC004"].ToString( );
}
if (row ["LEC005"] != null)
{
model.LEC005 = row ["LEC005"].ToString( );
}
if (row ["LEC006"] != null)
{
model.LEC006 = row ["LEC006"].ToString( );
}
if (row ["LEC007"] != null && row ["LEC007"].ToString( ) != "")
{
model.LEC007 = int.Parse(row ["LEC007"].ToString( ));
}
if (row ["LEC008"] != null && row ["LEC008"].ToString( ) != "")
{
model.LEC008 = decimal.Parse(row ["LEC008"].ToString( ));
}
if (row ["LEC009"] != null)
{
model.LEC009 = row ["LEC009"].ToString( );
}
if (row ["LEC010"] != null)
{
model.LEC010 = row ["LEC010"].ToString( );
}
if (row ["LEC011"] != null)
{
model.LEC011 = row ["LEC011"].ToString( );
}
if (row ["LEC012"] != null)
{
model.LEC012 = row ["LEC012"].ToString( );
}
if (row ["LEC013"] != null && row ["LEC013"].ToString( ) != "")
{
model.LEC013 = DateTime.Parse(row ["LEC013"].ToString( ));
}
if (row ["LEC014"] != null && row ["LEC014"].ToString( ) != "")
{
model.LEC014 = int.Parse(row ["LEC014"].ToString( ));
}
if (row ["LEC015"] != null)
{
model.LEC015 = row ["LEC015"].ToString( );
}
if (row ["LEC016"] != null)
{
model.LEC016 = row ["LEC016"].ToString( );
}
if (row ["LEC017"] != null && row ["LEC017"].ToString( ) != "")
{
if ((row ["LEC017"].ToString( ) == "1") || (row ["LEC017"].ToString( ).ToLower( ) == "true"))
{
model.LEC017 = true;
}
else
{
model.LEC017 = false;
}
}
if (row ["LEC018"] != null && row ["LEC018"].ToString( ) != "")
{
if ((row ["LEC018"].ToString( ) == "1") || (row ["LEC018"].ToString( ).ToLower( ) == "true"))
{
model.LEC018 = true;
}
else
{
model.LEC018 = false;
}
}
if (row ["LEC019"] != null && row ["LEC019"].ToString( ) != "")
{
model.LEC019 = decimal.Parse(row ["LEC019"].ToString( ));
}
if (row ["LEC020"] != null && row ["LEC020"].ToString( ) != "")
{
model.LEC020 = decimal.Parse(row ["LEC020"].ToString( ));
}
if (row ["LEC021"] != null && row ["LEC021"].ToString( ) != "")
{
model.LEC021 = row ["LEC021"].ToString( );
}
if (row ["LEC023"] != null && row ["LEC023"].ToString( ) != "")
{
model.LEC023 = DateTime.Parse(row ["LEC023"].ToString( ));
}
if (row ["LEC024"] != null && row ["LEC024"].ToString( ) != "")
{
model.LEC024 = DateTime.Parse(row ["LEC024"].ToString( ));
}
}
return(model);
}
void EditHeader(Dictionary <object, object> SQLString, LineProductMesEntityu.LEDNewsPaperHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update MIKLEC set ");
strSql.Append("LEC002=@LEC002,");
strSql.Append("LEC003=@LEC003,");
strSql.Append("LEC004=@LEC004,");
strSql.Append("LEC005=@LEC005,");
strSql.Append("LEC006=@LEC006,");
strSql.Append("LEC007=@LEC007,");
strSql.Append("LEC008=@LEC008,");
strSql.Append("LEC009=@LEC009,");
strSql.Append("LEC010=@LEC010,");
strSql.Append("LEC011=@LEC011,");
strSql.Append("LEC012=@LEC012,");
strSql.Append("LEC013=@LEC013,");
strSql.Append("LEC014=@LEC014,");
strSql.Append("LEC015=@LEC015,");
strSql.Append("LEC016=@LEC016,");
strSql.Append("LEC017=@LEC017,");
strSql.Append("LEC018=@LEC018,");
strSql.Append("LEC019=@LEC019,");
strSql.Append("LEC020=@LEC020,");
strSql.Append("LEC021=@LEC021,");
strSql.Append("LEC023=@LEC023,");
strSql.Append("LEC024=@LEC024 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@LEC002", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC003", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC004", SqlDbType.NVarChar, 50),
new SqlParameter("@LEC005", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC006", SqlDbType.NVarChar, 5),
new SqlParameter("@LEC007", SqlDbType.Int, 4),
new SqlParameter("@LEC008", SqlDbType.Decimal, 9),
new SqlParameter("@LEC009", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC010", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC011", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC012", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC013", SqlDbType.Date, 3),
new SqlParameter("@LEC014", SqlDbType.Int, 4),
new SqlParameter("@LEC015", SqlDbType.NVarChar, 100),
new SqlParameter("@LEC016", SqlDbType.NVarChar, 100),
new SqlParameter("@LEC017", SqlDbType.Bit, 1),
new SqlParameter("@LEC018", SqlDbType.Bit, 1),
new SqlParameter("@LEC019", SqlDbType.Decimal),
new SqlParameter("@LEC020", SqlDbType.Decimal),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@LEC021", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC023", SqlDbType.DateTime),
new SqlParameter("@LEC024", SqlDbType.DateTime)
};
parameters [0].Value = model.LEC002;
parameters [1].Value = model.LEC003;
parameters [2].Value = model.LEC004;
parameters [3].Value = model.LEC005;
parameters [4].Value = model.LEC006;
parameters [5].Value = model.LEC007;
parameters [6].Value = model.LEC008;
parameters [7].Value = model.LEC009;
parameters [8].Value = model.LEC010;
parameters [9].Value = model.LEC011;
parameters [10].Value = model.LEC012;
parameters [11].Value = model.LEC013;
parameters [12].Value = model.LEC014;
parameters [13].Value = model.LEC015;
parameters [14].Value = model.LEC016;
parameters [15].Value = model.LEC017;
parameters [16].Value = model.LEC018;
parameters [17].Value = model.LEC019;
parameters [18].Value = model.LEC020;
parameters [19].Value = model.idx;
parameters [20].Value = model.LEC021;
parameters [21].Value = model.LEC023;
parameters [22].Value = model.LEC024;
SQLString.Add(strSql, parameters);
}
void AddHeader(Dictionary <object, object> SQLString, LineProductMesEntityu.LEDNewsPaperHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into MIKLEC(");
strSql.Append("LEC001,LEC002,LEC003,LEC004,LEC005,LEC006,LEC007,LEC008,LEC009,LEC010,LEC011,LEC012,LEC013,LEC014,LEC015,LEC016,LEC017,LEC018,LEC019,LEC020,LEC021,LEC022,LEC023,LEC024)");
strSql.Append(" values (");
strSql.Append("@LEC001,@LEC002,@LEC003,@LEC004,@LEC005,@LEC006,@LEC007,@LEC008,@LEC009,@LEC010,@LEC011,@LEC012,@LEC013,@LEC014,@LEC015,@LEC016,@LEC017,@LEC018,@LEC019,@LEC020,@LEC021,@LEC022,@LEC023,@LEC024)");
SqlParameter [] parameters =
{
new SqlParameter("@LEC001", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC002", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC003", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC004", SqlDbType.NVarChar, 50),
new SqlParameter("@LEC005", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC006", SqlDbType.NVarChar, 5),
new SqlParameter("@LEC007", SqlDbType.Int, 4),
new SqlParameter("@LEC008", SqlDbType.Decimal, 9),
new SqlParameter("@LEC009", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC010", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC011", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC012", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC013", SqlDbType.Date, 3),
new SqlParameter("@LEC014", SqlDbType.Int, 4),
new SqlParameter("@LEC015", SqlDbType.NVarChar, 100),
new SqlParameter("@LEC016", SqlDbType.NVarChar, 100),
new SqlParameter("@LEC017", SqlDbType.Bit, 1),
new SqlParameter("@LEC018", SqlDbType.Bit, 1),
new SqlParameter("@LEC019", SqlDbType.Decimal),
new SqlParameter("@LEC020", SqlDbType.Decimal),
new SqlParameter("@LEC021", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC022", SqlDbType.NVarChar, 20),
new SqlParameter("@LEC023", SqlDbType.DateTime),
new SqlParameter("@LEC024", SqlDbType.DateTime)
};
parameters [0].Value = model.LEC001;
parameters [1].Value = model.LEC002;
parameters [2].Value = model.LEC003;
parameters [3].Value = model.LEC004;
parameters [4].Value = model.LEC005;
parameters [5].Value = model.LEC006;
parameters [6].Value = model.LEC007;
parameters [7].Value = model.LEC008;
parameters [8].Value = model.LEC009;
parameters [9].Value = model.LEC010;
parameters [10].Value = model.LEC011;
parameters [11].Value = model.LEC012;
parameters [12].Value = model.LEC013;
parameters [13].Value = model.LEC014;
parameters [14].Value = model.LEC015;
parameters [15].Value = model.LEC016;
parameters [16].Value = model.LEC017;
parameters [17].Value = model.LEC018;
parameters [18].Value = model.LEC019;
parameters [19].Value = model.LEC020;
parameters [20].Value = model.LEC021;
parameters [21].Value = model.LEC022;
parameters [22].Value = model.LEC023;
parameters [23].Value = model.LEC024;
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));
}
