/// <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);
}
