/// <summary>
/// 完工数量总和是否少于工单数量
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int ExistsNum(LineProductMesEntityu.AssNewWorkHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT SUM(ANW009) ANW009 FROM MIKANW WHERE ANW001!='{0}' AND ANW002='{1}' AND ANW021=0 GROUP BY ANW002", model.ANW001, model.ANW002);
DataTable table = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (table == null || table.Rows.Count < 1)
{
return(0);
}
else
{
int x = string.IsNullOrEmpty(table.Rows [0] ["ANW009"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [0] ["ANW009"].ToString( ));
if (x + model.ANW009 <= model.ANW006)
{
return(0);
}
else
{
return(x);
}
}
}
void EditHeader(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkHeaderEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update MIKANW set ");
//strSql . Append ( "ANW002=@ANW002," );
//strSql . Append ( "ANW003=@ANW003," );
//strSql . Append ( "ANW004=@ANW004," );
//strSql . Append ( "ANW005=@ANW005," );
//strSql . Append ( "ANW006=@ANW006," );
//strSql . Append ( "ANW007=@ANW007," );
//strSql . Append ( "ANW008=@ANW008," );
//strSql . Append ( "ANW009=@ANW009," );
strSql.Append("ANW010=@ANW010,");
strSql.Append("ANW011=@ANW011,");
strSql.Append("ANW012=@ANW012,");
strSql.Append("ANW013=@ANW013,");
strSql.Append("ANW014=@ANW014,");
strSql.Append("ANW015=@ANW015,");
strSql.Append("ANW016=@ANW016,");
strSql.Append("ANW017=@ANW017,");
strSql.Append("ANW018=@ANW018,");
strSql.Append("ANW019=@ANW019,");
strSql.Append("ANW020=@ANW020,");
strSql.Append("ANW021=@ANW021,");
strSql.Append("ANW023=@ANW023,");
strSql.Append("ANW024=@ANW024,");
strSql.Append("ANW026=@ANW026,");
strSql.Append("ANW027=@ANW027 ");
strSql.Append(" WHERE ANW001=@ANW001");
SqlParameter [] parameters =
{
//new SqlParameter("@ANW002", SqlDbType.NVarChar,20),
//new SqlParameter("@ANW003", SqlDbType.NVarChar,20),
//new SqlParameter("@ANW004", SqlDbType.NVarChar,50),
//new SqlParameter("@ANW005", SqlDbType.NVarChar,20),
//new SqlParameter("@ANW006", SqlDbType.Int,4),
//new SqlParameter("@ANW007", SqlDbType.NVarChar,10),
//new SqlParameter("@ANW008", SqlDbType.Decimal,9),
//new SqlParameter("@ANW009", SqlDbType.Int,4),
new SqlParameter("@ANW010", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW011", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW012", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW013", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW014", SqlDbType.NVarChar, 10),
new SqlParameter("@ANW015", SqlDbType.DateTime),
new SqlParameter("@ANW016", SqlDbType.DateTime),
new SqlParameter("@ANW017", SqlDbType.NVarChar, 100),
new SqlParameter("@ANW018", SqlDbType.NVarChar, 100),
new SqlParameter("@ANW019", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW020", SqlDbType.Bit, 1),
new SqlParameter("@ANW021", SqlDbType.Bit, 1),
new SqlParameter("@ANW001", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW023", SqlDbType.Decimal, 9),
new SqlParameter("@ANW024", SqlDbType.Decimal, 9),
new SqlParameter("@ANW026", SqlDbType.Decimal, 9),
new SqlParameter("@ANW027", SqlDbType.Decimal, 9)
};
//parameters [ 0 ] . Value = model . ANW002;
//parameters [ 1 ] . Value = model . ANW003;
//parameters [ 2 ] . Value = model . ANW004;
//parameters [ 3 ] . Value = model . ANW005;
//parameters [ 4 ] . Value = model . ANW006;
//parameters [ 5 ] . Value = model . ANW007;
//parameters [ 6 ] . Value = model . ANW008;
//parameters [ 7 ] . Value = model . ANW009;
parameters [0].Value = model.ANW010;
parameters [1].Value = model.ANW011;
parameters [2].Value = model.ANW012;
parameters [3].Value = model.ANW013;
parameters [4].Value = model.ANW014;
parameters [5].Value = model.ANW015;
parameters [6].Value = model.ANW016;
parameters [7].Value = model.ANW017;
parameters [8].Value = model.ANW018;
parameters [9].Value = model.ANW019;
parameters [10].Value = model.ANW020;
parameters [11].Value = model.ANW021;
parameters [12].Value = model.ANW001;
parameters [13].Value = model.ANW023;
parameters [14].Value = model.ANW024;
parameters [15].Value = model.ANW026;
parameters [16].Value = model.ANW027;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="_header"></param>
/// <param name="tableView"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.AssNewWorkHeaderEntity _header, DataTable tableView, List <string> idxList, DataTable tableViewTwo, List <string> idxListOne)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
//Hashtable SQLString = new Hashtable ( );
StringBuilder strSql = new StringBuilder( );
EditHeader(SQLString, strSql, _header);
LineProductMesEntityu.AssNewWorkBodyEntity model = new LineProductMesEntityu.AssNewWorkBodyEntity( );
foreach (DataRow row in tableView.Rows)
{
model.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
model.ANX001 = _header.ANW001;
model.ANX002 = row ["ANX002"].ToString( );
model.ANX003 = row ["ANX003"].ToString( );
model.ANX004 = row ["ANX004"].ToString( );
if (string.IsNullOrEmpty(row ["ANX005"].ToString( )))
{
model.ANX005 = null;
}
else
{
model.ANX005 = Convert.ToDateTime(row ["ANX005"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX006"].ToString( )))
{
model.ANX006 = null;
}
else
{
model.ANX006 = Convert.ToDateTime(row ["ANX006"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX007"].ToString( )))
{
model.ANX007 = null;
}
else
{
model.ANX007 = Convert.ToDateTime(row ["ANX007"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX008"].ToString( )))
{
model.ANX008 = null;
}
else
{
model.ANX008 = Convert.ToDateTime(row ["ANX008"].ToString( ));
}
model.ANX009 = string.IsNullOrEmpty(row ["ANX009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX009"].ToString( ));
model.ANX010 = string.IsNullOrEmpty(row ["ANX010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX010"].ToString( ));
model.ANX011 = row ["ANX011"].ToString( );
model.ANX012 = row ["ANX012"].ToString( );
model.ANX013 = row ["ANX013"].ToString( );
model.ANX014 = row ["ANX014"].ToString( );
model.ANX015 = string.IsNullOrEmpty(row ["ANX015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX015"].ToString( ));
model.ANX016 = string.IsNullOrEmpty(row ["ANX016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX016"].ToString( ));
model.ANX017 = string.IsNullOrEmpty(row ["ANX017"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX017"].ToString( ));
if (string.IsNullOrEmpty(row ["ANX018"].ToString( )))
{
model.ANX018 = null;
}
else
{
model.ANX018 = Convert.ToDecimal(row ["ANX018"].ToString( ));
}
if (!string.IsNullOrEmpty(model.ANX002))
{
if (model.idx > 0)
{
EditBody(SQLString, strSql, model);
}
else
{
AddBody(SQLString, strSql, model);
}
}
}
LineProductMesEntityu.AssNewWorkBodyAnnEntity bodyOne = new LineProductMesEntityu.AssNewWorkBodyAnnEntity( );
bodyOne.ANN001 = _header.ANW001;
foreach (DataRow row in tableViewTwo.Rows)
{
bodyOne.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"]);
bodyOne.ANN002 = row ["ANN002"].ToString( );
bodyOne.ANN003 = row ["ANN003"].ToString( );
bodyOne.ANN004 = row ["ANN004"].ToString( );
bodyOne.ANN005 = row ["ANN005"].ToString( );
bodyOne.ANN006 = row ["ANN006"].ToString( );
bodyOne.ANN007 = string.IsNullOrEmpty(row ["ANN007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANN007"]);
bodyOne.ANN008 = string.IsNullOrEmpty(row ["ANN008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANN008"]);
bodyOne.ANN009 = string.IsNullOrEmpty(row ["ANN009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANN009"]);
bodyOne.ANN010 = row ["ANN010"].ToString( );
if (!string.IsNullOrEmpty(bodyOne.ANN002))
{
if (bodyOne.idx > 0)
{
EditBodyOne(SQLString, strSql, bodyOne);
}
else
{
AddBodyOne(SQLString, strSql, bodyOne);
}
}
}
foreach (string s in idxList)
{
if (Convert.ToInt32(s) > 0)
{
DeleteBody(SQLString, strSql, s);
}
}
foreach (string s in idxListOne)
{
if (Convert.ToInt32(s) > 0)
{
DeleteBodyOne(SQLString, strSql, s);
}
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
void AddHeader(Dictionary <object, object> SQLString, StringBuilder strSql, LineProductMesEntityu.AssNewWorkHeaderEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into MIKANW("); //ANW002,ANW003,ANW004,ANW005,ANW006,ANW007,ANW008,ANW009,ANW015,ANW016,
strSql.Append("ANW001,ANW010,ANW011,ANW012,ANW013,ANW014,ANW015,ANW016,ANW017,ANW018,ANW019,ANW020,ANW021,ANW022,ANW023,ANW024,ANW025,ANW026,ANW027)");
strSql.Append(" values (");
strSql.Append("@ANW001,@ANW010,@ANW011,@ANW012,@ANW013,@ANW014,@ANW015,@ANW016,@ANW017,@ANW018,@ANW019,@ANW020,@ANW021,@ANW022,@ANW023,@ANW024,@ANW025,@ANW026,@ANW027)");
//@ANW002,@ANW003,@ANW004,@ANW005,@ANW006,@ANW007,@ANW008,@ANW009,@ANW015,@ANW016,
SqlParameter [] parameters =
{
new SqlParameter("@ANW001", SqlDbType.NVarChar, 20),
//new SqlParameter("@ANW002", SqlDbType.NVarChar,20),
//new SqlParameter("@ANW003", SqlDbType.NVarChar,20),
//new SqlParameter("@ANW004", SqlDbType.NVarChar,50),
//new SqlParameter("@ANW005", SqlDbType.NVarChar,20),
//new SqlParameter("@ANW006", SqlDbType.Int,4),
//new SqlParameter("@ANW007", SqlDbType.NVarChar,10),
//new SqlParameter("@ANW008", SqlDbType.Decimal,9),
//new SqlParameter("@ANW009", SqlDbType.Int,4),
new SqlParameter("@ANW010", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW011", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW012", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW013", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW014", SqlDbType.NVarChar, 10),
new SqlParameter("@ANW015", SqlDbType.DateTime),
new SqlParameter("@ANW016", SqlDbType.DateTime),
new SqlParameter("@ANW017", SqlDbType.NVarChar, 100),
new SqlParameter("@ANW018", SqlDbType.NVarChar, 100),
new SqlParameter("@ANW019", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW020", SqlDbType.Bit, 1),
new SqlParameter("@ANW021", SqlDbType.Bit, 1),
new SqlParameter("@ANW022", SqlDbType.DateTime),
new SqlParameter("@ANW023", SqlDbType.Decimal, 9),
new SqlParameter("@ANW024", SqlDbType.Decimal, 9),
new SqlParameter("@ANW025", SqlDbType.NVarChar, 20),
new SqlParameter("@ANW026", SqlDbType.Decimal, 9),
new SqlParameter("@ANW027", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.ANW001;
//parameters [ 1 ] . Value = model . ANW002;
//parameters [ 2 ] . Value = model . ANW003;
//parameters [ 3 ] . Value = model . ANW004;
//parameters [ 4 ] . Value = model . ANW005;
//parameters [ 5 ] . Value = model . ANW006;
//parameters [ 6 ] . Value = model . ANW007;
//parameters [ 7 ] . Value = model . ANW008;
//parameters [ 8 ] . Value = model . ANW009;
parameters [1].Value = model.ANW010;
parameters [2].Value = model.ANW011;
parameters [3].Value = model.ANW012;
parameters [4].Value = model.ANW013;
parameters [5].Value = model.ANW014;
parameters [6].Value = model.ANW015;
parameters [7].Value = model.ANW016;
parameters [8].Value = model.ANW017;
parameters [9].Value = model.ANW018;
parameters [10].Value = model.ANW019;
parameters [11].Value = model.ANW020;
parameters [12].Value = model.ANW021;
parameters [13].Value = model.ANW022;
parameters [14].Value = model.ANW023;
parameters [15].Value = model.ANW024;
parameters [16].Value = model.ANW025;
parameters [17].Value = model.ANW026;
parameters [18].Value = model.ANW027;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="_header"></param>
/// <param name="tableView"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.AssNewWorkHeaderEntity _header, DataTable tableView, DataTable tableViewTwo)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
//Hashtable SQLString = new Hashtable ( );
StringBuilder strSql = new StringBuilder( );
_header.ANW001 = getOddNum( );
_header.ANW025 = UserInfoMation.userName;
AddHeader(SQLString, strSql, _header);
UserInfoMation.oddNum = _header.ANW001;
LineProductMesEntityu.AssNewWorkBodyEntity model = new LineProductMesEntityu.AssNewWorkBodyEntity( );
foreach (DataRow row in tableView.Rows)
{
model.ANX001 = _header.ANW001;
model.ANX002 = row ["ANX002"].ToString( );
model.ANX003 = row ["ANX003"].ToString( );
model.ANX004 = row ["ANX004"].ToString( );
if (string.IsNullOrEmpty(row ["ANX005"].ToString( )))
{
model.ANX005 = null;
}
else
{
model.ANX005 = Convert.ToDateTime(row ["ANX005"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX006"].ToString( )))
{
model.ANX006 = null;
}
else
{
model.ANX006 = Convert.ToDateTime(row ["ANX006"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX007"].ToString( )))
{
model.ANX007 = null;
}
else
{
model.ANX007 = Convert.ToDateTime(row ["ANX007"].ToString( ));
}
if (string.IsNullOrEmpty(row ["ANX008"].ToString( )))
{
model.ANX008 = null;
}
else
{
model.ANX008 = Convert.ToDateTime(row ["ANX008"].ToString( ));
}
model.ANX009 = string.IsNullOrEmpty(row ["ANX009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX009"].ToString( ));
model.ANX010 = string.IsNullOrEmpty(row ["ANX010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX010"].ToString( ));
model.ANX011 = row ["ANX011"].ToString( );
model.ANX012 = row ["ANX012"].ToString( );
model.ANX013 = row ["ANX013"].ToString( );
model.ANX014 = row ["ANX014"].ToString( );
model.ANX015 = string.IsNullOrEmpty(row ["ANX015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX015"].ToString( ));
model.ANX016 = string.IsNullOrEmpty(row ["ANX016"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX016"].ToString( ));
model.ANX017 = string.IsNullOrEmpty(row ["ANX017"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANX017"].ToString( ));
if (string.IsNullOrEmpty(row ["ANX018"].ToString( )))
{
model.ANX018 = null;
}
else
{
model.ANX018 = Convert.ToDecimal(row ["ANX018"].ToString( ));
}
if (!string.IsNullOrEmpty(model.ANX002))
{
AddBody(SQLString, strSql, model);
}
}
LineProductMesEntityu.AssNewWorkBodyAnnEntity bodyOne = new LineProductMesEntityu.AssNewWorkBodyAnnEntity( );
bodyOne.ANN001 = _header.ANW001;
foreach (DataRow row in tableViewTwo.Rows)
{
bodyOne.ANN002 = row ["ANN002"].ToString( );
bodyOne.ANN003 = row ["ANN003"].ToString( );
bodyOne.ANN004 = row ["ANN004"].ToString( );
bodyOne.ANN005 = row ["ANN005"].ToString( );
bodyOne.ANN006 = row ["ANN006"].ToString( );
bodyOne.ANN007 = string.IsNullOrEmpty(row ["ANN007"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANN007"]);
bodyOne.ANN008 = string.IsNullOrEmpty(row ["ANN008"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ANN008"]);
bodyOne.ANN009 = string.IsNullOrEmpty(row ["ANN009"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ANN009"]);
bodyOne.ANN010 = row ["ANN010"].ToString( );
if (!string.IsNullOrEmpty(bodyOne.ANN002))
{
AddBodyOne(SQLString, strSql, bodyOne);
}
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
public LineProductMesEntityu.AssNewWorkHeaderEntity getHeader(DataRow row)
{
LineProductMesEntityu.AssNewWorkHeaderEntity model = new LineProductMesEntityu.AssNewWorkHeaderEntity( );
if (row != null)
{
if (row ["ANW001"] != null)
{
model.ANW001 = row ["ANW001"].ToString( );
}
if (row ["ANW010"] != null)
{
model.ANW010 = row ["ANW010"].ToString( );
}
if (row ["ANW011"] != null)
{
model.ANW011 = row ["ANW011"].ToString( );
}
if (row ["ANW012"] != null)
{
model.ANW012 = row ["ANW012"].ToString( );
}
if (row ["ANW013"] != null)
{
model.ANW013 = row ["ANW013"].ToString( );
}
if (row ["ANW014"] != null)
{
model.ANW014 = row ["ANW014"].ToString( );
}
if (row ["ANW015"] != null && row ["ANW015"].ToString( ) != "")
{
model.ANW015 = Convert.ToDateTime(row ["ANW015"].ToString( ));
}
if (row ["ANW016"] != null && row ["ANW016"].ToString( ) != "")
{
model.ANW016 = Convert.ToDateTime(row ["ANW016"].ToString( ));
}
if (row ["ANW017"] != null)
{
model.ANW017 = row ["ANW017"].ToString( );
}
if (row ["ANW018"] != null)
{
model.ANW018 = row ["ANW018"].ToString( );
}
if (row ["ANW019"] != null)
{
model.ANW019 = row ["ANW019"].ToString( );
}
if (row ["ANW020"] != null && row ["ANW020"].ToString( ) != "")
{
if ((row ["ANW020"].ToString( ) == "1") || (row ["ANW020"].ToString( ).ToLower( ) == "true"))
{
model.ANW020 = true;
}
else
{
model.ANW020 = false;
}
}
if (row ["ANW021"] != null && row ["ANW021"].ToString( ) != "")
{
if ((row ["ANW021"].ToString( ) == "1") || (row ["ANW021"].ToString( ).ToLower( ) == "true"))
{
model.ANW021 = true;
}
else
{
model.ANW021 = false;
}
}
if (row ["ANW022"] != null && row ["ANW022"].ToString( ) != "")
{
model.ANW022 = DateTime.Parse(row ["ANW022"].ToString( ));
}
if (row ["ANW023"] != null && row ["ANW023"].ToString( ) != "")
{
model.ANW023 = decimal.Parse(row ["ANW023"].ToString( ));
}
if (row ["ANW024"] != null && row ["ANW024"].ToString( ) != "")
{
model.ANW024 = decimal.Parse(row ["ANW024"].ToString( ));
}
if (row ["ANW026"] != null && row ["ANW026"].ToString( ) != "")
{
model.ANW026 = decimal.Parse(row ["ANW026"].ToString( ));
}
if (row ["ANW027"] != null && row ["ANW027"].ToString( ) != "")
{
model.ANW027 = decimal.Parse(row ["ANW027"].ToString( ));
}
if (row ["ANW025"] != null && row ["ANW025"].ToString( ) != "")
{
model.ANW025 = row ["ANW025"].ToString( );
}
}
return(model);
}
/// <summary>
/// 完工数量总和是否少于工单数量
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int ExistsNum(LineProductMesEntityu.AssNewWorkHeaderEntity model)
{
return(dal.ExistsNum(model));
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="_header"></param>
/// <param name="tableView"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.AssNewWorkHeaderEntity _header, DataTable tableView, List <string> idxList, DataTable tableViewTwo, List <string> idxListOne)
{
return(dal.Edit(_header, tableView, idxList, tableViewTwo, idxListOne));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="_header"></param>
/// <param name="tableView"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.AssNewWorkHeaderEntity _header, DataTable tableView, DataTable tableViewTwo)
{
return(dal.Save(_header, tableView, tableViewTwo));
}
