/// <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)); }