/// <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 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="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; }
/// <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>"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"; }
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 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; }
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> /// <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="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; }
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 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"; }
/// <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> public static void DataShow(ref Model.Video.D_Video Item) { SqlDataReader dr = null; DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Video.VideoVisitor(); SqlParameter[] prams ={ db.MakeInParam("@VIDEO_name", SqlDbType.VarChar, 50, Item.VIDEO_name), db.MakeInParam("@table", SqlDbType.VarChar, 50, Item.VIDEO_table), }; try { db.GetDataReader(visitor, prams, out dr, "Select_D_Video"); if (dr.Read()) { Item.VIDEO_Standard = int.Parse(dr["VIDEO_Standard"].ToString()); Item.VIDEO_Brightness = int.Parse(dr["VIDEO_Brightness"].ToString()); Item.VIDEO_Contrast = int.Parse(dr["VIDEO_Contrast"].ToString()); Item.VIDEO_Hue = int.Parse(dr["VIDEO_Hue"].ToString()); Item.VIDEO_Saturation = int.Parse(dr["VIDEO_Saturation"].ToString()); Item.VIDEO_Suality = int.Parse(dr["VIDEO_Suality"].ToString()); } else { Item.VIDEO_Standard = 2; Item.VIDEO_Brightness = 80; Item.VIDEO_Contrast = 44; Item.VIDEO_Hue = 0; Item.VIDEO_Saturation = 40; Item.VIDEO_Suality = 0; } } catch (Exception ex) { throw new Exception(ex.Message); } finally { dr.Close(); db.Dispose(); } }
/// <summary> /// ��ѯëƤͼƬ /// </summary> /// <param name="Item"></param> /// <param name="Code"></param> public static void DataShowImage(ref Model.Weight.StateModel Item, string Code) { SqlDataReader dr = null; DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.Weight.WeightDAL(); SqlParameter[] prams ={ db.MakeInParam("@Code",SqlDbType.VarChar,50,Code) }; try { db.GetDataReader(visitor, prams, out dr, "SelectCode"); if (dr.Read()) { if (dr["G_Image1"] != System.DBNull.Value) Item.G_Image1 = (byte[])dr["G_Image1"]; if (dr["G_Image2"] != System.DBNull.Value) Item.G_Image2 = (byte[])dr["G_Image2"]; if (dr["G_Image3"] != System.DBNull.Value) Item.G_Image3 = (byte[])dr["G_Image3"]; if (dr["G_Image4"] != System.DBNull.Value) Item.G_Image4 = (byte[])dr["G_Image4"]; if (dr["T_Image1"] != System.DBNull.Value) Item.T_Image1 = (byte[])dr["T_Image1"]; if (dr["T_Image2"] != System.DBNull.Value) Item.T_Image2 = (byte[])dr["T_Image2"]; if (dr["T_Image3"] != System.DBNull.Value) Item.T_Image3 = (byte[])dr["T_Image3"]; if (dr["T_Image4"] != System.DBNull.Value) Item.T_Image4 = (byte[])dr["T_Image4"]; if (dr["G_Curve"] != System.DBNull.Value) Item.G_Curve = (byte[])dr["G_Curve"]; if (dr["T_Curve"] != System.DBNull.Value) Item.T_Curve = (byte[])dr["T_Curve"]; } } catch (Exception ex) { throw new Exception(ex.Message); } finally { dr.Close(); db.Dispose(); } }
/// <summary> /// ��ѯ������Ӧ�Ļ�����Ŀ /// </summary> /// <returns></returns> public static DataSet SelectCode(string Code) { DataBase db = new DataBase(); DataBaseVisitor visitor = new CountDal(); DataSet ds = new DataSet(); SqlParameter[] prams ={ db.MakeInParam("@Code", SqlDbType.VarChar,50, Code), }; try { ds = db.ReturnDataSet(visitor, prams, "SelectCode"); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return ds; }
/// <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="s_Pr"></param> /// <param name="s_pr1"></param> /// <returns></returns> public static bool SelectName(string flag, WeightModel Item) { bool retvalue = true; if (flag == "") { return false; } DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Weight.PlanDAL(); SqlParameter[] prams ={ db.MakeInParam ("@flag",SqlDbType.VarChar ,50,flag ), }; SqlDataReader getReader = null; try { db.GetDataReader(visitor, prams, out getReader, "selectCode"); if (getReader.Read()) { Item.Txt.Plan_Code=getReader["Plan_Code"].ToString(); } else { retvalue = false; } getReader.Close(); } catch (Exception err) { db.Dispose(); return false; } finally { db.Dispose(); } return retvalue; }
/// <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="Weight">model</param> public static void GetDate(ref WSV.Model.Weight.WeightModel Weight) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData(); SqlDataReader oddr = null; SqlParameter[] prams ={ db.MakeInParam("@Code", SqlDbType.VarChar,50, Weight.Code), }; try { db.GetDataReader(visitor, prams, out oddr, "SelectByCode"); if (oddr.Read()) { Weight.StateFun.Verify = Convert.ToBoolean(oddr["Verify"]); Weight.StateFun.Used = Convert.ToBoolean(oddr["Used"]); Weight.Txt.CarCode = oddr["CarCode"].ToString(); Weight.Txt.Item = oddr["Item"].ToString(); Weight.Txt.Specs = oddr["Specs"].ToString(); Weight.Txt.Place = oddr["Place"].ToString(); Weight.Txt.Send = oddr["Send"].ToString(); Weight.Txt.Accept = oddr["Accept"].ToString(); Weight.Txt.Carry = oddr["Carry"].ToString(); Weight.Txt.Model = oddr["Model"].ToString(); Weight.Txt.Driver = oddr["Driver"].ToString(); Weight.Txt.Spare = oddr["Spare"].ToString(); Weight.Txt.Card = oddr["Card"].ToString(); Weight.Txt.Plan_Code = oddr["Plan_Code"].ToString(); Weight.Txt.Type = oddr["Type"].ToString(); Weight.StateFun.G_Oper = oddr["G_Oper"].ToString(); Weight.StateFun.T_Oper = oddr["T_Oper"].ToString(); Weight.StateFun.G_Table = oddr["G_Table"].ToString(); Weight.StateFun.T_Table = oddr["T_Table"].ToString(); Weight.Float.Gross = Convert.ToDecimal(oddr["Gross"]); Weight.Float.Tare = Convert.ToDecimal(oddr["Tare"]); Weight.Float.Net = Convert.ToDecimal(oddr["Net"]); Weight.Float.EndNet = Convert.ToDecimal(oddr["EndNet"]); Weight.Float.Impurity = Convert.ToDecimal(oddr["Impurity"]); Weight.Float.ImpurityRate = Convert.ToDecimal(oddr["ImpurityRate"]); Weight.Float.DeductWei = Convert.ToDecimal(oddr["DeductWei"]); Weight.Float.DeductRate = Convert.ToDecimal(oddr["DeductRate"]); Weight.Float.Cube = Convert.ToDecimal(oddr["Cube"]); Weight.Float.InhereWei = Convert.ToDecimal(oddr["InhereWei"]); Weight.Float.DifferWei = Convert.ToDecimal(oddr["DifferWei"]); Weight.Float.Price = Convert.ToDecimal(oddr["Price"]); Weight.Float.Money = Convert.ToDecimal(oddr["Money"]); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { oddr.Close(); db.Dispose(); } }
/// <summary> /// 带参数的数据查询 /// </summary> /// <param name="Begin">开始时间</param> /// <param name="Over">结束时间</param> /// <returns>DataSet</returns> public static DataSet SelectAll(string Begin, string Over) { DataBase db = new DataBase(); DataBaseVisitor visitor = new WSV.DAL.MyLog.DL_WeightVisitor(); DataSet ds = new DataSet(); SqlParameter[] prams ={ db.MakeInParam("@Begin", SqlDbType.Char,50, Begin), db.MakeInParam("@Over", SqlDbType.Char,50, Over), }; try { ds = db.ReturnDataSet(visitor, prams, "Select"); } 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 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="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> public static void SelectByName(string ProName, ref Model.Count.D_StatProjectModel Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new DAL.Count.D_StatProjectDal(); SqlDataReader dr = null; SqlParameter[] prams ={ db.MakeInParam("@Name", SqlDbType.VarChar,50, ProName), }; try { db.GetDataReader(visitor, prams, out dr, "SelectByName"); if (dr.Read()) { Item.Type = dr["Type"].ToString(); Item.SataType = dr["SataType"].ToString(); Item.Flag = dr["Flag"].ToString(); Item.Month = dr["Month"].ToString(); Item.Day = dr["Day"].ToString(); Item.BeginTime = dr["BeginTime"].ToString(); Item.EndTime = dr["EndTime"].ToString(); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } }
/// <summary> /// 修改主数据 /// </summary> /// <param name="Weight">model</param> /// <returns></returns> public static string UpdateData(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("@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.Bit, 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), db.MakeInParam("@Updata_Time", SqlDbType.VarChar, 50, Weight.StateFun.Updata_Time), db.MakeInParam("@Updata_Oper", SqlDbType.VarChar, 50, Weight.StateFun.Updata_Oper), db.MakeInParam("@Code", SqlDbType.VarChar,50, Weight.Code), }; try { bSuc = db.TransactSql(visitor, "UpdateData", 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 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 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"; }