/// <summary> /// 刷新用户登录信息 /// </summary> /// <param name="users"></param> /// <returns></returns> public int RefreshUsers(string cName, DateTime dActivityLastTime, string cActivityIP, DateTime dUpdateDate, string cUpdateUser) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { //@cActivityIP,@dActivityLastTime,@dUpdateDate,@cUpdateUser,@cName IDbDataParameter[] prams = { dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()), cName, 50), dbFactory.MakeInParam("@dActivityLastTime", DBTypeConverter.ConvertCsTypeToOriginDBType(dActivityLastTime.GetType().ToString()), dActivityLastTime, 0), dbFactory.MakeInParam("@cActivityIP", DBTypeConverter.ConvertCsTypeToOriginDBType(cActivityIP.GetType().ToString()), cActivityIP, 50), dbFactory.MakeInParam("@dUpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(dUpdateDate.GetType().ToString()), dUpdateDate, 0), dbFactory.MakeInParam("@cUpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(cUpdateUser.GetType().ToString()), cUpdateUser, 50) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "proc_User_Refresh", prams); } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// 用户名是否存在 /// </summary> /// <param name="cName"></param> /// <returns></returns> public bool IsExistsUsers(string cName) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()), cName, 50) }; IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_User_IsExists", prams); if (dataReader.Read()) { iReturn = 1; } } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn == 1 ? true : false); }
/// <summary> /// 删除用户-ID /// </summary> /// <param name="ID"></param> /// <returns>int</returns> public int DeleteUsers(int ID) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(ID.GetType().ToString()), ID, 0) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_User_Delete", prams); db.ExecuteNonQueryTrans(trans, CommandType.Text, "delete from t_R_UserArea where UserID='" + ID + "'", prams); thelper.CommitTransaction(trans); } catch (Exception ex) { iReturn = 0; thelper.RollTransaction(trans); Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="PassWord"> </param> /// <param name="GUID"> </param> /// <param name="PwdChgDate"> </param> /// <param name="UpdateUser"> </param> /// <param name="UpdateDate"> </param> /// <returns></returns> public static int UpdateUserPw(string PassWord, string GUID, DateTime PwdChgDate, string UpdateUser, DateTime UpdateDate) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@PassWord", DBTypeConverter.ConvertCsTypeToOriginDBType(PassWord.GetType().ToString()), PassWord, 50), dbFactory.MakeInParam("@GUID", DBTypeConverter.ConvertCsTypeToOriginDBType(GUID.GetType().ToString()), GUID, 100), dbFactory.MakeInParam("@PwdChgDate", DBTypeConverter.ConvertCsTypeToOriginDBType(PwdChgDate.GetType().ToString()), PwdChgDate, 0), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateUser.GetType().ToString()), UpdateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateDate.GetType().ToString()), UpdateDate, 0) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_User_UpdatePw", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateDriver(Entity.Driver entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ID.GetType().ToString()), entity.ID, 32), dbFactory.MakeInParam("@RealName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.RealName.GetType().ToString()), entity.RealName, 20), dbFactory.MakeInParam("@CarNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CarNumber.GetType().ToString()), entity.CarNumber, 20), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0), dbFactory.MakeInParam("@IsStop", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsStop.GetType().ToString()), entity.IsStop, 4) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Driver_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="UserName"> </param> /// <param name="GUID"> </param> /// <param name="AreaCode"> </param> /// <param name="AreaInCharge"> </param> /// <param name="RealName"> </param> /// <param name="UpdateUser"> </param> /// <param name="UpdateDate"> </param> /// <param name="IsStop"> </param> /// <returns></returns> public static int UpdateUser(string UserName, string GUID, string AreaCode, string AreaInCharge, string RealName, string UpdateUser, DateTime UpdateDate, bool IsStop) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@UserName", DBTypeConverter.ConvertCsTypeToOriginDBType(UserName.GetType().ToString()), UserName, 50), dbFactory.MakeInParam("@GUID", DBTypeConverter.ConvertCsTypeToOriginDBType(GUID.GetType().ToString()), GUID, 100), dbFactory.MakeInParam("@AreaCode", DBTypeConverter.ConvertCsTypeToOriginDBType(AreaCode.GetType().ToString()), AreaCode, 20), dbFactory.MakeInParam("@AreaInCharge", DBTypeConverter.ConvertCsTypeToOriginDBType(AreaInCharge.GetType().ToString()), AreaInCharge, 100), dbFactory.MakeInParam("@RealName", DBTypeConverter.ConvertCsTypeToOriginDBType(RealName.GetType().ToString()), RealName, 20), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateUser.GetType().ToString()), UpdateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateDate.GetType().ToString()), UpdateDate, 0), dbFactory.MakeInParam("@IsStop", DBTypeConverter.ConvertCsTypeToOriginDBType(IsStop.GetType().ToString()), IsStop, 4) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_User_Update", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="ID"> </param> /// <returns></returns> public static DataTable GetMenuEx(string GUID) { DataTable list = new DataTable(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@GUID", DBTypeConverter.ConvertCsTypeToOriginDBType(GUID.GetType().ToString()), GUID, 100) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_User_GetMenu", prams); if (dataReader.Read()) { list = dataReader.GetSchemaTable(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="UserName"> </param> /// <param name="PassWord"> </param> /// <param name="IsStop"> </param> /// <returns></returns> public static string Login(string UserName, string PassWord) { string iReturn = ""; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@UserName", DBTypeConverter.ConvertCsTypeToOriginDBType(UserName.GetType().ToString()), UserName, 50), dbFactory.MakeInParam("@PassWord", DBTypeConverter.ConvertCsTypeToOriginDBType(PassWord.GetType().ToString()), PassWord, 50) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_User_Login", prams); if (dataReader.Read()) { iReturn = dataReader["GUID"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// 停用或启用用户 /// </summary> /// <param name="ID">用户ID</param> /// <param name="BStop">是否停用</param> /// <returns></returns> public int StopUsers(int ID, bool bStop) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(ID.GetType().ToString()), ID, 0), dbFactory.MakeInParam("@bStop", DBTypeConverter.ConvertCsTypeToOriginDBType(bStop.GetType().ToString()), bStop, 1), dbFactory.MakeOutReturnParam() }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "proc_User_Stop", prams); iReturn = int.Parse(prams[2].Value.ToString()); } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
public int UpdateUserPower(string cUserName, int iMenuId, bool bLuRu, bool bCheck, bool bUp, DateTime dUpdateDate, string cUpdateUser) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@cUserName", DBTypeConverter.ConvertCsTypeToOriginDBType(cUserName.GetType().ToString()), cUserName, 50), dbFactory.MakeInParam("@iMenuId", DBTypeConverter.ConvertCsTypeToOriginDBType(iMenuId.GetType().ToString()), iMenuId, 0), dbFactory.MakeInParam("@bLuRu", DBTypeConverter.ConvertCsTypeToOriginDBType(bLuRu.GetType().ToString()), bLuRu, 1), dbFactory.MakeInParam("@bCheck", DBTypeConverter.ConvertCsTypeToOriginDBType(bCheck.GetType().ToString()), bCheck, 1), dbFactory.MakeInParam("@bUp", DBTypeConverter.ConvertCsTypeToOriginDBType(bUp.GetType().ToString()), bUp, 1), dbFactory.MakeInParam("@dUpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(dUpdateDate.GetType().ToString()), dUpdateDate, 0), dbFactory.MakeInParam("@cUpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(cUpdateUser.GetType().ToString()), cUpdateUser, 50) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "proc_UserPower_Update", prams); } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="ResultID"> </param> /// <returns></returns> public static int DeleteMonitorResult(int ResultID) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ResultID", DBTypeConverter.ConvertCsTypeToOriginDBType(ResultID.GetType().ToString()), ResultID, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_MonitorResult_Delete", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateMenu(Entity.Menu entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ID.GetType().ToString()), entity.ID, 32), dbFactory.MakeInParam("@FatherID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FatherID.GetType().ToString()), entity.FatherID, 32), dbFactory.MakeInParam("@MenuName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuName.GetType().ToString()), entity.MenuName, 50), dbFactory.MakeInParam("@ImageUrl", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ImageUrl.GetType().ToString()), entity.ImageUrl, 0), dbFactory.MakeInParam("@MenuUrl", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuUrl.GetType().ToString()), entity.MenuUrl, 50), dbFactory.MakeInParam("@MenuOrder", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuOrder.GetType().ToString()), entity.MenuOrder, 32), dbFactory.MakeInParam("@MenuFile", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuFile.GetType().ToString()), entity.MenuFile, 50) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Menu_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="MenuName"> </param> /// <param name="MenuUrl"> </param> /// <param name="MenuDescription"> </param> /// <param name="ParentID"> </param> /// <returns></returns> public static int AddMenu(string MenuName, string MenuUrl, string MenuDescription, int ParentID) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@MenuName", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuName.GetType().ToString()), MenuName, 50), dbFactory.MakeInParam("@MenuUrl", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuUrl.GetType().ToString()), MenuUrl, 0), dbFactory.MakeInParam("@MenuDescription", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuDescription.GetType().ToString()), MenuDescription, 50), dbFactory.MakeInParam("@ParentID", DBTypeConverter.ConvertCsTypeToOriginDBType(ParentID.GetType().ToString()), ParentID, 32), dbFactory.MakeOutReturnParam() }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_Menu_Add", prams); iReturn = int.Parse(prams[4].Value.ToString()); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdatePond(Entity.Pond entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PondID.GetType().ToString()), entity.PondID, 32), dbFactory.MakeInParam("@Name", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Name.GetType().ToString()), entity.Name, 20), dbFactory.MakeInParam("@Capacity", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Capacity.GetType().ToString()), entity.Capacity, 10), dbFactory.MakeInParam("@Stores", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Stores.GetType().ToString()), entity.Stores, 20), dbFactory.MakeInParam("@Number", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Number.GetType().ToString()), entity.Number, 32), //dbFactory.MakeInParam("@Remain", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Remain.GetType().ToString()),entity.Remain,10), dbFactory.MakeInParam("@IsDelete", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsDelete.GetType().ToString()), entity.IsDelete, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Pond_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="MenuID"> </param> /// <returns></returns> public static List <Entity.Menu> GetMenuByUser(int UserID) { List <Entity.Menu> list = new List <Entity.Menu>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(UserID.GetType().ToString()), UserID, 32) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_Menu_GetByUser", prams); while (dataReader.Read()) { Entity.Menu entity = new Entity.Menu(); //entity.MenuID = DataHelper.ParseToInt(dataReader["MenuID"].ToString()); entity.MenuName = dataReader["MenuName"].ToString(); entity.MenuUrl = dataReader["MenuUrl"].ToString(); //entity.MenuDescription = dataReader["MenuDescription"].ToString(); //entity.ParentID = DataHelper.ParseToInt(dataReader["ParentID"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="RoleID"> </param> /// <returns></returns> public static Entity.Role GetRole(int RoleID) { Entity.Role entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@RoleID", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleID.GetType().ToString()), RoleID, 32) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_Role_Get", prams); while (dataReader.Read()) { entity = new Entity.Role(); //entity.RoleID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); entity.RoleName = dataReader["RoleName"].ToString(); //entity.RoleDescription = dataReader["RoleDescription"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="OutID"> </param> /// <param name="Status"> </param> /// <returns></returns> public static int PassProductOut(Entity.ProductOut entity, decimal Used) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@OutID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.OutID.GetType().ToString()), entity.OutID, 32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_ProductOut_UpdateStatus", prams); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Insert into [PondUsed]([PondID],[Used],[SourceType],[TypeName],[CreateUser],[CreateDate]) values ('" + entity.PondID + "','" + Used + "','4','成品出库','" + entity.CreateUser + "','" + entity.CreateDate + "')", null); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Pond] set Used='"+ Used + "'where PondID='" + entity.PondID + "'", null); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int AddPondLog(Entity.PondLog entity, decimal U1, decimal R1, decimal U2, decimal R2) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@SourceID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.SourceID.GetType().ToString()), entity.SourceID, 32), dbFactory.MakeInParam("@ToID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ToID.GetType().ToString()), entity.ToID, 32), dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()), entity.CreateDate, 0), dbFactory.MakeInParam("@CreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateUser.GetType().ToString()), entity.CreateUser, 50), dbFactory.MakeInParam("@Amount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Amount.GetType().ToString()), entity.Amount, 10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_PondLog_Add", prams); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Pond] set Used='"+ U1 + "',Remain='" + R1 + "' where PondID='" + entity.SourceID + "'", null); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Pond] set Used='"+ U2 + "',Remain='" + R2 + "' where PondID='" + entity.ToID + "'", null); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateProductDetail(Entity.ProductDetail entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@DetailID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DetailID.GetType().ToString()), entity.DetailID, 32), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemCode.GetType().ToString()), entity.ItemCode, 20), dbFactory.MakeInParam("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PondID.GetType().ToString()), entity.PondID, 32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32), dbFactory.MakeInParam("@Amount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Amount.GetType().ToString()), entity.Amount, 10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_ProductDetail_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateAnalysisResult(Entity.AnalysisResult entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ResultID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ResultID.GetType().ToString()), entity.ResultID, 32), dbFactory.MakeInParam("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()), entity.BillNumber, 20), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemCode.GetType().ToString()), entity.ItemCode, 20), dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Result.GetType().ToString()), entity.Result, 10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_AnalysisResult_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int AddFinalWaste(Entity.FinalWaste entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@LogID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.LogID.GetType().ToString()), entity.LogID, 32), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemCode.GetType().ToString()), entity.ItemCode, 20), dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Result.GetType().ToString()), entity.Result, 10), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32), dbFactory.MakeOutReturnParam() }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_FinalWaste_Add", prams); iReturn = int.Parse(prams[4].Value.ToString()); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="ID"></param> /// <returns>Users</returns> public DataTable GetUsersDt(String cName) { DataTable dt = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()), cName, 50) }; string str = ""; if (cName != "") { str = " and Name='" + cName + "'"; } IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, "select UserID,Name from t_R_UserInfo where 1=1" + str, prams); dt = new DataTable(); dt.Load(dataReader); } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(dt); }
public int DeleteUserPower(int iMenuId, string cUserName) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@iMenuId", DBTypeConverter.ConvertCsTypeToOriginDBType(iMenuId.GetType().ToString()), iMenuId, 0), dbFactory.MakeInParam("@cUserName", DBTypeConverter.ConvertCsTypeToOriginDBType(cUserName.GetType().ToString()), cUserName, 50) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "proc_UserPower_Delete", prams); } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="RoleID"> </param> /// <param name="RoleName"> </param> /// <param name="RoleDescription"> </param> /// <returns></returns> public static int UpdateRole(int RoleID, string RoleName, string RoleDescription) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@RoleID", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleID.GetType().ToString()), RoleID, 32), dbFactory.MakeInParam("@RoleName", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleName.GetType().ToString()), RoleName, 50), dbFactory.MakeInParam("@RoleDescription", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleDescription.GetType().ToString()), RoleDescription, 100) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_Role_Update", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateFinalWasteLog(Entity.FinalWasteLog entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@LogID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.LogID.GetType().ToString()), entity.LogID, 32), dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0), dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UserID.GetType().ToString()), entity.UserID, 32), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_FinalWasteLog_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int AddWaste(Entity.Waste entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@WasteCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.WasteCode.GetType().ToString()), entity.WasteCode, 20), dbFactory.MakeInParam("@WasteName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.WasteName.GetType().ToString()), entity.WasteName, 50), dbFactory.MakeInParam("@List", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.List.GetType().ToString()), entity.List, 50), dbFactory.MakeInParam("@Type", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Type.GetType().ToString()), entity.Type, 32), dbFactory.MakeInParam("@Unit", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Unit.GetType().ToString()), entity.Unit, 20), dbFactory.MakeInParam("@OrderID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.OrderID.GetType().ToString()), entity.OrderID, 32), dbFactory.MakeInParam("@IsShow", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsShow.GetType().ToString()), entity.IsShow, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Waste_Add", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateArea(Entity.Area entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ID.GetType().ToString()), entity.ID, 32), dbFactory.MakeInParam("@AreaCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AreaCode.GetType().ToString()), entity.AreaCode, 32), dbFactory.MakeInParam("@FullName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FullName.GetType().ToString()), entity.FullName, 20), dbFactory.MakeInParam("@LetterCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.LetterCode.GetType().ToString()), entity.LetterCode, 10), dbFactory.MakeInParam("@ShortName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ShortName.GetType().ToString()), entity.ShortName, 20), dbFactory.MakeInParam("@IsDelete", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsDelete.GetType().ToString()), entity.IsDelete, 32), dbFactory.MakeInParam("@OrderID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.OrderID.GetType().ToString()), entity.OrderID, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Area_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="OutID"> </param> /// <param name="Status"> </param> /// <returns></returns> public static int UpdateProductOutStatus(int OutID, int Status) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@OutID", DBTypeConverter.ConvertCsTypeToOriginDBType(OutID.GetType().ToString()), OutID, 32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(Status.GetType().ToString()), Status, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_ProductOut_UpdateStatus", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="ID"></param> /// <returns>Users</returns> public Entity.User.Users GetUsers(String cName) { Entity.User.Users entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()), cName, 50) }; IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, "select UserID from t_R_UserInfo where Name='" + cName + "'", prams); while (dataReader.Read()) { entity = new Entity.User.Users(); entity.UserID = dataReader["UserID"].ToString(); break; } } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(entity); }
public static int AddWasteToProductEntity(Entity.WasteToProduct entity, List <Entity.ProductDetail> products) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@FromPondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FromPondID.GetType().ToString()), entity.FromPondID, 32), dbFactory.MakeInParam("@FromWasteCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FromWasteCode.GetType().ToString()), entity.FromWasteCode, 20), dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0), dbFactory.MakeInParam("@FromAmount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FromAmount.GetType().ToString()), entity.FromAmount, 10), dbFactory.MakeInParam("@HanderManID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.HanderManID.GetType().ToString()), entity.HanderManID, 32), dbFactory.MakeInParam("@ReceiverID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ReceiverID.GetType().ToString()), entity.ReceiverID, 32), dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()), entity.CreateDate, 0), dbFactory.MakeInParam("@CreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateUser.GetType().ToString()), entity.CreateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32), dbFactory.MakeOutReturnParam() }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_WasteToProduct_Add", prams); iReturn = int.Parse(prams[11].Value.ToString()); int DealID = int.Parse(prams[11].Value.ToString()); foreach (Entity.ProductDetail product in products) { IDbDataParameter[] pramse = { dbFactory.MakeInParam("@WTPID", DBTypeConverter.ConvertCsTypeToOriginDBType(DealID.GetType().ToString()), DealID, 32), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(product.ItemCode.GetType().ToString()), product.ItemCode, 20), dbFactory.MakeInParam("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(product.PondID.GetType().ToString()), product.PondID, 32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32), dbFactory.MakeInParam("@Amount", DBTypeConverter.ConvertCsTypeToOriginDBType(product.Amount.GetType().ToString()), product.Amount, 10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_ProductDetail_Add", pramse); } //foreach (Entity.FinalWaste waste in wastes) //{ // iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Insert into [FinalWaste]([DealID],[ItemCode],[Result],[Status]) values ('" + DealID + "','" + waste.ItemCode + "','" + waste.Result + "','" + entity.Status + "')", null); //} thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }