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="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; }
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"; }
/// <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>"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 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 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; }
/// <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">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 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="bakUpName"></param> public static bool BackUp(string bakUpName) { bool Flag = true; DataBase db = new DataBase(); try { db.TransactSql("BACKUP DATABASE WSV TO DISK ='" + bakUpName + "'"); } catch (Exception ex) { Flag = false; throw ex; } finally { db.Dispose(); } return Flag; }
/// <summary> /// 添加数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static string AddData(Model.Plan.D_Plan Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Plan.PlanVisitor(); bool bSuc = false; int nEffectRows = 0; long id = BLL.PublicFun.PublicFun.MaxId("D_Plan"); SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.BigInt,12, BLL.PublicFun.PublicFun.MaxId("D_Plan")), db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50, Item.Plan_Code), db.MakeInParam("@Plan_CountWay", SqlDbType.VarChar,50, Item.Plan_CountWay), db.MakeInParam("@Plan_Item", SqlDbType.VarChar,50, Item.Plan_Item), db.MakeInParam("@Plan_Specs", SqlDbType.VarChar,50, Item.Plan_Specs), db.MakeInParam("@Plan_Type", SqlDbType.VarChar,50, Item.Plan_Type), db.MakeInParam("@Plan_Send", SqlDbType.VarChar,50, Item.Plan_Send), db.MakeInParam("@Plan_Accept", SqlDbType.VarChar,50, Item.Plan_Accept), db.MakeInParam("@Plan_Num", SqlDbType.Decimal,50, Item.Plan_Num), db.MakeInParam("@Plan_SpareNum", SqlDbType.Decimal,50, Item.Plan_SpareNum), db.MakeInParam("@Plan_Money", SqlDbType.Decimal,50, Item.Plan_Money), db.MakeInParam("@Plan_SpareMoney", SqlDbType.Decimal,50, Item.Plan_SpareMoney), db.MakeInParam("@Remark", SqlDbType.VarChar,50, Item.Remark), db.MakeInParam("@Begin_Time", SqlDbType.VarChar,50, Item.Begin_Time), db.MakeInParam("@End_Time", SqlDbType.VarChar,50, Item.End_Time), }; 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="Code">�������</param> /// <returns></returns> public static string Delete(string ProCode) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Count.D_StatProjectDal(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@Code", SqlDbType.VarChar,50, ProCode), }; try { bSuc = db.TransactSql(visitor, "Delete", 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="ID">D_Saver��ID</param> /// <returns>"0101"��ʾ�ɹ���"0"��ʾʧ��</returns> public static string Delete(long ID) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Search.SearchDal(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.BigInt,8,ID), }; try { bSuc = db.TransactSql(visitor, "Delete", 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>"0101"表示成功,"0"表示失败</returns> public static string Update(Model.Record.D_TypeModel Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Record.D_TypeVisitor(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), db.MakeInParam("@ID", SqlDbType.BigInt,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"; }
/// <summary> /// ���濨�� /// </summary> /// <param name="values"></param> public static void Save_Card(WeightModel values) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.Weight.CardDAL(); SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_Card")), db.MakeInParam("@Card",SqlDbType.VarChar,50,values.Txt.Card), db.MakeInParam("@CarCode",SqlDbType.VarChar,50,values.Txt.CarCode), db.MakeInParam("@Type",SqlDbType.VarChar,50,values.Txt.Type), db.MakeInParam("@Item",SqlDbType.VarChar,50,values.Txt.Item), db.MakeInParam("@Specs",SqlDbType.VarChar,50,values.Txt.Specs), db.MakeInParam("@Place",SqlDbType.VarChar,50,values.Txt.Place), db.MakeInParam("@Send",SqlDbType.VarChar,50,values.Txt.Send), db.MakeInParam("@Accept",SqlDbType.VarChar,50,values.Txt.Accept), db.MakeInParam("@Carry",SqlDbType.VarChar,50,values.Txt.Carry), db.MakeInParam("@Model",SqlDbType.VarChar,50,values.Txt.Model), db.MakeInParam("@Driver",SqlDbType.VarChar,50,values.Txt.Driver), db.MakeInParam("@Spare",SqlDbType.VarChar,50,values.Txt.Spare), db.MakeInParam("@Tare",SqlDbType.Float,50,values.Float.Tare), db.MakeInParam("@State",SqlDbType.Bit,1,values.StateFun.State) }; try { db.TransactSql(visitor, "Save_Card", prams); } catch (Exception err) { db.Dispose(); MessageBox.Show("���ݲ�ȫ��", "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { db.Dispose(); } }
/// <summary> /// ������ /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static string Update(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("@Type", SqlDbType.VarChar,50, Item.Type), db.MakeInParam("@SataType", SqlDbType.VarChar,50, Item.SataType), db.MakeInParam("@Flag", SqlDbType.VarChar,50, Item.Flag), db.MakeInParam("@Month", SqlDbType.VarChar,50, Item.Month), db.MakeInParam("@Day", SqlDbType.VarChar,50, Item.Day), db.MakeInParam("@BeginTime", SqlDbType.VarChar,50, Item.BeginTime), db.MakeInParam("@EndTime", SqlDbType.VarChar,50, Item.EndTime), db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code), }; 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"; }
/// <summary> /// ��������Ϣ /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static string Update(Model.Search.C_SelectModel Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Search.SearchDal(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@As", SqlDbType.VarChar,50, Item.As), db.MakeInParam("@Show", SqlDbType.Bit,4, Item.Show), db.MakeInParam("@Place", SqlDbType.BigInt,8, Item.Place), db.MakeInParam("@ID", SqlDbType.BigInt,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"; }
/// <summary> /// 修改数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool Update(D_User Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new UsersDAL(); bool Flag= false,ReFlag=false; int N= 0; SqlParameter[] prams ={ db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code), db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), db.MakeInParam("@Uid", SqlDbType.VarChar,50, Item.Uid), db.MakeInParam("@Pwd", SqlDbType.VarChar,50, Item.Pwd), db.MakeInParam("@Role", SqlDbType.VarChar,50, Item.Role), db.MakeInParam("@Used", SqlDbType.Bit,0, Item.Used), 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="ID">表ID</param> /// <param name="Used">是否作废</param> /// <returns>"0101"表示成功,"0"表示失败</returns> public static string Update_Used(long ID, bool Used) { DataBase db = new DataBase(); DataBaseVisitor visitor = new D_BaseVisitor(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@Used", SqlDbType.Bit,8, Used), db.MakeInParam("@ID", SqlDbType.BigInt,50,ID), }; try { bSuc = db.TransactSql(visitor, "Update_Used", 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="Code">编号</param> /// <returns></returns> public static string UpdateCheck(string Code) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@Code", SqlDbType.VarChar,50, Code), }; try { bSuc = db.TransactSql(visitor, "OnCheck", 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="RoleCode">角色编号</param> /// <param name="PowerCode">权限编号</param> /// <returns></returns> private static bool AddRolePower(string RoleCode,string RolePower) { DataBase db = new DataBase(); DataBaseVisitor visitor = new RoleDAL(); bool Flag = true; int N = 0; try { SqlParameter[] prams; prams =new SqlParameter[]{ db.MakeInParam("@RoleCode", SqlDbType.VarChar,50,RoleCode), }; db.TransactSql(visitor, "DelRolePower", prams); string[] PowerList =RolePower.Split(','); for (int i = 0; i < PowerList.Length; i++) { db = new DataBase(); prams =new SqlParameter[]{ db.MakeInParam("@RoleCode", SqlDbType.VarChar,50,RoleCode), db.MakeInParam("@PowerCode", SqlDbType.VarChar,50,PowerList[i]) }; db.TransactSql(visitor, "AddRolePower", prams); } } catch (Exception ex) { Flag = false; throw ex; } finally { db.Dispose(); } return Flag; }
public static void upSpare(string Type, string Plan_Code, decimal Spare) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.Weight.PlanDAL(); SqlParameter[] prams = new SqlParameter[2]; if (Type == "01") { prams[0] = db.MakeInParam("@Plan_Code", SqlDbType.VarChar, 50, Plan_Code); prams[1] = db.MakeInParam("@Plan_SpareNum", SqlDbType.Decimal, 50, Spare); try { db.TransactSql(visitor, "Plan_SpareNum", prams); } catch (Exception e) { db.Dispose(); return; } } if (Type == "02") { prams[0] = db.MakeInParam("@Plan_Code", SqlDbType.VarChar, 50, Plan_Code); prams[1] = db.MakeInParam("@Plan_SpareMoney", SqlDbType.Decimal, 50, Spare); try { db.TransactSql(visitor, "Plan_SpareMoney", prams); } catch (Exception e) { db.Dispose(); return; } } }
/// <summary> /// �����¼����� /// </summary> /// <param name="Sql"></param> /// <param name="values"></param> public static void Save_Data(string Sql, WeightModel values) { //�����¼� DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL(); if (Sql == "yucun") { SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_Saver")), db.MakeInParam("@Code", SqlDbType.VarChar,50, values.Code), db.MakeInParam("@Card",SqlDbType.VarChar,50,values.Txt.Card), db.MakeInParam("@CarCode", SqlDbType.VarChar,50, values.Txt.CarCode), db.MakeInParam("@Type", SqlDbType.VarChar,50, values.Txt.Type), db.MakeInParam("@Item", SqlDbType.VarChar,50, values.Txt.Item), db.MakeInParam("@Specs", SqlDbType.VarChar,50, values.Txt.Specs), db.MakeInParam("@Place", SqlDbType.VarChar,50, values.Txt.Place), db.MakeInParam("@Send", SqlDbType.VarChar,50, values.Txt.Send), db.MakeInParam("@Accept", SqlDbType.VarChar,50, values.Txt.Accept), db.MakeInParam("@Carry", SqlDbType.VarChar,50, values.Txt.Carry), db.MakeInParam("@Model", SqlDbType.VarChar,50,values.Txt.Model), db.MakeInParam("@Cube", SqlDbType.Decimal,50, values.Float.Cube), db.MakeInParam("@Cubety", SqlDbType.Decimal,50, values.Float.Cubety), db.MakeInParam("@InhereWei", SqlDbType.Decimal,50, values.Float.InhereWei), db.MakeInParam("@DifferWei", SqlDbType.Decimal,50, values.Float.DifferWei), db.MakeInParam("@Driver", SqlDbType.VarChar,50, values.Txt.Driver), db.MakeInParam("@Spare", SqlDbType.VarChar,50, values.Txt.Spare), db.MakeInParam("@Gross", SqlDbType.Decimal,50, values.Float.Gross), db.MakeInParam("@G_Time",SqlDbType.VarChar,50,values.StateFun.G_Time), db.MakeInParam("@Tare", SqlDbType.Decimal,50, values.Float.Tare), db.MakeInParam("@T_Time",SqlDbType.VarChar,50,values.StateFun.T_Time), db.MakeInParam("@Net",SqlDbType.Decimal,50,values.Float.Net), db.MakeInParam("@EndNet",SqlDbType.Decimal,50,values.Float.EndNet), db.MakeInParam("@N_Time",SqlDbType.VarChar,50,values.StateFun.N_Time), db.MakeInParam("@Price",SqlDbType.Decimal,50,values.Float.Price), db.MakeInParam("@Money",SqlDbType.Decimal,50,values.Float.Money), db.MakeInParam("@DeductWei",SqlDbType.Decimal,50,values.Float.DeductWei), db.MakeInParam("@DeductRate",SqlDbType.Decimal,50,values.Float.DeductRate), db.MakeInParam("@Impurity",SqlDbType.Decimal,50,values.Float.Impurity), db.MakeInParam("@ImpurityRate",SqlDbType.Decimal,50,values.Float.ImpurityRate), db.MakeInParam("@G_Oper",SqlDbType.VarChar,50,WSV.Model.User.LUser.Code), db.MakeInParam("@Accepter",SqlDbType.VarChar,50,WSV.Model.User.CUser.Code), db.MakeInParam("@State",SqlDbType.Bit,1,1), db.MakeInParam("@Plan_Code",SqlDbType.VarChar,50,values.Txt.Plan_Code) }; try { db.TransactSql(visitor, Sql, prams); } catch (Exception err) { db.Dispose(); MessageBox.Show("���ݲ�ȫ��", "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { db.Dispose(); } } else if (Sql == "IdCard") { SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_Saver")), db.MakeInParam("@Code", SqlDbType.VarChar,50, values.Code), db.MakeInParam("@Card",SqlDbType.VarChar,50,values.Txt.Card), db.MakeInParam("@CarCode", SqlDbType.VarChar,50, values.Txt.CarCode), db.MakeInParam("@Type", SqlDbType.VarChar,50, values.Txt.Type), db.MakeInParam("@Item", SqlDbType.VarChar,50, values.Txt.Item), db.MakeInParam("@Specs", SqlDbType.VarChar,50, values.Txt.Specs), db.MakeInParam("@Place", SqlDbType.VarChar,50, values.Txt.Place), db.MakeInParam("@Send", SqlDbType.VarChar,50, values.Txt.Send), db.MakeInParam("@Accept", SqlDbType.VarChar,50, values.Txt.Accept), db.MakeInParam("@Carry", SqlDbType.VarChar,50, values.Txt.Carry), db.MakeInParam("@Model", SqlDbType.VarChar,50,values.Txt.Model), db.MakeInParam("@Cube", SqlDbType.Decimal,50, values.Float.Cube), db.MakeInParam("@Cubety", SqlDbType.Decimal,50, values.Float.Cubety), db.MakeInParam("@InhereWei", SqlDbType.Decimal,50, values.Float.InhereWei), db.MakeInParam("@DifferWei", SqlDbType.Decimal,50, values.Float.DifferWei), db.MakeInParam("@Driver", SqlDbType.VarChar,50, values.Txt.Driver), db.MakeInParam("@Spare", SqlDbType.VarChar,50, values.Txt.Spare), db.MakeInParam("@Gross", SqlDbType.Decimal,50, values.Float.Gross), db.MakeInParam("@G_Time",SqlDbType.VarChar,50,values.StateFun.G_Time), db.MakeInParam("@Tare", SqlDbType.Decimal,50, values.Float.Tare), db.MakeInParam("@T_Time",SqlDbType.VarChar,50,values.StateFun.T_Time), db.MakeInParam("@Net",SqlDbType.Decimal,50,values.Float.Net), db.MakeInParam("@EndNet",SqlDbType.Decimal,50,values.Float.EndNet), db.MakeInParam("@N_Time",SqlDbType.VarChar,50,values.StateFun.N_Time), db.MakeInParam("@Price",SqlDbType.Decimal,50,values.Float.Price), db.MakeInParam("@Money",SqlDbType.Decimal,50,values.Float.Money), db.MakeInParam("@DeductWei",SqlDbType.Decimal,50,values.Float.DeductWei), db.MakeInParam("@DeductRate",SqlDbType.Decimal,50,values.Float.DeductRate), db.MakeInParam("@Impurity",SqlDbType.Decimal,50,values.Float.Impurity), db.MakeInParam("@ImpurityRate",SqlDbType.Decimal,50,values.Float.ImpurityRate), db.MakeInParam("@G_Oper",SqlDbType.VarChar,50,WSV.Model.User.LUser.Code), db.MakeInParam("@Accepter",SqlDbType.VarChar,50,WSV.Model.User.CUser.Code), db.MakeInParam("@State",SqlDbType.Bit,1,1), db.MakeInParam("@Plan_Code",SqlDbType.VarChar,50,values.Txt.Plan_Code) }; try { db.TransactSql(visitor, Sql, prams); } catch (Exception err) { db.Dispose(); MessageBox.Show("���ݲ�ȫ��", "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { db.Dispose(); } } }
/// <summary> /// ����ͼƬ /// </summary> /// <param name="Sql"></param> /// <param name="retselectflag"></param> /// <param name="Values"></param> public static void Save_Video(string Sql, bool retselectflag, WeightModel Values) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL(); SqlParameter[] prams = new SqlParameter[5]; if (!retselectflag) { if (Sql == "insertM") { prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, Values.Code); if (Values.StateFun.G_Image1 != null) prams[1] = db.MakeInParam("@G_Image1", SqlDbType.Binary, Values.StateFun.G_Image1.Length, Values.StateFun.G_Image1); else prams[1] = db.MakeInParam("@G_Image1", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.G_Image2 != null) prams[2] = db.MakeInParam("@G_Image2", SqlDbType.Binary, Values.StateFun.G_Image2.Length, Values.StateFun.G_Image2); else prams[2] = db.MakeInParam("@G_Image2", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.G_Image3 != null) prams[3] = db.MakeInParam("@G_Image3", SqlDbType.Binary, Values.StateFun.G_Image3.Length, Values.StateFun.G_Image3); else prams[3] = db.MakeInParam("@G_Image3", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.G_Image4 != null) prams[4] = db.MakeInParam("@G_Image4", SqlDbType.Binary, Values.StateFun.G_Image4.Length, Values.StateFun.G_Image4); else prams[4] = db.MakeInParam("@G_Image4", SqlDbType.Binary, 0, DBNull.Value); } else if (Sql == "insertP") { prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, Values.Code); if (Values.StateFun.T_Image1 != null) prams[1] = db.MakeInParam("@T_Image1", SqlDbType.Binary, Values.StateFun.T_Image1.Length, Values.StateFun.T_Image1); else prams[1] = db.MakeInParam("@T_Image1", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.T_Image2 != null) prams[2] = db.MakeInParam("@T_Image2", SqlDbType.Binary, Values.StateFun.T_Image2.Length, Values.StateFun.T_Image2); else prams[2] = db.MakeInParam("@T_Image2", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.T_Image3 != null) prams[3] = db.MakeInParam("@T_Image3", SqlDbType.Binary, Values.StateFun.T_Image3.Length, Values.StateFun.T_Image3); else prams[3] = db.MakeInParam("@T_Image3", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.T_Image4 != null) prams[4] = db.MakeInParam("@T_Image4", SqlDbType.Binary, Values.StateFun.T_Image4.Length, Values.StateFun.T_Image4); else prams[4] = db.MakeInParam("@T_Image4", SqlDbType.Binary, 0, DBNull.Value); } } else { if (Sql == "updateM") { prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, Values.Code); if (Values.StateFun.G_Image1 != null) prams[1] = db.MakeInParam("@G_Image1", SqlDbType.Binary, Values.StateFun.G_Image1.Length, Values.StateFun.G_Image1); else prams[1] = db.MakeInParam("@G_Image1", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.G_Image2 != null) prams[2] = db.MakeInParam("@G_Image2", SqlDbType.Binary, Values.StateFun.G_Image2.Length, Values.StateFun.G_Image2); else prams[2] = db.MakeInParam("@G_Image2", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.G_Image3 != null) prams[3] = db.MakeInParam("@G_Image3", SqlDbType.Binary, Values.StateFun.G_Image3.Length, Values.StateFun.G_Image3); else prams[3] = db.MakeInParam("@G_Image3", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.G_Image4 != null) prams[4] = db.MakeInParam("@G_Image4", SqlDbType.Binary, Values.StateFun.G_Image4.Length, Values.StateFun.G_Image4); else prams[4] = db.MakeInParam("@G_Image4", SqlDbType.Binary, 0, DBNull.Value); } else if (Sql == "updateP") { prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, Values.Code); if (Values.StateFun.T_Image1 != null) prams[1] = db.MakeInParam("@T_Image1", SqlDbType.Binary, Values.StateFun.T_Image1.Length, Values.StateFun.T_Image1); else prams[1] = db.MakeInParam("@T_Image1", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.T_Image2 != null) prams[2] = db.MakeInParam("@T_Image2", SqlDbType.Binary, Values.StateFun.T_Image2.Length, Values.StateFun.T_Image2); else prams[2] = db.MakeInParam("@T_Image2", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.T_Image3 != null) prams[3] = db.MakeInParam("@T_Image3", SqlDbType.Binary, Values.StateFun.T_Image3.Length, Values.StateFun.T_Image3); else prams[3] = db.MakeInParam("@T_Image3", SqlDbType.Binary, 0, DBNull.Value); if (Values.StateFun.T_Image4 != null) prams[4] = db.MakeInParam("@T_Image4", SqlDbType.Binary, Values.StateFun.T_Image4.Length, Values.StateFun.T_Image4); else prams[4] = db.MakeInParam("@T_Image4", SqlDbType.Binary, 0, DBNull.Value); } } try { db.TransactSql(visitor, Sql, prams); } catch (Exception err) { db.Dispose(); MessageBox.Show("����" + err.Message, "������Ϣ", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { db.Dispose(); } }
/// <summary> /// 是否作废数据 /// </summary> /// <param name="ID">表ID</param> /// <param name="Used">是否作废</param> /// <returns>"0101"表示成功,"0"表示失败</returns> public static string Update_Used(string Code, int Used) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Plan.PlanVisitor(); bool bSuc = false; int nEffectRows = 0; SqlParameter[] prams ={ db.MakeInParam("@Plan_Used", SqlDbType.Bit,8, Used), db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50,Code), }; try { bSuc = db.TransactSql(visitor, "Used", 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="CurveFlag"></param> /// <param name="CurveCode"></param> /// <param name="values"></param> public static void Save_Curve(string CurveFlag, string CurveCode, WeightModel values) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL(); SqlParameter[] prams = new SqlParameter[2]; prams[0] = db.MakeInParam("@Code", SqlDbType.VarChar, 50, CurveCode); if (values.StateFun.Curve != null) prams[1] = db.MakeInParam("@Curve", SqlDbType.Binary, values.StateFun.Curve.Length, values.StateFun.Curve); else prams[1] = db.MakeInParam("@Curve", SqlDbType.Binary, 0, DBNull.Value); try { db.TransactSql(visitor, CurveFlag, prams); } catch (Exception err) { db.Dispose(); MessageBox.Show("����" + err.Message, "������Ϣ", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { db.Dispose(); } }
public static void SaveCard(string sql, WeightModel values) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL(); if (sql == "one") { SqlParameter[] prams ={ db.MakeInParam("@ID", SqlDbType.BigInt,50, PublicFun.PublicFun.MaxId("D_Saver")), db.MakeInParam("@Code", SqlDbType.VarChar,50, values.Code), db.MakeInParam("@Card",SqlDbType.VarChar,50,values.Txt.Card), db.MakeInParam("@CarCode", SqlDbType.VarChar,50, values.Txt.CarCode), db.MakeInParam("@Type", SqlDbType.VarChar,50, values.Txt.Type), db.MakeInParam("@Item", SqlDbType.VarChar,50, values.Txt.Item), db.MakeInParam("@Specs", SqlDbType.VarChar,50, values.Txt.Specs), db.MakeInParam("@Place", SqlDbType.VarChar,50, values.Txt.Place), db.MakeInParam("@Send", SqlDbType.VarChar,50, values.Txt.Send), db.MakeInParam("@Accept", SqlDbType.VarChar,50, values.Txt.Accept), db.MakeInParam("@Carry", SqlDbType.VarChar,50, values.Txt.Carry), db.MakeInParam("@Model", SqlDbType.VarChar,50,values.Txt.Model), db.MakeInParam("@Driver", SqlDbType.VarChar,50, values.Txt.Driver), db.MakeInParam("@Spare", SqlDbType.VarChar,50, values.Txt.Spare), db.MakeInParam("@Gross", SqlDbType.Decimal,50, values.Float.Gross), db.MakeInParam("@G_Time",SqlDbType.VarChar,50,values.StateFun.G_Time), db.MakeInParam("@G_Oper",SqlDbType.VarChar,50,WSV.Model.User.LUser.Code), }; try { db.TransactSql(visitor, sql, prams); } catch (Exception er) { MessageBox.Show(er.Message, "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (sql == "two") { SqlParameter[] prams ={ db.MakeInParam("@Code", SqlDbType.VarChar,50, values.Code), db.MakeInParam("@CarCode", SqlDbType.VarChar,50, values.Txt.CarCode), db.MakeInParam("@Type", SqlDbType.VarChar,50, values.Txt.Type), db.MakeInParam("@Item", SqlDbType.VarChar,50, values.Txt.Item), db.MakeInParam("@Specs", SqlDbType.VarChar,50, values.Txt.Specs), db.MakeInParam("@Place", SqlDbType.VarChar,50, values.Txt.Place), db.MakeInParam("@Send", SqlDbType.VarChar,50, values.Txt.Send), db.MakeInParam("@Accept", SqlDbType.VarChar,50, values.Txt.Accept), db.MakeInParam("@Carry", SqlDbType.VarChar,50, values.Txt.Carry), db.MakeInParam("@Gross", SqlDbType.Decimal,50, values.Float.Gross), db.MakeInParam("@G_Time",SqlDbType.VarChar,50,values.StateFun.G_Time), db.MakeInParam("@Tare", SqlDbType.Decimal,50, values.Float.Tare), db.MakeInParam("@T_Time",SqlDbType.VarChar,50,values.StateFun.T_Time), db.MakeInParam("@Net",SqlDbType.Decimal,50,values.Float.Net), db.MakeInParam("@N_Time",SqlDbType.VarChar,50,values.StateFun.N_Time), //db.MakeInParam("@G_Oper",SqlDbType.VarChar,50,values.StateFun.G_Oper), db.MakeInParam("@T_Oper",SqlDbType.VarChar,50,values.StateFun.T_Oper), db.MakeInParam("@State",SqlDbType.Bit,1,1) }; try { db.TransactSql(visitor, sql, prams); } catch (Exception er) { MessageBox.Show(er.Message, "��Ϣ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
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="Item">model</param> /// <returns></returns> public static bool Update(DC_LoadoMeter Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new LoadoMeterDAL(); bool Flag = false, ReFlag = false; int N = 0; SqlParameter[] prams ={ db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), db.MakeInParam("@Ip", SqlDbType.VarChar,50, Item.Ip), db.MakeInParam("@Port", SqlDbType.VarChar,50, Item.Port), db.MakeInParam("@Remark", SqlDbType.VarChar,255, Item.Remark), db.MakeInParam("@Id", SqlDbType.Int,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; }