/// <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>
/// 获取单号
/// </summary>
/// <returns></returns>
public string getOddNum( )
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT MAX(QUO001) QUO001 FROM R_QUO");
DataTable dt = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (dt != null && dt.Rows.Count > 0)
{
string odd = dt.Rows [0] ["QUO001"].ToString( );
if (string.IsNullOrEmpty(odd))
{
return("R_504-" + Drity.GetDt( ).ToString("yyyyMMdd") + "0001");
}
else
{
if (odd.Substring(6, 8).Equals(Drity.GetDt( ).ToString("yyyyMMdd")))
{
return("R_504-" + (Convert.ToInt64(odd.Substring(6, odd.Length - 6)) + 1).ToString( ));
}
else
{
return("R_504-" + Drity.GetDt( ).ToString("yyyyMMdd") + "0001");
}
}
}
else
{
return("R_504-" + Drity.GetDt( ).ToString("yyyyMMdd") + "0001");
}
}
/// <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>
/// get max oddNum from r_pqch
/// </summary>
/// <returns></returns>
public string getOddNum( )
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT MAX(CN001) CN001 FROM R_PQCN ");
strSql.AppendFormat("WHERE CN001 LIKE 'R_044-{0}%'", Drity.GetDt( ).ToString("yyyyMMdd"));
DataTable dt = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (dt != null && dt.Rows.Count > 0)
{
string oddNum = dt.Rows [0] ["CN001"].ToString( );
if (string.IsNullOrEmpty(oddNum))
{
return("R_044-" + Drity.GetDt( ).ToString("yyyyMMdd") + "0001");
}
else
{
oddNum = "R_044-" + (Convert.ToInt64(oddNum.Substring(6, 12)) + 1).ToString( );
return(oddNum);
}
}
else
{
return("R_044-" + Drity.GetDt( ).ToString("yyyyMMdd") + "0001");
}
}
/// <summary>
/// 获取新的单号
/// </summary>
/// <returns></returns>
string getOdd( )
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT MAX(CA001) CA001 FROM R_PQCA ");
DataTable dt = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (dt != null && dt.Rows.Count > 0)
{
if (string.IsNullOrEmpty(dt.Rows [0] ["CA001"].ToString( )))
{
return("R_376-" + Drity.GetDt( ).ToString("yyyyMMdd") + "001");
}
else
{
if (dt.Rows [0] ["CA001"].ToString( ).Substring(6, 8).Equals(Drity.GetDt( ).ToString("yyyyMMdd")))
{
return("R_376-" + (Convert.ToInt64(dt.Rows [0] ["CA001"].ToString( ).Substring(6, 11)) + 1).ToString( ));
}
else
{
return("R_376-" + Drity.GetDt( ).ToString("yyyyMMdd") + "001");
}
}
}
else
{
return("R_376-" + Drity.GetDt( ).ToString("yyyyMMdd") + "001");
}
}
/// <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>
/// 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>
/// 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>
/// <returns></returns>
public string getCode( )
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT MAX(INA001) INA001 FROM R_INA");
DataTable table = SqlHelper.ExecuteDataTable(strSql.ToString( ));
DateTime dt = Drity.GetDt( );
if (table == null || table.Rows.Count < 1)
{
return(dt.ToString("yyyyMMdd") + "001");
}
else
{
string code = table.Rows [0] ["INA001"].ToString( );
if (string.IsNullOrEmpty(code))
{
return(dt.ToString("yyyyMMdd") + "001");
}
else if (code.Substring(0, 8).Equals(dt.ToString("yyyyMMdd")))
{
return((Convert.ToInt64(code) + 1).ToString( ));
}
else
{
return(dt.ToString("yyyyMMdd") + "001");
}
}
}
/// <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>
/// 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 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;
}
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));
}
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));
}
/// <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="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="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));
}
/// <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="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>
/// <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="_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="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 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));
}
