/// <summary> /// 更新一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(MulaolaoLibrary.CheckOutLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfState) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQAK SET "); strSql.AppendFormat("AK001='{0}',", model.AK001); strSql.AppendFormat("AK002='{0}',", model.AK002); strSql.AppendFormat("AK003='{0}',", model.AK003); strSql.AppendFormat("AK004='{0}',", model.AK004); strSql.AppendFormat("AK005='{0}',", model.AK005); strSql.AppendFormat("AK006='{0}',", model.AK006); strSql.AppendFormat("AK007='{0}',", model.AK007); strSql.AppendFormat("AK008='{0}',", model.AK008); strSql.AppendFormat("AK009='{0}',", model.AK009); strSql.AppendFormat("AK010='{0}',", model.AK010); strSql.AppendFormat("AK011='{0}',", model.AK011); strSql.AppendFormat("AK012='{0}',", model.AK012); strSql.AppendFormat("AK013='{0}',", model.AK013); //strSql.AppendFormat( "AK014='{0}'," ,model.AK014 ); strSql.AppendFormat("AK015='{0}',", model.AK015); strSql.AppendFormat("AK017='{0}'", model.AK017); strSql.AppendFormat(" WHERE idx='{0}'", model.Idx); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.AK014, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfState)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// save data to database /// </summary> /// <param name="table"></param> /// <param name="_di"></param> /// <param name="bodyList"></param> /// <param name="logins"></param> /// <returns></returns> public bool Save(DataTable table, MulaolaoLibrary.QualityFinalInspsctionDIEntity _di, List <string> bodyList, string logins) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); if (_di.idx > 0) { edit_di(SQLString, strSql, _di); SQLString.Add(Drity.DrityOfComparation("R_101", "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表头"), null); } else { _di.DI001 = getOddNum( ); add_di(SQLString, strSql, _di); SQLString.Add(Drity.DrityOfComparation("R_101", "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表头"), null); } MulaolaoLibrary.QualityFinalInspsctionDJEntity model = new MulaolaoLibrary.QualityFinalInspsctionDJEntity( ); model.DJ001 = _di.DI001; for (int i = 0; i < table.Rows.Count; i++) { model.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); model.DJ002 = table.Rows [i] ["DJ002"].ToString( ); model.DJ003 = table.Rows [i] ["DJ003"].ToString( ); model.DJ004 = table.Rows [i] ["DJ004"].ToString( ); model.DJ005 = table.Rows [i] ["DJ005"].ToString( ); model.DJ006 = table.Rows [i] ["DJ006"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["DJ007"].ToString( ))) { model.DJ007 = null; } else { model.DJ007 = Convert.ToDateTime(table.Rows [i] ["DJ007"].ToString( )); } model.DJ008 = string.IsNullOrEmpty(table.Rows [i] ["DJ008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DJ008"].ToString( )); if (model.idx > 0) { edit_dj(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_101" + i, "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表身"), null); } else { add_dj(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_101" + i, "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表身"), null); } } if (bodyList.Count > 0) { foreach (string s in bodyList) { model.idx = Convert.ToInt32(s); delete_dj(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_101" + model.idx, "品质终检报告单(R_101)", logins, Drity.GetDt( ), _di.DI001, strSql.ToString( ).Replace("'", "''"), "删除", "删除表身"), null); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 编辑记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateMain(MulaolaoLibrary.DuanLiaoLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQIZ SET "); strSql.AppendFormat("IZ002='{0}',", model.IZ002); strSql.AppendFormat("IZ003='{0}',", model.IZ003); strSql.AppendFormat("IZ004='{0}',", model.IZ004); strSql.AppendFormat("IZ005='{0}',", model.IZ005); strSql.AppendFormat("IZ006='{0}',", model.IZ006); strSql.AppendFormat("IZ007='{0}',", model.IZ007); strSql.AppendFormat("IZ023='{0}',", model.IZ023); strSql.AppendFormat("IZ024='{0}',", model.IZ024); strSql.AppendFormat("IZ025='{0}',", model.IZ025); strSql.AppendFormat("IZ026='{0}',", model.IZ026); strSql.AppendFormat("IZ027='{0}',", model.IZ027); strSql.AppendFormat("IZ028='{0}',", model.IZ028); strSql.AppendFormat("IZ029='{0}',", model.IZ029); strSql.AppendFormat("IZ030='{0}',", model.IZ030); strSql.AppendFormat("IZ031='{0}',", model.IZ031); strSql.AppendFormat("IZ032='{0}',", model.IZ032); strSql.AppendFormat("IZ033='{0}',", model.IZ033); strSql.AppendFormat("IZ034='{0}',", model.IZ034); strSql.AppendFormat("IZ035='{0}'", model.IZ035); strSql.AppendFormat(" WHERE IZ001='{0}'", model.IZ001); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.IZ001, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// delete data from r_pqcN and r_pqc0 AND r_pqcp, and write operation to r_pqbf /// </summary> /// <param name="oddNum"></param> /// <param name="logins"></param> /// <returns></returns> public bool Delete(string oddNum, string logins) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("DELETE FROM R_PQCN "); strSql.AppendFormat("WHERE CN001='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation("R_044", "IQC进料检验报告(R_044)", logins, Drity.GetDt( ), oddNum, strSql.ToString( ).Replace("'", "''"), "删除", "删除")); strSql = new StringBuilder( ); strSql.Append("DELETE FROM R_PQCO "); strSql.AppendFormat("WHERE CO001='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation("R_044", "IQC进料检验报告(R_044)", logins, Drity.GetDt( ), oddNum, strSql.ToString( ).Replace("'", "''"), "删除", "删除")); strSql = new StringBuilder( ); strSql.Append("DELETE FROM R_PQCP "); strSql.AppendFormat("WHERE CP006='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation("R_044", "IQC进料检验报告(R_044)", logins, Drity.GetDt( ), oddNum, strSql.ToString( ).Replace("'", "''"), "删除", "删除")); strSql = new StringBuilder( ); strSql.Append("DELETE FROM R_REVIEWS "); strSql.AppendFormat("WHERE RES06='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation("R_044", "IQC进料检验报告(R_044)", logins, Drity.GetDt( ), oddNum, strSql.ToString( ).Replace("'", "''"), "删除", "删除")); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(MulaolaoLibrary.GongXuGongZiLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { Hashtable SQLString = new Hashtable( ); //ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQR SET "); strSql.AppendFormat("DS01='{0}',", model.DS01); strSql.AppendFormat("DS02='{0}',", model.DS02); strSql.AppendFormat("DS03='{0}',", model.DS03); strSql.AppendFormat("DS04='{0}',", model.DS04); strSql.AppendFormat("DS05='{0}',", model.DS05); strSql.AppendFormat("DS06='{0}',", model.DS06); strSql.AppendFormat("DS09='{0}',", model.DS09); strSql.AppendFormat("DS18='{0}',", model.DS18); strSql.AppendFormat("DS21='{0}',", model.DS21); strSql.AppendFormat("DS22='{0}',", model.DS22); strSql.AppendFormat("DS24='{0}',", model.DS24); strSql.AppendFormat("DS25='{0}',", model.DS25); strSql.AppendFormat("DS26='{0}',", model.DS26); strSql.Append("DS27=@DS27,"); strSql.AppendFormat("DS29='{0}'", model.DS29); strSql.AppendFormat(" WHERE idx='{0}'", model.Idx); SqlParameter [] parameter = { new SqlParameter("@DS27", SqlDbType.Date) }; parameter [0].Value = model.DS27; SQLString.Add(strSql.ToString( ), parameter); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.DS21, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd), null); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// save data to r_pqn,r_pqna /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <param name="strList"></param> /// <param name="logins"></param> /// <returns></returns> public bool Save(MulaolaoLibrary.CustomerrecordEntity model, DataTable table, string logins) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); model.KH01 = getOddNum( ); add_pqn(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_369", "客户信息传递记录表(R_369)", logins, Drity.GetDt( ), model.KH01, strSql.ToString( ).Replace("'", "''"), "新增", "增加"), null); MulaolaoLibrary.CustomerrecordNAEntity _na = new MulaolaoLibrary.CustomerrecordNAEntity( ); _na.NA001 = model.KH01; for (int i = 0; i < table.Rows.Count; i++) { _na.NA002 = table.Rows [i] ["NA002"].ToString( ); _na.NA003 = table.Rows [i] ["NA003"].ToString( ); _na.NA004 = table.Rows [i] ["NA004"].ToString( ); _na.NA005 = table.Rows [i] ["NA005"].ToString( ); _na.NA006 = table.Rows [i] ["NA006"].ToString( ); _na.NA007 = table.Rows [i] ["NA007"].ToString( ); _na.NA008 = table.Rows [i] ["NA008"].ToString( ); _na.NA009 = table.Rows [i] ["NA009"].ToString( ); add_pqna(SQLString, strSql, _na); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(MulaolaoLibrary.DuanLiaoLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQIZ SET "); strSql.AppendFormat("IZ005='{0}',", model.IZ005); strSql.AppendFormat("IZ008='{0}',", model.IZ008); strSql.AppendFormat("IZ009='{0}',", model.IZ009); strSql.AppendFormat("IZ010='{0}',", model.IZ010); strSql.AppendFormat("IZ011='{0}',", model.IZ011); strSql.AppendFormat("IZ012='{0}',", model.IZ012); strSql.AppendFormat("IZ013='{0}',", model.IZ013); strSql.AppendFormat("IZ014='{0}',", model.IZ014); strSql.AppendFormat("IZ015='{0}',", model.IZ015); strSql.AppendFormat("IZ016='{0}',", model.IZ016); strSql.AppendFormat("IZ017='{0}',", model.IZ017); strSql.AppendFormat("IZ018='{0}',", model.IZ018); strSql.AppendFormat("IZ019='{0}',", model.IZ019); strSql.AppendFormat("IZ020='{0}',", model.IZ020); strSql.AppendFormat("IZ021='{0}',", model.IZ021); strSql.AppendFormat("IZ022='{0}'", model.IZ022); strSql.AppendFormat(" WHERE IZ001='{1}' AND idx='{0}'", model.IDX, model.IZ001); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.IZ001, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool UpdateOfOne(MulaolaoLibrary.ContractToDoAJobLibrary _model, string tableNum, string tableName, string logins, DateTime dtOne, string oddNum, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQBA SET "); strSql.AppendFormat("BA001='{0}',", _model.BA001); strSql.AppendFormat("BA006='{0}',", _model.BA006); strSql.AppendFormat("BA007='{0}',", _model.BA007); strSql.AppendFormat("BA008='{0}',", _model.BA008); strSql.AppendFormat("BA009='{0}',", _model.BA009); strSql.AppendFormat("BA010='{0}',", _model.BA010); strSql.AppendFormat("BA011='{0}',", _model.BA011); strSql.AppendFormat("BA012='{0}',", _model.BA012); strSql.AppendFormat("BA013='{0}',", _model.BA013); strSql.AppendFormat("BA014='{0}',", _model.BA014); strSql.AppendFormat("BA051='{0}',", _model.BA051); strSql.AppendFormat("BA052='{0}',", _model.BA052); strSql.AppendFormat("BA053='{0}',", _model.BA053); strSql.AppendFormat("BA054='{0}',", _model.BA054); strSql.AppendFormat("BA059='{0}',", _model.BA059); strSql.AppendFormat("BA060='{0}'", _model.BA060); strSql.AppendFormat(" WHERE BA003='{1}' AND idx='{0}'", _model.IDX, _model.BA003); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, _model.BA003, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Update(MulaolaoLibrary.ContractToDoAJobLibrary _model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQBA SET "); //strSql.AppendFormat( "BA001='{0}'," ,_model.BA001); strSql.AppendFormat("BA002='{0}',", _model.BA002); strSql.AppendFormat("BA004='{0}',", _model.BA004); strSql.AppendFormat("BA005='{0}',", _model.BA005); strSql.AppendFormat("BA015='{0}',", _model.BA015); strSql.AppendFormat("BA016='{0}',", _model.BA016); strSql.AppendFormat("BA017='{0}',", _model.BA017); strSql.AppendFormat("BA018='{0}',", _model.BA018); strSql.AppendFormat("BA019='{0}',", _model.BA019); strSql.AppendFormat("BA020='{0}',", _model.BA020); strSql.AppendFormat("BA021='{0}',", _model.BA021); strSql.AppendFormat("BA022='{0}',", _model.BA022); strSql.AppendFormat("BA023='{0}',", _model.BA023); strSql.AppendFormat("BA024='{0}',", _model.BA024); strSql.AppendFormat("BA025='{0}',", _model.BA025); strSql.AppendFormat("BA026='{0}',", _model.BA026); strSql.AppendFormat("BA027='{0}',", _model.BA027); strSql.AppendFormat("BA028='{0}',", _model.BA028); strSql.AppendFormat("BA029='{0}',", _model.BA029); strSql.AppendFormat("BA030='{0}',", _model.BA030); strSql.AppendFormat("BA031='{0}',", _model.BA031); strSql.AppendFormat("BA032='{0}',", _model.BA032); strSql.AppendFormat("BA033='{0}',", _model.BA033); strSql.AppendFormat("BA034='{0}',", _model.BA034); strSql.AppendFormat("BA035='{0}',", _model.BA035); strSql.AppendFormat("BA036='{0}',", _model.BA036); strSql.AppendFormat("BA037='{0}',", _model.BA037); strSql.AppendFormat("BA038='{0}',", _model.BA038); strSql.AppendFormat("BA039='{0}',", _model.BA039); strSql.AppendFormat("BA040='{0}',", _model.BA040); strSql.AppendFormat("BA041='{0}',", _model.BA041); strSql.AppendFormat("BA042='{0}',", _model.BA042); strSql.AppendFormat("BA043='{0}',", _model.BA043); strSql.AppendFormat("BA044='{0}',", _model.BA044); strSql.AppendFormat("BA045='{0}',", _model.BA045); strSql.AppendFormat("BA046='{0}',", _model.BA046); strSql.AppendFormat("BA047='{0}',", _model.BA047); strSql.AppendFormat("BA048='{0}',", _model.BA048); strSql.AppendFormat("BA049='{0}',", _model.BA049); strSql.AppendFormat("BA050='{0}',", _model.BA050); //strSql.AppendFormat( "BA051='{0}'," ,_model.BA051 ); //strSql.AppendFormat( "BA052='{0}'," ,_model.BA052 ); //strSql.AppendFormat( "BA053='{0}'," ,_model.BA053 ); //strSql.AppendFormat( "BA054='{0}'," ,_model.BA054 ); strSql.AppendFormat("BA056='{0}',", _model.BA056); strSql.AppendFormat("BA057='{0}',", _model.BA057); strSql.AppendFormat("BA058='{0}'", _model.BA058); strSql.AppendFormat(" WHERE BA003='{0}'", _model.BA003); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, _model.BA003, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// save data to r_pqda r_pqdb /// </summary> /// <param name="table"></param> /// <param name="_da"></param> /// <param name="bodyList"></param> /// <param name="logins"></param> /// <returns></returns> public bool Save(DataTable table, MulaolaoLibrary.TestReportForAQDAEntity _da, List <string> bodyList, string logins) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); if (_da.idx < 1) { _da.DA001 = getOddNum( ); add_da(SQLString, strSql, _da); SQLString.Add(Drity.DrityOfComparation("R_142", "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表头"), null); } else { edit_da(SQLString, strSql, _da); SQLString.Add(Drity.DrityOfComparation("R_142", "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表头"), null); } MulaolaoLibrary.TestReportForAQDBEntity model = new MulaolaoLibrary.TestReportForAQDBEntity( ); model.DB001 = _da.DA001; for (int i = 0; i < table.Rows.Count; i++) { model.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); model.DB002 = table.Rows [i] ["DB002"].ToString( ); model.DB003 = table.Rows [i] ["DB003"].ToString( ); model.DB004 = string.IsNullOrEmpty(table.Rows [i] ["DB004"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB004"].ToString( )); model.DB005 = string.IsNullOrEmpty(table.Rows [i] ["DB005"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB005"].ToString( )); model.DB006 = string.IsNullOrEmpty(table.Rows [i] ["DB006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB006"].ToString( )); model.DB007 = string.IsNullOrEmpty(table.Rows [i] ["DB007"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB007"].ToString( )); model.DB008 = string.IsNullOrEmpty(table.Rows [i] ["DB008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB008"].ToString( )); model.DB009 = table.Rows [i] ["DB009"].ToString( ); model.DB010 = string.IsNullOrEmpty(table.Rows [i] ["DB010"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB010"].ToString( )); if (model.idx < 1) { add_db(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_142" + i, "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表身"), null); } else { edit_db(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_142" + i, "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表身"), null); } } if (bodyList.Count > 0) { foreach (string s in bodyList) { model.idx = Convert.ToInt32(s); delete_db(SQLString, strSql, model); SQLString.Add(Drity.DrityOfComparation("R_142" + model.idx, "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "删除", "删除表身"), null); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 更改复制单号 /// </summary> /// <param name="tableNum"></param> /// <param name="tableName"></param> /// <param name="logins"></param> /// <param name="dtOne"></param> /// <param name="oddNum"></param> /// <param name="stateOf"></param> /// <param name="stateOfOdd"></param> /// <returns></returns> public bool CopyAll ( string tableNum ,string tableName ,string logins ,DateTime dtOne ,string oddNum ,string stateOf ,string stateOfOdd ) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat( "UPDATE R_PQY SET PY33='{0}',PY37='' WHERE PY33 IS NULL" ,oddNum ); SQLString.Add( strSql.ToString( ) ); SQLString.Add( Drity.DrityOfComparation( tableNum ,tableName ,logins ,dtOne ,oddNum ,strSql.ToString( ).Replace( "'" ,"''" ) ,stateOf ,stateOfOdd ) ); return SqlHelper.ExecuteSqlTran( SQLString ); }
/// <summary> /// 复制 /// </summary> /// <param name="tableNum"></param> /// <param name="tableName"></param> /// <param name="logins"></param> /// <param name="dtOne"></param> /// <param name="oddNum"></param> /// <param name="stateOf"></param> /// <param name="stateOfOdd"></param> /// <returns></returns> public bool Copy ( string tableNum ,string tableName ,string logins ,DateTime dtOne ,string oddNum ,string stateOf ,string stateOfOdd ) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat( "INSERT INTO R_PQY (PY01,PY30,PY31,PY38,PY27,PY02,PY07,PY10,PY11,PY12,PY13,PY14,PY15,PY16,PY17,PY18,PY19,PY20,PY21,PY22,PY23,PY24,PY25,PY36,PY26,PY42,PY43) SELECT PY01,PY30,PY31,PY38,PY27,PY02,PY07,PY10,PY11,PY12,PY13,PY14,PY15,PY16,PY17,PY18,PY19,PY20,PY21,PY22,PY23,PY24,PY25,PY36,PY26,PY42,PY43 FROM R_PQY WHERE PY33='{0}'" ,oddNum ); SQLString.Add( strSql.ToString( ) ); SQLString.Add( Drity.DrityOfComparation( tableNum ,tableName ,logins ,dtOne ,oddNum ,strSql.ToString( ).Replace( "'" ,"''" ) ,stateOf ,stateOfOdd ) ); return SqlHelper.ExecuteSqlTran( SQLString ); }
//保存 protected override void save( ) { base.save( ); #region 入库 if (tabControl1.SelectedTab == tabPage1) { if (string.IsNullOrEmpty(comboBox3.Text)) { MessageBox.Show("采购库存物资名称不可为空"); return; } if (string.IsNullOrEmpty(comboBox10.Text)) { MessageBox.Show("货号不可为空"); return; } if (sign.Equals("2")) { if (rows == null || AC18 == "") { MessageBox.Show("请选择编辑的内容"); return; } build( ); strSql = new StringBuilder( ); SQLString.Clear( ); //,AC11='{9}',AC12='{10}' ,AC011 ,AC012 strSql.AppendFormat("UPDATE R_PQAC SET AC02='{0}' WHERE AC18='{1}'", AC02, AC18); SQLString.Add(strSql, null); SQLString.Add(Drity.DrityOfComparation("R_464", this.Text, Logins.username, DateTime.Now, AC18, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑入库"), null); result = SqlHelper.ExecuteSqlTran(SQLString); if (result == false) { MessageBox.Show("编辑数据失败"); } else { MessageBox.Show("成功编辑数据"); //int num = gridView2 . FocusedRowHandle; //DataRow row = sto . Rows [ num ]; rows.BeginEdit( ); rows ["AC02"] = AC02; rows.EndEdit( ); gridControl1.Refresh( ); } } } #endregion toolSelect.Enabled = toolAdd.Enabled = toolUpdate.Enabled = toolDelete.Enabled = true; toolPrint.Enabled = toolExport.Enabled = toolMaintain.Enabled = toolSave.Enabled = toolCancel.Enabled = false; }
/// <summary> /// 更改复制单号 /// </summary> /// <param name="tableNum"></param> /// <param name="tableName"></param> /// <param name="logins"></param> /// <param name="dtOne"></param> /// <param name="oddNum"></param> /// <param name="stateOf"></param> /// <param name="stateOfOdd"></param> /// <returns></returns> public bool CopyAll(string tableNum, string tableName, string logins, DateTime dtOne, string oddNum, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("UPDATE R_PQT SET WX82='{0}',WX89='复制',WX21=DATEADD(DAY,5,GETDATE()) WHERE WX82 IS NULL", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 复制 /// </summary> /// <param name="tableNum"></param> /// <param name="tableName"></param> /// <param name="logins"></param> /// <param name="dtOne"></param> /// <param name="oddNum"></param> /// <param name="stateOf"></param> /// <param name="stateOfOdd"></param> /// <returns></returns> public bool Copy(string tableNum, string tableName, string logins, DateTime dtOne, string oddNum, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("INSERT INTO R_PQT (WX01,WX83,WX84,WX85,WX86,WX02,WX10,WX11,WX12,WX13,WX14,WX15,WX16,WX87,WX17,WX18,WX19,WX20,WX23,WX24,WX25,WX26,WX27,WX28,WX29,WX30,WX31,WX32,WX33,WX35,WX36,WX37,WX38,WX39,WX40,WX41,WX42,WX43,WX44,WX45,WX46,WX47,WX48,WX49,WX50,WX51,WX56,WX57,WX58,WX59,WX60,WX61,WX62,WX63,WX64,WX65,WX66,WX67,WX68,WX72,WX77,WX78,WX79) SELECT WX01,WX83,WX84,WX85,WX86,WX02,WX10,WX11,WX12,WX13,WX14,WX15,WX16,WX87,WX17,WX18,WX19,WX20,WX23,WX24,WX25,WX26,WX27,WX28,WX29,WX30,WX31,WX32,WX33,WX35,WX36,WX37,WX38,WX39,WX40,WX41,WX42,WX43,WX44,WX45,WX46,WX47,WX48,WX49,WX50,WX51,WX56,WX57,WX58,WX59,WX60,WX61,WX62,WX63,WX64,WX65,WX66,WX67,WX68,WX72,WX77,WX78,WX79 FROM R_PQT WHERE WX82='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
public bool delete(string oddNum, string logins) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("DELETE FROM R_PQL WHERE HT64='{0}'", oddNum); SQLString.Add(strSql, null); SQLString.Add(Drity.DrityOfComparation("R_021", "合同评审表(R_021)", logins, Drity.GetDt( ), oddNum, strSql.ToString( ).Replace("'", "''"), "删除", "取消删除"), null); return(SqlHelper.ExecuteSqlTran(SQLString)); }
public bool delete(string logins) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("DELETE FROM R_PQL WHERE HT04='' AND HT04 IS NULL"); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation("R_021", "合同评审表(R_021)", logins, Drity.GetDt( ), "", strSql.ToString( ).Replace("'", "''"), "删除", "删除空白")); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 删除一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool DeleteAl(MulaolaoLibrary.CheckOutLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfState) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("DELETE FROM R_PQAL WHERE AL001='{0}' ", model.Idx); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.AK014, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfState)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 批量编辑工序名称 同流水,同工序 /// </summary> /// <param name="num"></param> /// <param name="oddNum"></param> /// <param name="tableName"></param> /// <param name="tableNum"></param> /// <param name="logins"></param> /// <param name="dtOne"></param> /// <param name="stateOf"></param> /// <param name="stateOfOdd"></param> /// <param name="work"></param> /// <param name="part"></param> /// <returns></returns> public bool BatchGX(string num, string oddNum, string tableName, string tableNum, string logins, DateTime dtOne, string stateOf, string stateOfOdd, string work, string part) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("UPDATE R_PQR SET DS04='{0}' WHERE DS01='{1}' AND DS21='{2}' AND DS04='{3}' ", work, num, oddNum, part); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 复制 /// </summary> /// <param name="tableNum"></param> /// <param name="tableName"></param> /// <param name="logins"></param> /// <param name="dtOne"></param> /// <param name="oddNum"></param> /// <param name="stateOf"></param> /// <param name="stateOfOdd"></param> /// <returns></returns> public bool Copy(string tableNum, string tableName, string logins, DateTime dtOne, string oddNum, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("INSERT INTO R_PQS (PJ01,PJ93,PJ94,PJ95,PJ96,PJ03,PJ09,PJ10,PJ11,PJ12,PJ13,PJ97,PJ14,PJ15,PJ16,PJ17,PJ18,PJ21,PJ24,PJ27,PJ30,PJ33,PJ34,PJ35,PJ36,PJ37,PJ38,PJ39,PJ40,PJ41,PJ42,PJ43,PJ44,PJ45,PJ46,PJ47,PJ48,PJ49,PJ50,PJ51,PJ52,PJ53,PJ54,PJ55,PJ56,PJ57,PJ58,PJ59,PJ60,PJ61,PJ62,PJ63,PJ64,PJ65,PJ66,PJ67,PJ68,PJ69,PJ70,PJ71,PJ72,PJ73,PJ74,PJ75,PJ76,PJ77,PJ89,PJ105) SELECT PJ01,PJ93,PJ94,PJ95,PJ96,PJ03,PJ09,PJ10,PJ11,PJ12,PJ13,PJ97,PJ14,PJ15,PJ16,PJ17,PJ18,PJ21,PJ24,PJ27,PJ30,PJ33,PJ34,PJ35,PJ36,PJ37,PJ38,PJ39,PJ40,PJ41,PJ42,PJ43,PJ44,PJ45,PJ46,PJ47,PJ48,PJ49,PJ50,PJ51,PJ52,PJ53,PJ54,PJ55,PJ56,PJ57,PJ58,PJ59,PJ60,PJ61,PJ62,PJ63,PJ64,PJ65,PJ66,PJ67,PJ68,PJ69,PJ70,PJ71,PJ72,PJ73,PJ74,PJ75,PJ76,PJ77,PJ89,PJ105 FROM R_PQS WHERE PJ92='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 复制 /// </summary> /// <param name="oddNum"></param> /// <param name="tableNum"></param> /// <param name="tableName"></param> /// <param name="logins"></param> /// <param name="dtOne"></param> /// <param name="stateOf"></param> /// <param name="stateOfOdd"></param> /// <returns></returns> public bool Copy(string oddNum, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("INSERT INTO R_PQU (PQU01,PQU98,PQU99,PQU100,PQU101,PQU02,PQU03,PQU10,PQU11,PQU12,PQU13,PQU14,PQU15,PQU16,PQU17,PQU104,PQU18,PQU19,PQU20,PQU21,PQU24,PQU25,PQU26,PQU27,PQU28,PQU29,PQU32,PQU33,PQU34,PQU35,PQU36,PQU37,PQU38,PQU39,PQU40,PQU41,PQU42,PQU43,PQU44,PQU47,PQU49,PQU50,PQU51,PQU52,PQU53,PQU54,PQU55,PQU56,PQU57,PQU58,PQU59,PQU60,PQU61,PQU62,PQU63,PQU64,PQU65,PQU66,PQU67,PQU68,PQU69,PQU70,PQU72,PQU73,PQU76,PQU77,PQU78,PQU79,PQU80,PQU81,PQU82,PQU83,PQU84,PQU85) SELECT PQU01,PQU98,PQU99,PQU100,PQU101,PQU02,PQU03,PQU10,PQU11,PQU12,PQU13,PQU14,PQU15,PQU16,PQU17,PQU104,PQU18,PQU19,PQU20,PQU21,PQU24,PQU25,PQU26,PQU27,PQU28,PQU29,PQU32,PQU33,PQU34,PQU35,PQU36,PQU37,PQU38,PQU39,PQU40,PQU41,PQU42,PQU43,PQU44,PQU47,PQU49,PQU50,PQU51,PQU52,PQU53,PQU54,PQU55,PQU56,PQU57,PQU58,PQU59,PQU60,PQU61,PQU62,PQU63,PQU64,PQU65,PQU66,PQU67,PQU68,PQU69,PQU70,PQU72,PQU73,PQU76,PQU77,PQU78,PQU79,PQU80,PQU81,PQU82,PQU83,PQU84,PQU85 FROM R_PQU WHERE PQU97='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 删除一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Delete(int idx, string logins, string oddNum) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("DELETE FROM R_PQPZ "); strSql.AppendFormat(" WHERE idx={0}", idx); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation("R_346", "产品滚漆成本汇总表(R_346)", logins, DateTime.Now, oddNum, strSql.ToString( ).Replace("'", "''"), "删除", "删除")); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 复制 /// </summary> /// <param name="oddNum"></param> /// <param name="tableNum"></param> /// <param name="tableName"></param> /// <param name="logins"></param> /// <param name="dtOne"></param> /// <param name="stateOf"></param> /// <param name="stateOfOdd"></param> /// <returns></returns> public bool Copy(string oddNum, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQAF (AF002,AF003,AF004,AF005,AF006,AF007,AF008,AF015,AF016,AF017,AF018,AF019,AF020,AF021,AF022,AF023,AF026,AF027,AF028,AF029,AF030,AF031,AF032,AF033,AF034,AF037,AF038,AF039,AF040,AF046,AF047,AF052,AF053,AF054,AF055,AF056,AF057,AF058,AF059,AF060,AF061,AF062,AF063,AF084) SELECT AF002,AF003,AF004,AF005,AF006,AF007,AF008,AF015,AF016,AF017,AF018,AF019,AF020,AF021,AF022,AF023,AF026,AF027,AF028,AF029,AF030,AF031,AF032,AF033,AF034,AF037,AF038,AF039,AF040,AF046,AF047,AF052,AF053,AF054,AF055,AF056,AF057,AF058,AF059,AF060,AF061,AF062,AF063,AF084 FROM R_PQAF"); strSql.AppendFormat(" WHERE AF001='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 复制数据 /// </summary> /// <param name="oddNum"></param> /// <returns></returns> public bool Copy(string oddNum, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQBA (BA001,BA002,BA004,BA005,BA015,BA016,BA017,BA018,BA019,BA020,BA021,BA022,BA023,BA024,BA025,BA026,BA027,BA028,BA029,BA030,BA031,BA042,BA044,BA045,BA046,BA047,BA048,BA051,BA052,BA053,BA054,BA058) SELECT BA001,BA002,BA004,BA005,BA015,BA016,BA017,BA018,BA019,BA020,BA021,BA022,BA023,BA024,BA025,BA026,BA027,BA028,BA029,BA030,BA031,BA042,BA044,BA045,BA046,BA047,BA048,BA051,BA052,BA053,BA054,BA058 FROM R_PQBA "); strSql.AppendFormat(" WHERE BA003='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 编辑零件数量 /// </summary> /// <param name="num"></param> /// <returns></returns> public bool UpdateLJ(string num, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd, string oddNum) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQR SET DS29=(SELECT GS FROM (SELECT DISTINCT GS01,GS07 GZ,CONVERT(DECIMAL(6,0),GS10) GS FROM R_PQP) A WHERE GZ!='' AND GZ IS NOT NULL AND A.GS01=DS01 AND A.GZ=DS03)"); strSql.AppendFormat(" WHERE DS01='{0}'", num); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 删除一条记录 /// </summary> /// <param name="oddNum"></param> /// <returns></returns> public bool DeleteOddNum(string oddNum, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("DELETE FROM R_PQR"); strSql.AppendFormat(" WHERE DS21='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 编辑复制数据 /// </summary> /// <param name="oddNum"></param> /// <returns></returns> public bool UpdateOfCopy(string oddNum, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQBA SET "); strSql.AppendFormat("BA003='{0}',", oddNum); strSql.Append("BA055='复制'"); strSql.Append(" WHERE BA003 IS NULL"); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 复制一条记录 /// </summary> /// <param name="oddNum"></param> /// <returns></returns> public bool Copy(string oddNum, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQIZ (IZ002,IZ003,IZ004,IZ005,IZ008,IZ009,IZ010,IZ011,IZ012,IZ013,IZ014,IZ015,IZ016,IZ018,IZ019,IZ020,IZ021,IZ022,IZ034)"); strSql.Append(" SELECT IZ002,IZ003,IZ004,IZ005,IZ008,IZ009,IZ010,IZ011,IZ012,IZ013,IZ014,IZ015,IZ016,IZ018,IZ019,IZ020,IZ021,IZ022,IZ034 FROM R_PQIZ"); strSql.AppendFormat(" WHERE IZ001='{0}'", oddNum); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Insert(MulaolaoLibrary.DuanLiaoLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQIZ ("); strSql.Append("IZ001,IZ005,IZ008,IZ009,IZ010,IZ011,IZ012,IZ013,IZ014,IZ015,IZ016,IZ017,IZ018,IZ019,IZ020,IZ021,IZ022)"); strSql.Append(" VALUES ("); strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}')", model.IZ001, model.IZ005, model.IZ008, model.IZ009, model.IZ010, model.IZ011, model.IZ012, model.IZ013, model.IZ014, model.IZ015, model.IZ016, model.IZ017, model.IZ018, model.IZ019, model.IZ020, model.IZ021, model.IZ022); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.IZ001, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Add(MulaolaoLibrary.ContractToDoAJobLibrary _model, string tableNum, string tableName, string logins, DateTime dtOne, string oddNum, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQBA ("); strSql.Append("BA001,BA002,BA003,BA006,BA007,BA008,BA009,BA010,BA011,BA012,BA013,BA014,BA051,BA052,BA053,BA054,BA059,BA060)"); strSql.Append(" VALUES ("); strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}')", _model.BA001, _model.BA002, _model.BA003, _model.BA006, _model.BA007, _model.BA008, _model.BA009, _model.BA010, _model.BA011, _model.BA012, _model.BA013, _model.BA014, _model.BA051, _model.BA052, _model.BA053, _model.BA054, _model.BA059, _model.BA060); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, _model.BA003, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }