//public static bool CheckImportTable(int iType, UserInfo user, ref string strError) //{ // switch (iType) // { // case 1: // Basic.Area.Area_DB areadb = new Basic.Area.Area_DB(); // return areadb.CheckImportTable(ref strError); // case 2: // Stock.Stock_DB stockdb = new Stock.Stock_DB(); // return stockdb.CheckImportTable(ref strError); // default: // strError = "找不到对应的导入类型"; // return false; // } //} public static bool UpLoadSql(List <string> lstSql, User.UserModel user, ref string strError) { if (lstSql == null || lstSql.Count <= 0) { strError = "上传数据不能为空"; return(false); } if (OracleDBHelper.ExecuteNonQueryList(lstSql, ref strError) >= 1) { return(true); } else { if (string.IsNullOrEmpty(strError)) { try { OracleDBHelper.ExecuteNonQuery2(CommandType.Text, lstSql[0], null); if (lstSql.Count >= 2) { OracleDBHelper.ExecuteNonQuery2(CommandType.Text, lstSql[1], null); } } catch (Exception ex) { strError = ex.Message; } } return(false); } }
public bool SaveModelBySqlToDB(User.UserModel user, ref TBase_Model model, ref string strError) { try { List <string> lstSql = new List <string>(); int i = OracleDBHelper.ExecuteNonQueryList(this.GetSaveSql(user, ref model), ref strError); if (i > 0) { model = GetModelByID(model.ID); if (model == null) { strError = "GetModelByID(modelID)出错,没有找到相符的记录,可能是视图有错误!"; return(false); } else { return(true); } } else { return(false); } } catch (Exception ex) { strError = ex.Message; return(false); //throw new Exception(ex.Message); } }
public bool UpdateModelListBySqlToDB(User.UserModel user, ref List <TBase_Model> modelList, ref string strError) { try { List <string> lstSql = new List <string>(); lstSql = this.GetUpdateModelListSql(user, modelList); if (lstSql == null || lstSql.Count == 0) { return(true); } int i = OracleDBHelper.ExecuteNonQueryList(lstSql, ref strError); if (i > 0) { return(true); } else { return(false); } } catch (Exception ex) { strError = ex.Message; return(false); //throw new Exception(ex.Message); } }
public bool SaveModelListBySqlToDB(List <string> lstSql, ref string strError) { try { int i = OracleDBHelper.ExecuteNonQueryList(lstSql, ref strError); if (i > 0) { return(true); } else { return(false); } } catch (Exception ex) { strError = ex.Message; return(false); //throw new Exception(ex.Message); } }
public virtual bool UpdateModelByModelSql(User.UserModel user, TBase_Model model, ref string strError) { try { List <string> lstSql = new List <string>(); int i = OracleDBHelper.ExecuteNonQueryList(this.GetUpdateSql(user, model), ref strError); if (i > 0) { return(true); } else { return(false); } } catch (Exception ex) { strError = ex.Message; return(false); //throw new Exception(ex.Message); } }
public bool UpdateModelListStatusBySql(List <string> sqlList, ref string strError) { try { List <string> lstSql = new List <string>(); int i = OracleDBHelper.ExecuteNonQueryList(sqlList, ref strError); if (i > 0) { return(true); } else { return(false); } } catch (Exception ex) { strError = ex.Message; return(false); //throw new Exception(ex.Message); } }