/// <summary> /// ��������� /// </summary> /// <param name="s_Pr"></param> /// <returns></returns> public static string Data_Add(string s_Pr) { string CodeA = ""; DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL(); SqlParameter[] prams ={ db.MakeInParam("@Flag", SqlDbType.VarChar,50,s_Pr) }; SqlDataReader dr = null; try { db.GetDataReader(visitor, prams, out dr, "D_Add"); if (dr.Read()) { CodeA = dr["Code"].ToString(); } dr.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return CodeA; }
/// <summary> /// 查询出所有的数据 /// </summary> /// <returns>返回数据源</returns> public static string BillInfoSql(string Code) { string retSql = ""; DataBase db = new DataBase(); DataBaseVisitor visitor = new BillInfoDAL(); SqlDataReader myread; try { db.GetDataReader(visitor, null, out myread, "BillInfoSql"); while(myread.Read()) { retSql += "," + myread["DBName"].ToString().Trim()+" as " + myread["Name"].ToString().Trim(); } myread.Close(); retSql= retSql.Substring(1); retSql = "Select " + retSql + " From V_D_Saver_D Where Code='"+Code.Trim()+"'"; } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return retSql; }
/// <summary> /// 查询出所有的数据 /// </summary> /// <returns>返回数据源</returns> public static DataSet BillPrint(string Code,string TableName) { string retSql = ""; DataBase db = new DataBase(); DataBaseVisitor visitor = new BillInfoDAL(); DataSet ds = new DataSet(); try { ds = db.ReturnDataSet(BillInfoSql(Code), TableName); //在程序中表示的名字给Capion int i=0; foreach (DataRow row in BillInfoColName().Tables[0].Rows) { ds.Tables[TableName].Columns[i].Caption = row[0].ToString().Trim(); i++; } } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return ds; }
/// <summary> /// 最大ID /// </summary> /// <param name="Content"></param> /// <returns></returns> public static long MaxID() { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.MyLog.DL_Run(); long ret_V = 0; try { SqlDataReader dr; db.GetDataReader(visitor,null,out dr, "MaxID"); if (dr.Read()) { if(dr[0] !=null) ret_V = long.Parse(dr[0].ToString()); } ret_V += 1; //ds = db.ReturnDataSet(visitor, prams, "Select"); } catch (Exception ex) { return 0; throw new Exception(ex.Message); } finally { db.Dispose(); } return ret_V; }
/// <summary> /// 插入一条操作记录,并返回他的编号 /// </summary> /// <param name="Content"></param> /// <returns></returns> public static string Insert(string Content) { string ret_Code = MaxID().ToString(); DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.MyLog.DL_Run(); SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.BigInt,8, long.Parse(ret_Code)), db.MakeInParam("@Code", SqlDbType.VarChar,50,ret_Code), db.MakeInParam("@Work", SqlDbType.VarChar,50, Content), db.MakeInParam("@InTime", SqlDbType.DateTime,8, DateTime.Now), db.MakeInParam("@OperCode", SqlDbType.VarChar,50, Model.User.LUser.Code), db.MakeInParam("@TableNum", SqlDbType.VarChar,50, Model.User.LUser.TableNum) }; try { db.TransactSql(visitor, "Insert", prams); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return ret_Code; }
/// <summary> /// 添加数据 /// </summary> /// <param name="Item">model</param> /// <returns>"0101"表示成功,"0"表示失败</returns> public static string Insert(D_CarCodeModel Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new D_CarCodeVisitor(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_CarCode")), db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code), db.MakeInParam("@CarCode", SqlDbType.VarChar,50, Item.CarCode), db.MakeInParam("@Tare", SqlDbType.Float,12, Item.Tare), db.MakeInParam("@Driver", SqlDbType.VarChar,50, Item.Driver), }; try { bSuc = db.TransactSql(visitor, "Insert", prams, out nEffectRows); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } if (bSuc && nEffectRows > 0) return "0101"; else return "0"; }
/// <summary> /// 修改数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool Update(D_Bill Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new BillDAL(); bool Flag = false, ReFlag = false; int N = 0; SqlParameter[] prams ={ db.MakeInParam("@BillName", SqlDbType.VarChar,50, Item.BillName), db.MakeInParam("@PrintTitle", SqlDbType.VarChar,50, Item.PrintTitle), db.MakeInParam("@Preview", SqlDbType.Bit,50, Item.Preview), db.MakeInParam("@Id", SqlDbType.BigInt,0,Item.Id) }; try { ReFlag = db.TransactSql(visitor, "Update", prams, out N); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } if (ReFlag && N > 0) { Flag = true; } return Flag; }
public static string AddMaintenance(Model.MyLog.DL_Maintenance DL_MainItem) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.Float,50, DL_MainItem.ID), db.MakeInParam("@TableNum", SqlDbType.VarChar,50,DL_MainItem.TableNum), db.MakeInParam("@SaverCode", SqlDbType.VarChar,50, DL_MainItem.SaverCode), db.MakeInParam("@WorkCode", SqlDbType.VarChar,50, DL_MainItem.WorkCode), db.MakeInParam("@OperCode", SqlDbType.VarChar,50, DL_MainItem.OperCode), }; try { bSuc = db.TransactSql(visitor, "AddMaintenance", prams, out nEffectRows); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } if (bSuc && nEffectRows > 0) return "0101"; else return "0"; }
/// <summary> /// 检查主键 /// </summary> /// <param name="Tab">表名</param> /// <param name="key">要检查的字段名</param> /// <param name="value">要检查的值</param> /// <param name="Id">Id等于0代表添加操作,否则就是修改操作</param> public static bool CheckKey(string Tab, string key, string value, long Id) { bool Flag = false; DataBase db = new DataBase(); SqlDataReader dr = null; try { if (Id == 0) { db.GetDataReader(out dr, "select * from " + Tab + " where " + key + "='" + value + "'"); if (dr.Read()) { Flag = true; } } else { db.GetDataReader(out dr, "select * from " + Tab + " where Id<>" + Id + " and " + key + "='" + value + "'"); if (dr.Read()) { Flag = true; } } } catch (Exception ex) { throw ex; } finally { dr.Close(); db.Dispose(); } return Flag; }
/// <summary> /// 根据名字查询编号 /// </summary> /// <returns></returns> public static string SelectByName(string Name) { string Code = ""; DataBase db = new DataBase(); DataBaseVisitor visitor = new DC_BaseVisitor(); SqlDataReader dr = null; SqlParameter[] prams ={ db.MakeInParam("@Name", SqlDbType.VarChar,50, Name), }; try { db.GetDataReader(visitor, prams, out dr, "SelectByName"); if (dr.Read()) { Code = dr["Code"].ToString(); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return Code; }
/// <summary> /// ������� /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static string Insert(Model.Count.D_StatProjectModel Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Count.D_StatProjectDal(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.VarChar,50, PublicFun.PublicFun.MaxId("D_StatProject")), db.MakeInParam("@Code", SqlDbType.VarChar,50,PublicFun.PublicFun.MaxId("D_StatProject")), db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), }; try { bSuc = db.TransactSql(visitor, "Insert", prams, out nEffectRows); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } if (bSuc && nEffectRows > 0) return "0101"; else return "0"; }
/// <summary> /// 修改数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static string Update(DC_BaseModel Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DC_BaseVisitor(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code), db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), db.MakeInParam("@AS", SqlDbType.VarChar,50, Item.AS), db.MakeInParam("@Flag", SqlDbType.VarChar,50, Item.Flag), db.MakeInParam("@Rank", SqlDbType.VarChar,50, Item.Rank), db.MakeInParam("@ID", SqlDbType.VarChar,50, Item.ID), }; try { bSuc = db.TransactSql(visitor, "Update", prams, out nEffectRows); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } if (bSuc && nEffectRows > 0) return "0101"; else return "0"; }
public static bool AddCurve(string Code, WSV.Model.Weight.WeightModel value) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.MyLog.DL_WeightVisitor(); bool retvalue = true; SqlParameter[] prams ={ db.MakeInParam("@Code",SqlDbType.VarChar,50,Code) }; SqlDataReader Reader = null; try { db.GetDataReader(visitor, prams, out Reader, "AddCurve"); if (Reader.Read()) { value.StateFun.Curve = (byte[])Reader["Curve"]; } else { retvalue = false; } } catch (Exception e) { db.Dispose(); return false; } finally { db.Dispose(); } return retvalue; }
/// <summary> /// 查询角色是否拥有某个权限 /// </summary> /// <param name="RoleCode">角色编号</param> /// <param name="PowerCode">权限编号</param> /// <returns></returns> public static bool CheckRolePower(string RuleName) { if (LUser.Id <= 2) return true; DataBase db = new DataBase(); DataBaseVisitor visitor = new RoleDAL(); bool Flag = false; SqlParameter[] prams ={ db.MakeInParam("@RoleCode", SqlDbType.VarChar,50,LUser.Role), db.MakeInParam("@RuleName", SqlDbType.VarChar,50,RuleName) }; try { SqlDataReader dr; db.GetDataReader(visitor, prams, out dr, "CheckRolePower"); if (dr.Read()) { Flag = true; } } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return Flag; }
public static string Update(Model.Video.D_Video Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Video.VideoVisitor(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@VIDEOname",SqlDbType .Char ,10,Item.VIDEO_name), db.MakeInParam("@VIDEOtable",SqlDbType .VarChar ,50,Item.VIDEO_table ), db.MakeInParam("@VIDEOStandard",SqlDbType.Int ,4,Item.VIDEO_Standard ), db.MakeInParam("@VIDEOSource",SqlDbType.Int,4,Item.VIDEO_Source ), db.MakeInParam("@VIDEOBrightness",SqlDbType.Int,4,Item.VIDEO_Brightness ), db.MakeInParam("@VIDEOContrast",SqlDbType.Int,4,Item.VIDEO_Contrast ), db.MakeInParam("@VIDEOHue",SqlDbType.Int,4,Item.VIDEO_Hue ), db.MakeInParam("@VIDEOSaturation",SqlDbType.Int,4,Item.VIDEO_Saturation ), db.MakeInParam("@VIDEOSuality",SqlDbType.Int,4,Item.VIDEO_Suality) }; try { bSuc = db.TransactSql(visitor, "Set_Video", prams, out nEffectRows); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } if (bSuc && nEffectRows > 0) return "0101"; else return "0"; }
public static bool Delete(string S_Pr) { bool retvalue = true; DataBase db = new DataBase(); DataBaseVisitor visitor = new CardDAL(); SqlParameter[] prams = { db.MakeInParam("@Card",SqlDbType.VarChar,50,S_Pr) }; try { db.TransactSql(visitor, "Delete", prams); } catch (Exception err) { db.Dispose(); MessageBox.Show(err.Message, "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information); return false; } finally { db.Dispose(); } return retvalue; }
/// <summary> /// 修改数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool Update(C_Weight Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WeightDAL(); bool Flag = false, ReFlag = false; int N = 0; SqlParameter[] prams ={ db.MakeInParam("@Save", SqlDbType.Bit,0, Item.Save), db.MakeInParam("@Show", SqlDbType.Bit,0, Item.Show), db.MakeInParam("@Time", SqlDbType.BigInt,0, Item.Time), db.MakeInParam("@Id", SqlDbType.BigInt,0,Item.Id) }; try { ReFlag = db.TransactSql(visitor, "Update", prams, out N); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } if (ReFlag && N > 0) { Flag = true; } return Flag; }
/// <summary> /// 根据编号查询表内容 /// </summary> /// <param name="Item">D_Plan表model</param> public static void GetPlan(ref Model.Plan.D_Plan Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Plan.PlanVisitor(); SqlDataReader dr = null; SqlParameter[] prams ={ db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50, Item.Plan_Code), }; try { db.GetDataReader(visitor, prams, out dr, "Select_D_PlanByCode"); if (dr.Read()) { Item.Plan_Item = dr["Plan_Item"].ToString(); Item.Plan_Send = dr["Plan_Send"].ToString(); Item.Plan_Specs = dr["Plan_Specs"].ToString(); Item.Plan_Accept = dr["Plan_Accept"].ToString(); Item.Plan_CountWay = dr["Plan_CountWay"].ToString(); Item.Plan_Type = dr["Plan_Type"].ToString(); Item.Plan_Num = Convert.ToDecimal(dr["Plan_Num"]); Item.Plan_SpareNum = Convert.ToDecimal(dr["Plan_SpareNum"]); Item.Plan_Money = Convert.ToDecimal(dr["Plan_Money"]); Item.Plan_SpareMoney = Convert.ToDecimal(dr["Plan_SpareMoney"]); Item.Remark = dr["Remark"].ToString(); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { dr.Close(); db.Dispose(); } }
/// <summary> /// 检查用户密码 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool CheckPwd(string pass) { DataBase db = new DataBase(); DataBaseVisitor visitor = new UsersDAL(); bool Flag = false; SqlParameter[] prams ={ db.MakeInParam("@Uid",SqlDbType.VarChar,50,LUser.Uid), db.MakeInParam("@Pwd",SqlDbType.VarChar,50,pass) }; try { SqlDataReader dr; db.GetDataReader(visitor, prams, out dr, "UserLock"); if (dr.Read()) { Flag = true; } } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return Flag; }
/// <summary> /// 添加数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool Insert(DC_Power Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new PowerDAL(); bool Flag = false, ReFlag = false; int N = 0; SqlParameter[] prams ={ db.MakeInParam("@Id", SqlDbType.BigInt,0,PublicFun.PublicFun.MaxId("DC_Power")), db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code), db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), db.MakeInParam("@ParentCode", SqlDbType.VarChar,50, Item.ParentCode), db.MakeInParam("@RuleName", SqlDbType.VarChar,50, Item.RuleName) }; try { ReFlag = db.TransactSql(visitor, "Insert", prams, out N); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } if (ReFlag && N > 0) { Flag = true; } return Flag; }
/// <summary> /// 添加数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static string AddData(WSV.Model.Weight.WeightModel Weight) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.Int,4, BLL.PublicFun.PublicFun.MaxId("D_Saver")), db.MakeInParam("@Code", SqlDbType.VarChar,50, Weight.Code), db.MakeInParam("@CarCode", SqlDbType.VarChar,50, Weight.Txt.CarCode), db.MakeInParam("@Item", SqlDbType.VarChar,50, Weight.Txt.Item), db.MakeInParam("@Specs", SqlDbType.VarChar,50, Weight.Txt.Specs), db.MakeInParam("@Place", SqlDbType.VarChar,50, Weight.Txt.Place), db.MakeInParam("@Send", SqlDbType.VarChar,50, Weight.Txt.Send), db.MakeInParam("@Accept", SqlDbType.VarChar,50, Weight.Txt.Accept), db.MakeInParam("@Carry", SqlDbType.VarChar,50, Weight.Txt.Carry), db.MakeInParam("@Model", SqlDbType.VarChar,50, Weight.Txt.Model), db.MakeInParam("@Driver", SqlDbType.VarChar,50, Weight.Txt.Driver), db.MakeInParam("@Spare", SqlDbType.VarChar,50, Weight.Txt.Spare), db.MakeInParam("@Type", SqlDbType.VarChar,50, Weight.Txt.Type), db.MakeInParam("@Card", SqlDbType.VarChar,50, Weight.Txt.Card), db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50, Weight.Txt.Plan_Code), db.MakeInParam("@G_Table", SqlDbType.VarChar,50, Weight.StateFun.G_Table), db.MakeInParam("@T_Table", SqlDbType.VarChar,50, Weight.StateFun.T_Table), db.MakeInParam("@G_Oper", SqlDbType.VarChar,50, Weight.StateFun.G_Oper), db.MakeInParam("@T_Oper", SqlDbType.VarChar,50, Weight.StateFun.T_Oper), db.MakeInParam("@Gross", SqlDbType.Decimal, 10, Weight.Float.Gross), db.MakeInParam("@Tare", SqlDbType.Decimal, 10, Weight.Float.Tare), db.MakeInParam("@Net", SqlDbType.Decimal, 10, Weight.Float.Net), db.MakeInParam("@EndNet", SqlDbType.Decimal, 10, Weight.Float.EndNet), db.MakeInParam("@Impurity", SqlDbType.Decimal, 10, Weight.Float.Impurity), db.MakeInParam("@ImpurityRate", SqlDbType.Decimal, 10, Weight.Float.ImpurityRate), db.MakeInParam("@DeductWei", SqlDbType.Decimal, 10, Weight.Float.DeductWei), db.MakeInParam("@DeductRate", SqlDbType.Decimal, 10, Weight.Float.DeductRate), db.MakeInParam("@Cube", SqlDbType.Decimal, 10, Weight.Float.Cube), db.MakeInParam("@Cubety", SqlDbType.Decimal, 10, Weight.Float.Cubety), db.MakeInParam("@InhereWei", SqlDbType.Decimal, 10, Weight.Float.InhereWei), db.MakeInParam("@DifferWei", SqlDbType.Decimal, 10, Weight.Float.DifferWei), db.MakeInParam("@Price", SqlDbType.Decimal, 10, Weight.Float.Price), db.MakeInParam("@Money", SqlDbType.Decimal, 10, Weight.Float.Money), db.MakeInParam("@State", SqlDbType.Decimal, 10, Weight.StateFun.State), db.MakeInParam("@G_Time", SqlDbType.VarChar, 50, Weight.StateFun.G_Time), db.MakeInParam("@T_Time", SqlDbType.VarChar, 50, Weight.StateFun.T_Time), db.MakeInParam("@N_Time", SqlDbType.VarChar, 50, Weight.StateFun.N_Time), }; try { bSuc = db.TransactSql(visitor, "AddData", prams, out nEffectRows); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } if (bSuc && nEffectRows > 0) return "0101"; else return "0"; }
/// <summary> /// 用户登陆 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool UserLogin(D_User Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new UsersDAL(); bool Flag = false; SqlParameter[] prams ={ db.MakeInParam("@Uid",SqlDbType.VarChar,50,Item.Uid), db.MakeInParam("@Pwd",SqlDbType.VarChar,50,Item.Pwd) }; try { DataSet ds = new DataSet(); ds = db.ReturnDataSet(visitor, prams, "UserLogin"); DataRowCollection drc = ds.Tables[0].Rows; if (drc.Count > 0) { DataRow dr = drc[0]; CUser.Id = Convert.ToInt64(dr["Id"]); CUser.Code = dr["Code"].ToString(); CUser.Uid = dr["Uid"].ToString(); CUser.Name = dr["Name"].ToString(); CUser.Role = dr["Role"].ToString(); //PublicFun.IniFile Ini = new PublicFun.IniFile(WSV.Model.FilePath.Config); //if (Ini.ExistIniFile()) //{ // LUser.TableNum = Ini.IniReadValue("LoadoMeter", "TableNum"); //} //ds = WSV.BLL.SysInfo.LoadoMeterBLL.SelectAll(" where TableNum='" + LUser.TableNum + "'"); //drc = ds.Tables[0].Rows; //if (drc.Count > 0) //{ // dr = drc[0]; // LUser.TableName = dr["Name"].ToString(); // LUser.Ip = dr["Ip"].ToString(); // LUser.Port = dr["Port"].ToString(); //} //else //{ // LUser.TableNum = ""; //} Flag = true; } } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return Flag; }
/// <summary> /// ���� /// </summary> /// <returns></returns> public static DataSet SaverInfo(string sql) { DataBase db = new DataBase(); DataSet ds = new DataSet(); try { ds = db.ReturnDataSet(sql); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return ds; }
/// <summary> /// 查询出所有的数据 /// </summary> /// <returns>DataSet</returns> public static DataSet BindItem() { DataBase db = new DataBase(); DAL.DataBaseVisitor visitor = new DAL.Record.D_CubetyVisitor(); DataSet ds = new DataSet(); try { ds = db.ReturnDataSet(visitor, "BingdItem", "D_Base"); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return ds; }
public static DataSet GetName() { DataBase db = new DataBase(); DataSet ds = new DataSet(); string sql = "select Name,DBName from V_C_Select where Show=1"; try { ds = db.ReturnDataSet(sql); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return ds; }
/// <summary> /// �������ʱģ����ѯ /// </summary> /// <param name="s_Pr"></param> /// <param name="s_pr1"></param> /// <returns></returns> public static DataSet SelectData(string s_pr) { DataBase db = new DataBase(); string sql = "select Plan_Code,Plan_Item,Plan_Specs,Plan_Send,Plan_Accept from V_DC_Plan where Plan_Code like '%" + s_pr + "%' and Plan_Used = 0"; DataSet ds = new DataSet(); try { ds = db.ReturnDataSet(sql); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return ds; }
/// <summary> /// ��ѯȫ������ /// </summary> public static DataSet SelectAll() { DataBase db = new DataBase(); DataBaseVisitor visitor = new D_StatProjectDal(); DataSet ds = new DataSet(); try { ds = db.ReturnDataSet(visitor, "Select", "D_StatProject"); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return ds; }
/// <summary> /// 删除数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool Del(string Id) { DataBase db = new DataBase(); bool Flag = false; try { if (db.TransactSql("delete from DC_Power where id in(" + Id + ")")) { Flag = true; } } catch (Exception ex) { throw ex; } return Flag; }
/// <summary> /// 带参数的数据查询 /// </summary> /// <param name="Begin">开始时间</param> /// <param name="Over">结束时间</param> /// <param name="Name">操作方式</param> /// <returns>DataSet</returns> public static DataSet SelectByWorkWise(string Begin, string Over, string Name) { string sql2 = Sql() + " where WorkName='" + Name + "' and DT between '" + Begin + "' and '" + Over + "' order by ID desc"; DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.MyLog.Modify(); DataSet ds = new DataSet(); try { ds = db.ReturnDataSet(sql2); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return ds; }
/// <summary> /// 修改密码 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool CheckDb() { bool Flag = true; DataBase db = new DataBase(); try { Flag = db.Open(); } catch { Flag = false; } finally { db.Dispose(); } return Flag; }