/// <summary> /// /// </summary> /// <param name="AnalysisID"> </param> /// <returns></returns> public static Entity.Monitor GetMonitorByID(int MonitorID) { Entity.Monitor entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vMonitor] where MonitorID='" + MonitorID + "'", null); while (dataReader.Read()) { entity = new Entity.Monitor(); entity.MonitorID = DataHelper.ParseToInt(dataReader["MonitorID"].ToString()); entity.PositionName = dataReader["PositionName"].ToString(); entity.DateTime = DataHelper.ParseToDate(dataReader["DateTime"].ToString()); entity.AnalysisManID = DataHelper.ParseToInt(dataReader["AnalysisManID"].ToString()); entity.RealName = dataReader["RealName"].ToString(); entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="ResultID"> </param> /// <returns></returns> public static Entity.MonitorResult GetMonitorResultByID(int ResultID) { Entity.MonitorResult entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [MonitorResult] where ResultID='" + ResultID + "'", null); while (dataReader.Read()) { entity = new Entity.MonitorResult(); entity.ResultID = DataHelper.ParseToInt(dataReader["ResultID"].ToString()); entity.MonitorID = DataHelper.ParseToInt(dataReader["MonitorID"].ToString()); entity.ItemCode = dataReader["ItemCode"].ToString(); entity.Result = decimal.Parse(dataReader["Result"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <returns></returns> public static Entity.RoleMenu GetRoleMenu(string RoleID) { Entity.RoleMenu roleMenu = new Entity.RoleMenu(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from vRoleMenu where RoleID='" + RoleID + "'", null); while (dataReader.Read()) { roleMenu.role.RoleName = dataReader["RoleName"].ToString(); roleMenu.role.Description = dataReader["Description"].ToString(); //roleMenu.role.IsAudit = bool.Parse(dataReader["IsAudit"].ToString()); Entity.Menu entity = new Entity.Menu(); //entity.RoleID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); entity.ID = DataHelper.ParseToInt(dataReader["MenuID"].ToString()); entity.MenuName = dataReader["MenuName"].ToString(); entity.MenuUrl = dataReader["MenuUrl"].ToString(); roleMenu.menuList.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(roleMenu); }
/// <summary> /// /// </summary> /// <param name="ID"> </param> /// <returns></returns> public static List <Entity.Role> GetUserRole(string GUID) { List <Entity.Role> list = new List <Entity.Role>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from vUserRole where GUID='" + GUID + "'", null); while (dataReader.Read()) { Entity.Role entity = new Entity.Role(); entity.ID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); entity.RoleName = dataReader["RoleName"].ToString(); entity.Description = dataReader["Description"].ToString(); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="Type"> </param> /// <returns></returns> public static List <Entity.Waste> GetPartWasteEx(int Type) { List <Entity.Waste> list = new List <Entity.Waste>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [Waste] where Type='" + Type + "'", null); while (dataReader.Read()) { Entity.Waste entity = new Entity.Waste(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.WasteCode = dataReader["WasteCode"].ToString(); entity.WasteName = dataReader["WasteName"].ToString(); entity.List = dataReader["List"].ToString(); entity.Type = DataHelper.ParseToInt(dataReader["Type"].ToString()); entity.Unit = dataReader["Unit"].ToString(); entity.OrderID = DataHelper.ParseToInt(dataReader["OrderID"].ToString()); entity.IsShow = DataHelper.ParseToInt(dataReader["IsShow"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="PlanID"> </param> /// <param name="Code"> </param> /// <returns></returns> public static Entity.PlanDetail GetPlanDetail(int PlanID, string Code) { Entity.PlanDetail entity = new Entity.PlanDetail(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [PlanDetail] where PlanID='" + PlanID + "' and Code='" + Code + "'", null); while (dataReader.Read()) { entity.ItemID = DataHelper.ParseToInt(dataReader["ItemID"].ToString()); entity.PlanID = DataHelper.ParseToInt(dataReader["PlanID"].ToString()); entity.Code = dataReader["Code"].ToString(); entity.Amount = decimal.Parse(dataReader["Amount"].ToString()); entity.IsDelete = DataHelper.ParseToInt(dataReader["IsDelete"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="DealID"> </param> /// <returns></returns> public static List <Entity.FinalWaste> GetFinalWaste(int LogID) { List <Entity.FinalWaste> list = new List <Entity.FinalWaste>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [FinalWaste] where LogID='" + LogID + "'", null); while (dataReader.Read()) { Entity.FinalWaste entity = new Entity.FinalWaste(); entity.FWID = DataHelper.ParseToInt(dataReader["FWID"].ToString()); entity.LogID = DataHelper.ParseToInt(dataReader["LogID"].ToString()); entity.ItemCode = dataReader["ItemCode"].ToString(); entity.Result = decimal.Parse(dataReader["Result"].ToString()); entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="IsShow"> </param> /// <returns></returns> public static List <Entity.AnalysisItem> GetAnalysisItemList(int IsShow) { List <Entity.AnalysisItem> list = new List <Entity.AnalysisItem>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [AnalysisItem] where IsShow='" + IsShow + "'", null); while (dataReader.Read()) { Entity.AnalysisItem entity = new Entity.AnalysisItem(); entity.ItemID = DataHelper.ParseToInt(dataReader["ItemID"].ToString()); entity.ItemCode = dataReader["ItemCode"].ToString(); entity.ItemName = dataReader["ItemName"].ToString(); entity.OrderID = DataHelper.ParseToInt(dataReader["OrderID"].ToString()); entity.IsShow = DataHelper.ParseToInt(dataReader["IsShow"].ToString()); entity.Unit = dataReader["Unit"].ToString(); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
//public static DataTable QueryFinalWasteLogEx2(string StartTime, string EndTime) //{ // DataTable dt = new DataTable(); // DBOperatorBase db = new DataBase(); // IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); // try // { // StringBuilder sb = new StringBuilder(); // sb.Append("Select DateTime 日期,PondName as 罐池号,WasteName as 废物名称,FromAmount as 数量,HandleManName as 处置人,ReceiverName as 签收人 from [vFinalWasteLog] where Status=2"); // if (!string.IsNullOrEmpty(StartTime)) // { // sb.Append(" and DateTime>='" + StartTime + "'"); // } // if (!string.IsNullOrEmpty(EndTime)) // { // sb.Append(" and DateTime<='" + EndTime + "'"); // } // sb.Append(" order by DateTime desc"); // IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, sb.ToString(), null); // dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader); // } // catch (Exception ex) // { // } // finally // { // db.Conn.Close(); // } // return dt; //} /// <summary> /// /// </summary> /// <param name="DealID"> </param> /// <returns></returns> public static Entity.FinalWasteLog GetFinalWasteLog(int LogID) { Entity.FinalWasteLog entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vFinalWasteLog] where LogID='" + LogID + "'", null); while (dataReader.Read()) { entity = new Entity.FinalWasteLog(); entity.LogID = DataHelper.ParseToInt(dataReader["LogID"].ToString()); entity.LogNumber = DataHelper.ParseToInt(dataReader["LogNumber"].ToString()); entity.DateTime = DataHelper.ParseToDate(dataReader["DateTime"].ToString()); entity.IYear = DataHelper.ParseToInt(dataReader["IYear"].ToString()); entity.Number = DataHelper.ParseToInt(dataReader["Number"].ToString()); entity.UserID = DataHelper.ParseToInt(dataReader["UserID"].ToString()); entity.RealName = dataReader["RealName"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="PondID"> </param> /// <returns></returns> public static Entity.Pond GetPondByName(string Name) { Entity.Pond entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vPond] where Name='" + Name + "'", null); while (dataReader.Read()) { entity = new Entity.Pond(); entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); entity.Name = dataReader["Name"].ToString(); entity.Capacity = decimal.Parse(dataReader["Capacity"].ToString()); entity.Stores = dataReader["Stores"].ToString(); entity.Number = DataHelper.ParseToInt(dataReader["Number"].ToString()); entity.Used = decimal.Parse(dataReader["Used"].ToString()); //entity.Remain = decimal.Parse(dataReader["Remain"].ToString()); entity.IsDelete = DataHelper.ParseToInt(dataReader["IsDelete"].ToString()); entity.WasteName = dataReader["WasteName"].ToString(); entity.Status = dataReader["Status"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <returns></returns> public static List <Entity.Pond> GetAllPondEx() { List <Entity.Pond> list = new List <Entity.Pond>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vPond]", null); while (dataReader.Read()) { Entity.Pond entity = new Entity.Pond(); entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); entity.Name = dataReader["Name"].ToString(); entity.Capacity = decimal.Parse(dataReader["Capacity"].ToString()); entity.Used = decimal.Parse(dataReader["Used"].ToString()); entity.Stores = dataReader["Stores"].ToString(); entity.Number = DataHelper.ParseToInt(dataReader["Number"].ToString()); entity.IsDelete = DataHelper.ParseToInt(dataReader["IsDelete"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="ID"> </param> /// <returns></returns> public static List <Entity.Menu> GetMenuByUserEx(int UserID) { List <Entity.Menu> list = new List <Entity.Menu>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vUserMenu] where UserID='" + UserID + "'", null); while (dataReader.Read()) { Entity.Menu entity = new Entity.Menu(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.FatherID = DataHelper.ParseToInt(dataReader["FatherID"].ToString()); entity.MenuName = dataReader["MenuName"].ToString(); entity.ImageUrl = dataReader["ImageUrl"].ToString(); entity.MenuUrl = dataReader["MenuUrl"].ToString(); entity.MenuOrder = DataHelper.ParseToInt(dataReader["MenuOrder"].ToString()); entity.MenuFile = dataReader["MenuFile"].ToString(); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="ID"> </param> /// <returns></returns> public static Entity.Position GetPosition(int ID) { Entity.Position entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [Position] where ID='" + ID + "'", null); while (dataReader.Read()) { entity = new Entity.Position(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.Name = dataReader["Name"].ToString(); entity.OrderID = DataHelper.ParseToInt(dataReader["OrderID"].ToString()); entity.IsShow = DataHelper.ParseToInt(dataReader["IsShow"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="ID"> </param> /// <returns></returns> public static Entity.Driver GetDriverByID(int ID) { Entity.Driver entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [Driver] where ID='" + ID + "'", null); while (dataReader.Read()) { entity = new Entity.Driver(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.RealName = dataReader["RealName"].ToString(); entity.CarNumber = dataReader["CarNumber"].ToString(); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); entity.IsStop = DataHelper.ParseToBoolean(dataReader["IsStop"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="Name"> </param> /// <returns></returns> public static Entity.Enterprise GetEnterpriseInfo(string Name) { Entity.Enterprise entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [Enterprise] where Name='" + Name + "'", null); while (dataReader.Read()) { entity = new Entity.Enterprise(); entity.EnterpriseID = DataHelper.ParseToInt(dataReader["EnterpriseID"].ToString()); entity.Name = dataReader["Name"].ToString(); entity.AreaCode = dataReader["AreaCode"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="WTPID"> </param> /// <returns></returns> public static List <Entity.ProductDetail> GetProductDetailEx(int WTPID) { List <Entity.ProductDetail> list = new List <Entity.ProductDetail>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vProductDetail] where WTPID='" + WTPID + "'", null); while (dataReader.Read()) { Entity.ProductDetail entity = new Entity.ProductDetail(); entity.DetailID = DataHelper.ParseToInt(dataReader["DetailID"].ToString()); entity.WTPID = DataHelper.ParseToInt(dataReader["WTPID"].ToString()); entity.ItemCode = dataReader["ItemCode"].ToString(); entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); entity.Name = dataReader["Name"].ToString(); entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); entity.Amount = decimal.Parse(dataReader["Amount"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="BillNumber"> </param> /// <returns></returns> public static List <Entity.AnalysisResult> GetAnalysisResultEx(string BillNumber) { List <Entity.AnalysisResult> list = new List <Entity.AnalysisResult>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vAnalysisResult] where BillNumber='" + BillNumber + "'", null); while (dataReader.Read()) { Entity.AnalysisResult entity = new Entity.AnalysisResult(); entity.ResultID = DataHelper.ParseToInt(dataReader["ResultID"].ToString()); entity.BillNumber = dataReader["BillNumber"].ToString(); entity.ItemCode = dataReader["ItemCode"].ToString(); entity.ItemName = dataReader["ItemName"].ToString(); entity.Result = decimal.Parse(dataReader["Result"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="ID"> </param> /// <returns></returns> public static Entity.Area GetAreaByID(int ID) { Entity.Area entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [Area] where ID='" + ID + "'", null); while (dataReader.Read()) { entity = new Entity.Area(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.AreaCode = DataHelper.ParseToInt(dataReader["AreaCode"].ToString()); entity.FullName = dataReader["FullName"].ToString(); entity.LetterCode = dataReader["LetterCode"].ToString(); entity.ShortName = dataReader["ShortName"].ToString(); entity.IsDelete = DataHelper.ParseToInt(dataReader["IsDelete"].ToString()); entity.OrderID = DataHelper.ParseToInt(dataReader["OrderID"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <returns></returns> public static List <Entity.Role> GetAllRole() { List <Entity.Role> list = new List <Entity.Role>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select * from Role", prams); while (dataReader.Read()) { Entity.Role entity = new Entity.Role(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.RoleName = dataReader["RoleName"].ToString(); entity.Description = dataReader["Description"].ToString(); //entity.IsAudit = DataHelper.ParseToBoolean(dataReader["IsAudit"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <returns></returns> public static Entity.PondUsed GetAllPondUsed() { Entity.PondUsed entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [PondUsed]", null); while (dataReader.Read()) { entity = new Entity.PondUsed(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); entity.Used = decimal.Parse(dataReader["Used"].ToString()); entity.SourceType = DataHelper.ParseToInt(dataReader["SourceType"].ToString()); entity.TypeName = dataReader["TypeName"].ToString(); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="DealID"> </param> /// <returns></returns> public static Entity.WasteToProduct GetWasteToProduct(int DealID) { Entity.WasteToProduct entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [WasteToProduct] where DealID='" + DealID + "'", null); while (dataReader.Read()) { entity = new Entity.WasteToProduct(); entity.DealID = DataHelper.ParseToInt(dataReader["DealID"].ToString()); entity.FromPondID = DataHelper.ParseToInt(dataReader["FromPondID"].ToString()); entity.FromWasteCode = dataReader["FromWasteCode"].ToString(); entity.DateTime = DataHelper.ParseToDate(dataReader["DateTime"].ToString()); entity.FromAmount = decimal.Parse(dataReader["FromAmount"].ToString()); entity.HanderManID = DataHelper.ParseToInt(dataReader["HanderManID"].ToString()); entity.ReceiverID = DataHelper.ParseToInt(dataReader["ReceiverID"].ToString()); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="UserID"> </param> /// <returns></returns> public static Entity.UserRole GetUserRoleByGUID(string GUID) { Entity.UserRole entity = new Entity.UserRole(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { List <Entity.Role> Roles = new List <Entity.Role>(); IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select * from vUserRole where GUID='" + GUID + "'", null); if (dataReader.Read()) { //Entity.UserRole entity = new Entity.UserRole(); //entity.UserID = DataHelper.ParseToInt(dataReader["UserID"].ToString()); //entity.RoleID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); //list.Add(entity); entity.user.ID = DataHelper.ParseToInt(dataReader["UserID"].ToString()); entity.user.UserName = dataReader["UserName"].ToString(); entity.user.PassWord = dataReader["PassWord"].ToString(); entity.user.GUID = dataReader["GUID"].ToString(); entity.user.RealName = dataReader["RealName"].ToString(); entity.user.IsStop = DataHelper.ParseToBoolean(dataReader["IsStop"].ToString()); //entity.role.ID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); //entity.role.RoleName = dataReader["RoleName"].ToString(); //entity.role.Description = dataReader["Description"].ToString(); //entity.role.IsAudit = DataHelper.ParseToBoolean(dataReader["IsAudit"].ToString()); } dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select * from vUserRole where GUID='" + GUID + "'", null); while (dataReader.Read()) { Entity.Role role = new Entity.Role(); role.ID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); role.RoleName = dataReader["RoleName"].ToString(); role.Description = dataReader["Description"].ToString(); Roles.Add(role); //entity.role.IsAudit = DataHelper.ParseToBoolean(dataReader["IsAudit"].ToString()); } entity.role = Roles; } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="StorageID"> </param> /// <returns></returns> public static Entity.WasteStorage GetWasteStorage(int StorageID) { Entity.WasteStorage entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vWasteStorage] where StorageID='" + StorageID + "'", null); while (dataReader.Read()) { entity = new Entity.WasteStorage(); entity.StorageID = DataHelper.ParseToInt(dataReader["StorageID"].ToString()); entity.PlanNumber = dataReader["PlanNumber"].ToString(); entity.PlanID = DataHelper.ParseToInt(dataReader["PlanID"].ToString()); entity.BillNumber = dataReader["BillNumber"].ToString(); entity.DateTime = DataHelper.ParseToDate(dataReader["DateTime"].ToString()); entity.EnterpriseID = DataHelper.ParseToInt(dataReader["EnterpriseID"].ToString()); entity.ProduceName = dataReader["ProduceName"].ToString(); entity.WasteCode = dataReader["WasteCode"].ToString(); entity.WasteName = dataReader["WasteName"].ToString(); entity.Amount = decimal.Parse(dataReader["Amount"].ToString()); entity.DriverID = DataHelper.ParseToInt(dataReader["DriverID"].ToString()); entity.RealName = dataReader["RealName"].ToString(); entity.CarID = DataHelper.ParseToInt(dataReader["CarID"].ToString()); entity.CarNumber = dataReader["CarNumber"].ToString(); entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); entity.PondName = dataReader["PondName"].ToString(); entity.ReceiverID = DataHelper.ParseToInt(dataReader["ReceiverID"].ToString()); entity.ReceiverName = dataReader["ReceiverName"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); entity.StatusName = dataReader["StatusName"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="EnterpriseID"> </param> /// <returns></returns> public static Entity.Enterprise GetEnterprise(int EnterpriseID) { Entity.Enterprise entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [Enterprise] where EnterpriseID='" + EnterpriseID + "'", null); while (dataReader.Read()) { entity = new Entity.Enterprise(); entity.EnterpriseID = DataHelper.ParseToInt(dataReader["EnterpriseID"].ToString()); entity.Name = dataReader["Name"].ToString(); entity.LawManCode = dataReader["LawManCode"].ToString(); entity.OrganizationCode = dataReader["OrganizationCode"].ToString(); entity.PastName = dataReader["PastName"].ToString(); entity.SetUpDate = DataHelper.ParseToDate(dataReader["SetUpDate"].ToString()); entity.Type = DataHelper.ParseToInt(dataReader["Type"].ToString()); entity.FaxNumber = dataReader["FaxNumber"].ToString(); entity.Industry = DataHelper.ParseToInt(dataReader["Industry"].ToString()); entity.AreaCode = dataReader["AreaCode"].ToString(); entity.PostCode = dataReader["PostCode"].ToString(); entity.Address = dataReader["Address"].ToString(); entity.LawMan = dataReader["LawMan"].ToString(); entity.Email = dataReader["Email"].ToString(); entity.Phone1 = dataReader["Phone1"].ToString(); entity.Telphone1 = dataReader["Telphone1"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <param name="PlanID"> </param> /// <returns></returns> public static Entity.TransferPlan GetTransferPlan(int PlanID) { Entity.TransferPlan entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vTransferPlan] where PlanID='" + PlanID + "'", null); while (dataReader.Read()) { entity = new Entity.TransferPlan(); entity.PlanID = DataHelper.ParseToInt(dataReader["PlanID"].ToString()); entity.ContractID = DataHelper.ParseToInt(dataReader["ContractID"].ToString()); entity.PlanNumber = dataReader["PlanNumber"].ToString(); entity.ApprovalDate = DataHelper.ParseToDate(dataReader["ApprovalDate"].ToString()); entity.StartDate = DataHelper.ParseToDate(dataReader["StartDate"].ToString()); entity.EndDate = DataHelper.ParseToDate(dataReader["EndDate"].ToString()); entity.PlanAmount = decimal.Parse(dataReader["PlanAmount"].ToString()); entity.WasteCode = dataReader["WasteCode"].ToString(); entity.WasteName = dataReader["WasteName"].ToString(); entity.ProduceID = DataHelper.ParseToInt(dataReader["ProduceID"].ToString()); entity.ProduceName = dataReader["ProduceName"].ToString(); entity.Remark = dataReader["Remark"].ToString(); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); entity.StatusID = DataHelper.ParseToInt(dataReader["StatusID"].ToString()); entity.IYear = DataHelper.ParseToInt(dataReader["IYear"].ToString()); entity.Number = DataHelper.ParseToInt(dataReader["Number"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <returns></returns> public static List <Entity.User> GetAllUser() { List <Entity.User> list = new List <Entity.User>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_User_GetAll", prams); while (dataReader.Read()) { Entity.User entity = new Entity.User(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.UserName = dataReader["UserName"].ToString(); entity.PassWord = dataReader["PassWord"].ToString(); entity.GUID = dataReader["GUID"].ToString(); //entity.AreaCode = dataReader["AreaCode"].ToString(); //entity.AreaInCharge = dataReader["AreaInCharge"].ToString(); entity.RealName = dataReader["RealName"].ToString(); entity.PwdChgDate = DataHelper.ParseToDate(dataReader["PwdChgDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); entity.IsStop = DataHelper.ParseToBoolean(dataReader["IsStop"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="Name"> </param> /// <returns></returns> public static int GetDriverID(string Name) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select ID from [Driver] where RealName='" + Name + "'", null); while (dataReader.Read()) { iReturn = DataHelper.ParseToInt(dataReader["ID"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="PlanNumber"> </param> /// <param name="IYear"> </param> /// <returns></returns> public static int GetCount(DateTime?Date) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select MAX(Number) as Number from [vFinalWasteLog] where DateTime='" + Date + "'", null); while (dataReader.Read()) { iReturn = DataHelper.ParseToInt(dataReader["Number"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="ContractNumber"> </param> /// <returns></returns> public static int GetPlanIDByNumber(string PlanNumber) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [TransferPlan] where PlanNumber='" + PlanNumber + "'", null); while (dataReader.Read()) { iReturn = DataHelper.ParseToInt(dataReader["PlanID"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="PlanNumber"> </param> /// <param name="IYear"> </param> /// <returns></returns> public static int GetMaxNumber(string ProduceArea, int IYear) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select MAX(Number) as Number from [vTransferPlan] where ProduceArea='" + ProduceArea + "' and IYear='" + IYear + "'", null); while (dataReader.Read()) { iReturn = DataHelper.ParseToInt(dataReader["Number"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }