/// <summary>
/// 获取组织机构信息
/// </summary>
/// <param name="orga">条件</param>
/// <returns>组织机构信息</returns>
public Orgaization Get(Orgaization orga)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
Orgaization tmporga = new Orgaization();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取用户信息
sql = "SELECT ORGANID,ORGANDESC,ORGANPARENT,CREATEUSER,CREATETIME,UPDATEUSER,UPDATETIME,DELFLAG FROM T_ORGANIZATION AS A WHERE ORGANID=@ORGANID";
parameters.Add(new DataParameter {
ParameterName = "ORGANID", DataType = DbType.String, Value = orga.OrganID
});
tmporga = session.Get <Orgaization>(sql, parameters.ToArray());
}
return(tmporga);
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 获取入库单信息
/// </summary>
/// <param name="info">入库信息</param>
/// <returns></returns>
public InStockBill GetInfo(InStockBill info)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取数据
info = session.Get <InStockBill>(info);
//获取明细信息
sql = @"select t1.ID,t1.Seq,t1.MatBarCode,t1.MatID,t2.MatCode as MatCode,t2.MatName as MatName,t1.ProduceDate,
t1.InAmount,t1.InPrice,t1.InSum,t3.Description as SaveSite,t3.Description as SaveSiteName,t1.Remark,t4.Description as SpecCode,
t5.Description as MainUnitName,twms.UnitName,twms.Description as InSpecName
from T_WH_InStockDetail t1
left outer join T_WH_Mat t2 on t1.MatID=t2.ID
left outer join T_WH_MatIDCode mic on t1.MatBarCode=mic.IDCode
left outer join T_WH_Site t3 on t1.SaveSite=t3.ID
left outer join T_WH_Spec t4 on t2.SpecCode=t4.ID
left outer join T_WH_MatUnit t5 on t2.UnitCode=t5.ID
left outer join T_WH_MatSpec twms on mic.MatSpec = twms.ID
where t1.BillID=@BillID";
parameters.Add(new DataParameter("BillID", info.ID));
info.Details = session.GetList <InStockDetail>(sql, parameters.ToArray()).ToList();
}
return(info);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取监测项目信息
/// </summary>
/// <param name="itemInfo">条件</param>
/// <returns>获取监测项目信息</returns>
public InspectItemEntity Get(InspectItemEntity itemInfo)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder whereBuilder = new StringBuilder();
List <DataParameter> parameters = new List <DataParameter>();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sqlBuilder.Append(" SELECT Id,ItemCode, ");
sqlBuilder.Append(" ItemName,Unit,PointCount,Remark, ");
sqlBuilder.Append(" CREATEUSER,CREATETIME,UPDATEUSER,UPDATETIME ");
sqlBuilder.Append(" FROM InspectItemInfo A WHERE Id = @Id ");
parameters.Add(new DataParameter {
ParameterName = "Id", DataType = DbType.String, Value = itemInfo.Id
});
itemInfo = session.Get <InspectItemEntity>(sqlBuilder.ToString(), parameters.ToArray());
}
return(itemInfo);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 判断登陆账户是否重复
/// </summary>
/// <param name="user">条件</param>
/// <returns>用户信息信息</returns>
public User GetLoginUser(User user)
{
StringBuilder sqlBuilder = new StringBuilder();
List <DataParameter> parameters = new List <DataParameter>();
User tmpuser = new User();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取用户信息
sqlBuilder.Append(" SELECT USERID, ");
sqlBuilder.Append(" LOGINUSERID,USERNAME,PASSWORD,TEL, ");
sqlBuilder.Append(" MOBILETEL,EMAIL,CREATEUSER,CREATETIME,UPDATEUSER,UPDATETIME, ");
sqlBuilder.Append(" DELFLAG,ISSTOP ");
sqlBuilder.Append(" FROM T_USER AS A WHERE LOGINUSERID = @LOGINUSERID AND DELFLAG='0'");
parameters.Add(new DataParameter {
ParameterName = "LOGINUSERID", DataType = DbType.String, Value = user.LoginUserID
});
tmpuser = session.Get <User>(sqlBuilder.ToString(), parameters.ToArray());
}
return(tmpuser);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取库存信息
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public WHMatAmount GetStock(WHMatAmount condition)
{
string sql = null;
WHMatAmount info = null;
sql = "select * from T_WH_MatAmount where Warehouse = @Warehouse and SaveSite = @SaveSite and MatID = @MatID and MatBarCode = @MatBarCode";
if (Session != null)
{
info = Session.Get <WHMatAmount>(sql
, new DataParameter("Warehouse", condition.Warehouse)
, new DataParameter("SaveSite", condition.SaveSite)
, new DataParameter("MatID", condition.MatID)
, new DataParameter("MatBarCode", condition.MatBarCode));
}
else
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
info = session.Get <WHMatAmount>(sql
, new DataParameter("Warehouse", condition.Warehouse)
, new DataParameter("SaveSite", condition.SaveSite)
, new DataParameter("MatID", condition.MatID)
, new DataParameter("MatBarCode", condition.MatBarCode));
}
}
return(info);
}
/// <summary>
/// 获取监测设备信息
/// </summary>
/// <param name="itemInfo">条件</param>
/// <returns>获取监测项目信息</returns>
public InspectDeviceEntity Get(InspectDeviceEntity itemInfo)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder whereBuilder = new StringBuilder();
List <DataParameter> parameters = new List <DataParameter>();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sqlBuilder.Append(" SELECT Id,DeviceCode, ");
sqlBuilder.Append(" DeviceName,DeviceIP,DevicePort,LanIP,LanPort, ");
sqlBuilder.Append(" LastLoginTime,LastRegisterTime,Lon,Lat,A.OrganID,O.ORGANDESC AS OrganDESC,DeviceType,Remark, ");
sqlBuilder.Append(" A.CREATEUSER,A.CREATETIME,A.UPDATEUSER,A.UPDATETIME ");
sqlBuilder.Append(" FROM deviceinfo A LEFT JOIN t_organization O ON A.OrganID = O.OrganID WHERE Id = @Id ");
parameters.Add(new DataParameter {
ParameterName = "Id", DataType = DbType.String, Value = itemInfo.Id
});
itemInfo = session.Get <InspectDeviceEntity>(sqlBuilder.ToString(), parameters.ToArray());
}
return(itemInfo);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 通过生产批次号获取生产计划
/// </summary>
/// <param name="batchNumber">生产批次号</param>
/// <returns>生产计划</returns>
public ProducePlan GetByBatchNumber(string batchNumber)
{
ProducePlan plan = null;
string sql = "select * from T_FP_ProducePlan where BatchNumber = @BatchNumber";
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取信息
plan = session.Get <ProducePlan>(sql, new DataParameter("BatchNumber", batchNumber));
}
return(plan);
}
/// <summary>
/// 获取主计量单位
/// </summary>
/// <param name="matID">货品主键</param>
/// <returns>主计量单位</returns>
public MatUnit GetMainUnit(string matID)
{
MatUnit unit = null;
string sql = null;
sql = @"select u.ID,u.Description from T_WH_Mat m
inner join T_WH_MatUnit u on m.UnitCode = u.ID
where m.ID = @MatID";
using (IDataSession session = AppDataFactory.CreateMainSession())
{
unit = session.Get <MatUnit>(sql, new DataParameter("MatID", matID));
}
return(unit);
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public WorkGroup Get(WorkGroup model)
{
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取信息
model = session.Get <WorkGroup>(model);
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public ProductInfo Get(ProductInfo model)
{
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取信息
model = session.Get <ProductInfo>(model);
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public WHOutMode Get(WHOutMode model)
{
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取信息
model = session.Get <WHOutMode>(model);
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public WHStockLimit Get(WHStockLimit info)
{
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取信息
info = session.Get <WHStockLimit>(info);
}
return(info);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public VDCamera Get(VDCamera model)
{
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取信息
model = session.Get <VDCamera>(model);
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public MatUnit Get(MatUnit model)
{
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取信息
model = session.Get <MatUnit>(model);
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取用户信息信息
/// </summary>
/// <param name="user">条件</param>
/// <returns>用户信息信息</returns>
public User Get(User user)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder whereBuilder = new StringBuilder();
List <DataParameter> parameters = new List <DataParameter>();
User tmpuser = new User();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取用户信息
sqlBuilder.Append(" SELECT USERID, ");
sqlBuilder.Append(" LOGINUSERID,USERNAME,ORGANID,PASSWORD,TEL, ");
sqlBuilder.Append(" MOBILETEL,EMAIL,CREATEUSER,CREATETIME,UPDATEUSER,UPDATETIME, ");
sqlBuilder.Append(" DELFLAG,ISSTOP ");
sqlBuilder.Append(" FROM T_USER A WHERE UserID = @UserID");
parameters.Add(new DataParameter {
ParameterName = "UserID", DataType = DbType.String, Value = user.UserID
});
tmpuser = session.Get <User>(sqlBuilder.ToString(), parameters.ToArray());
tmpuser.PassWord = DESEncrypt.Decrypt(tmpuser.PassWord);
//获取用户所有角色信息
sqlBuilder.Remove(0, sqlBuilder.Length);
parameters = new List <DataParameter>();
sqlBuilder.Append(@"SELECT UR.USERID,UR.ROLEID,R.ROLEDESC
FROM T_USERROLE UR
INNER JOIN T_ROLE R ON UR.ROLEID = R.ROLEID
WHERE UR.USERID=@USERID");
parameters.Add(new DataParameter {
ParameterName = "USERID", DataType = DbType.String, Value = user.UserID
});
tmpuser.Roles = session.GetList <UserRole>(sqlBuilder.ToString(), parameters.ToArray()).ToList();
}
return(tmpuser);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取公告信息
/// </summary>
/// <param name="user">条件</param>
/// <returns>公告信息</returns>
public NoticeInfo Get(NoticeInfo notice)
{
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取公告信息
notice = session.Get <NoticeInfo>(notice);
}
return(notice);
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 获取领料单信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public UseMatBill Get(UseMatBill model)
{
UseMatBill info = null;
List <DataParameter> parameters = new List <DataParameter>();
string sql = null;
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//基本信息
sql = @"SELECT um.PID,si.BatchNumber,fi.PNAME AS FACTORYNAME,pi.PNAME AS ProduceName,pl.PLNAME AS PLName
,wh.Description as WarehouseName
FROM T_WH_UseMat um
INNER JOIN T_FP_SUPPLYINFO si on um.SUPPLYID = si.PID
LEFT OUTER JOIN T_FP_ProducePlan pp ON si.PLANID = pp.PID
LEFT OUTER JOIN T_FP_FACTORYINFO fi ON pp.FACTORYPID =fi.PID
LEFT OUTER JOIN T_FP_PRODUCTINFO pi ON pp.PRODUCTIONID = pi.PID
LEFT OUTER JOIN T_FP_PRODUCTLINE pl on pp.PRID = pl.PID
LEFT OUTER JOIN T_WH_Warehouse wh on si.Warehouse=wh.ID
where um.PID = @PID";
info = session.Get <UseMatBill>(sql, new DataParameter("PID", model.PID));
//领料数量
sql = @"select mat.MatName,uma.AMOUNT,mu.Description as UnitName from T_WH_UseMatAmount uma
left outer join T_WH_Mat mat on uma.MATRIALID = mat.ID
left outer join T_WH_MatUnit mu on mat.UnitCode = mu.ID";
parameters.Clear();
parameters.Add(new DataParameter("PID", model.PID));
info.Amounts = session.GetList <UseMatAmount>(sql, parameters.ToArray()).ToList();
//领料明细
sql = @"select whs.Description as SaveSite,umd.MatBarCode,mat.MatName,umd.AMOUNT,twms.UnitName as Unit
from T_WH_UseMatDetail umd
left outer join T_WH_MatIDCode mic on umd.MatBarCode=mic.IDCode
left outer join T_WH_MatSpec twms on mic.MatSpec = twms.ID
left outer join T_WH_Site whs on umd.SaveSite = whs.ID
left outer join T_WH_Mat mat on umd.MATRIALID = mat.ID
left outer join T_WH_MatUnit mu on mat.UnitCode = mu.ID";
parameters.Clear();
parameters.Add(new DataParameter("PID", model.PID));
info.Details = session.GetList <UseMatDetail>(sql, parameters.ToArray()).ToList();
}
return(info);
}
/// <summary>
/// 获取根据条码库存信息
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public WHMatAmount GetStockByBarCode(string matBarCode)
{
string sql = null;
WHMatAmount info = null;
sql = @"select t1.*,twms.UnitName,t2.MatCode,t2.MatName,twms.Description as MatSpec
from T_WH_MatAmount t1
left outer join T_WH_MatSpec twms on t1.Unit = twms.ID
left outer join T_WH_Mat t2 on t1.MatID=t2.ID
where t1.MatBarCode = @MatBarCode";
using (IDataSession session = AppDataFactory.CreateMainSession())
{
info = session.Get <WHMatAmount>(sql
, new DataParameter("MatBarCode", matBarCode));
}
return(info);
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public SupplyInfo Get(SupplyInfo model)
{
SupplyInfo info = null;
StringBuilder sqlBuilder = new StringBuilder();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sqlBuilder.Append(@"SELECT si.*,fi.PNAME AS FACTORYNAME,pi.PNAME AS ProduceName,pl.PLNAME AS PLName
FROM T_FP_SUPPLYINFO si
LEFT OUTER JOIN T_FP_ProducePlan pp ON si.PLANID = pp.PID
LEFT OUTER JOIN T_FP_FACTORYINFO fi ON pp.FACTORYPID =fi.PID
LEFT OUTER JOIN T_FP_PRODUCTINFO pi ON pp.PRODUCTIONID = pi.PID
LEFT OUTER JOIN T_FP_PRODUCTLINE pl on pp.PRID = pl.PID
where si.PID = @SUPPLYID");
info = session.Get <SupplyInfo>(sqlBuilder.ToString(), new DataParameter("SUPPLYID", model.PID));
}
return(info);
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="produceID">产品主键</param>
/// <returns>*信息</returns>
public ProduceBOM GetByProduceID(string produceID)
{
ProduceBOM info = null;
try
{
string sql = "select * from T_FP_PRODUCEBOM where PRODUCEID = @PRODUCEID";
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取信息
info = session.Get <ProduceBOM>(sql, new DataParameter("PRODUCEID", produceID));
}
return(info);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据货品编号获取货品信息
/// </summary>
/// <param name="matCode">货品编号</param>
/// <returns>货品信息</returns>
public WHMat GetMatByMatCode(string matCode)
{
WHMat mat = null;
string sql = null;
sql = @"select t1.ID,t1.ID as MatID,t1.MatCode,t1.MatName,t3.Description as SpecCode,t4.Description as UnitName,t4.ID as UnitCode
from T_WH_Mat t1
left join T_WH_Spec t3 on t1.SpecCode=t3.ID
left join T_WH_MatUnit t4 on t1.UnitCode=t4.ID
where t1.MatCode = @MatCode";
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sql = this.ChangeSqlByDB(sql, session);
mat = session.Get <WHMat>(sql, new DataParameter("MatCode", matCode));
}
return(mat);
}
/// <summary>
/// 获取出库单浏览信息
/// </summary>
/// <param name="info">获取条件</param>
/// <returns>出库单浏览信息</returns>
public OutStockBillView GetViewInfo(OutStockBillView info)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取基本信息
sql = @"select t1.ID,t1.BillNO,t1.BillDate,t2.Clientname as Client,t3.Description as OutStockMode,
t4.Description as Warehouse,u1.USERNAME as Header,u2.USERNAME as WHHeader,
u3.USERNAME as HandlePerson,t1.Remark
from T_WH_OutStockBill t1
left outer join T_WH_Client t2 on t1.ClientCode=t2.ID
left outer join T_WH_OutMode t3 on t1.OutStockMode=t3.ID
left outer join T_WH_Warehouse t4 on t1.Warehouse=t4.ID
left outer join T_USER u1 on t1.Header=u1.USERID
left outer join T_USER u2 on t1.WHHeader=u2.USERID
left outer join T_USER u3 on t1.HandlePerson=u3.USERID
where t1.ID=?ID";
info = session.Get <OutStockBillView>(sql, new DataParameter("ID", info.ID));
//获取明细信息
sql = @"select t1.ID,t1.Seq,t1.IDCode,t1.MatID,t2.MatCode as MatCode,t2.MatName as MatName,t1.MainUnitAmount,
t1.OutAmount,t1.OutPrice,t1.OutSum,t3.Description as SaveSite,t1.Remark,twms.Description as SpecCode,
twms.UnitName,t5.Description as MainUnitName
from T_WH_OutStockDetail t1
left outer join T_WH_Mat t2 on t1.MatID=t2.ID
left outer join T_WH_MatIDCode mic on t1.IDCode=mic.IDCode
left outer join T_WH_MatSpec twms on mic.MatSpec = twms.ID
left outer join T_WH_Site t3 on t1.SaveSite=t3.ID
left outer join T_WH_Spec t4 on t2.SpecCode=t4.ID
left outer join T_WH_MatUnit t5 on t2.UnitCode=t5.ID
where t1.BillID=@BillID";
parameters.Add(new DataParameter("BillID", info.ID));
info.Details = session.GetList <OutStockDetailView>(sql, parameters.ToArray()).ToList();
}
return(info);
}
/// <summary>
/// 获取入库单浏览信息
/// </summary>
/// <param name="info">获取条件</param>
/// <returns>入库单浏览信息</returns>
public InStockBillView GetViewInfo(InStockBillView info)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取基本信息
sql = @"select t1.ID,t1.BillNO,t1.BillDate,t2.ProviderName as Provider,t3.Description as InStockMode,
t4.Description as Warehouse,u1.USERNAME as DeliveryPerson,u2.USERNAME as Receiver,
u3.USERNAME as WHHeader,t1.Remark
from T_WH_InStockBill t1
left outer join T_WH_Provider t2 on t1.ProviderID=t2.ID
left outer join T_WH_InMode t3 on t1.InStockMode=t3.ID
left outer join T_WH_Warehouse t4 on t1.Warehouse=t4.ID
left outer join T_USER u1 on t1.DeliveryPerson=u1.USERID
left outer join T_USER u2 on t1.Receiver=u2.USERID
left outer join T_USER u3 on t1.WHHeader=u3.USERID
where t1.ID=?ID";
info = session.Get <InStockBillView>(sql, new DataParameter("ID", info.ID));
//获取明细信息
sql = @"select t1.ID,t1.Seq,t1.MatBarCode,t1.MatID,t2.MatCode as MatCode,t2.MatName as MatName,t1.ProduceDate,
t1.InAmount,t1.InPrice,t1.InSum,t3.Description as SaveSite,t1.Remark,
twms.UnitName,t1.MatSpec,t5.Description as MainUnitName
from T_WH_InStockDetail t1
left outer join T_WH_Mat t2 on t1.MatID=t2.ID
left outer join T_WH_MatIDCode mic on t1.MatBarCode=mic.IDCode
left outer join T_WH_MatSpec twms on mic.MatSpec = twms.ID
left outer join T_WH_Site t3 on t1.SaveSite=t3.ID
left outer join T_WH_MatUnit t5 on t2.UnitCode=t5.ID
where t1.BillID=@BillID";
parameters.Add(new DataParameter("BillID", info.ID));
info.Details = session.GetList <InStockDetailView>(sql, parameters.ToArray()).ToList();
}
return(info);
}
/// <summary>
/// 获取角色信息
/// </summary>
/// <param name="role">条件</param>
/// <returns>角色信息</returns>
public RoleInfo Get(RoleInfo role)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
RoleInfo r = new RoleInfo();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取角色信息
sql = "SELECT ROLEID,ROLEDESC,CREATEUSER,CREATETIME,UPDATEUSER,UPDATETIME FROM T_ROLE WHERE ROLEID=@ROLEID";
parameters.Add(new DataParameter {
ParameterName = "ROLEID", DataType = DbType.String, Value = role.RoleID
});
sql = this.ChangeSqlByDB(sql, session);
r = session.Get <RoleInfo>(sql, parameters.ToArray());
//获取权限信息
sql.Remove(0, sql.Length);
parameters = new List <DataParameter>();
sql = "SELECT * FROM T_ROLEAUTHORITY WHERE ROLEID=@ROLEID";
parameters.Add(new DataParameter {
ParameterName = "ROLEID", DataType = DbType.String, Value = role.RoleID
});
sql = this.ChangeSqlByDB(sql, session);
r.Powers = session.GetList <RoleAuthority>(sql, parameters.ToArray()).ToList();
}
return(r);
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 获取盘点单信息
/// </summary>
/// <param name="info">入库信息</param>
/// <returns></returns>
public CheckStockBill GetInfo(CheckStockBill info)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取数据
sql = @"select t1.*,t3.Description as AreaName,u3.USERNAME as CheckHeaderName,t2.Description as WarehouseName
from T_WH_CheckStock t1
inner join T_WH_Warehouse t2 on t1.Warehouse=t2.ID
left outer join T_WH_AREA t3 on t1.AreaID=t3.ID
left outer join T_USER u3 on t1.CheckHeader=u3.USERID
where t1.ID = @ID";
info = session.Get <CheckStockBill>(sql, new DataParameter("ID", info.ID));
//获取明细信息
sql = @"select t1.ID,t1.Seq,t1.IDCode,t1.MatID,t1.SaveSite,t2.MatCode as MatCode,t2.MatName as MatName,
t1.StockAmount,t1.FactAmount,t1.ProfitAmount,t1.LossAmount,t1.Remark
,t3.Description as SaveSiteName,t1.Unit,t4.Description as UnitName
from T_WH_CheckStockDetail t1
left outer join T_WH_Mat t2 on t1.MatID=t2.ID
left outer join T_WH_Site t3 on t1.SaveSite=t3.ID
left outer join T_WH_MatUnit t4 on t1.Unit=t4.ID
where t1.BillID=?BillID";
parameters.Add(new DataParameter("BillID", info.ID));
info.Details = session.GetList <CheckStockDetail>(sql, parameters.ToArray()).ToList();
}
return(info);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取产品基本信息
/// </summary>
/// <param name="PID">产品主键</param>
/// <returns>产品基本信息</returns>
public TraceGood GetTraceGood(string PID)
{
string sql = null;
TraceGood info = null;
sql = @"select g.PID,p.PNAME as ProductName,p.SPECIFICATION,g.PLANDATE as ProduceDate,g.BatchNumber,
f.PNAME as FactoryName,l.PLNAME as LineName,pf.PNAME as FlowName,wg.PNAME as WorkGroupName
from T_FP_GoodInfo g
left outer join T_FP_PRODUCTINFO p on g.ProductionID=p.PID
left outer join T_FP_FACTORYINFO f on g.FACTORYPID=f.PID
left outer join T_FP_PRODUCTLINE l on g.PRID=l.PID
left outer join T_FP_PROCESSFLOW pf on p.PRID=pf.PID
left outer join T_FP_WORKGROUP wg on g.WOID=wg.PID
where g.PID=@PID
";
using (IDataSession session = AppDataFactory.CreateMainSession())
{
info = session.Get <TraceGood>(sql, new DataParameter("PID", PID));
}
return(info);
}
/// <summary>
/// 获取数据变更痕迹数据
/// </summary>
/// <param name="info">变更痕迹</param>
/// <returns>变更痕迹</returns>
public DataMark GetInfo(DataMark info, ref DataTable columnDt)
{
StringBuilder sqlBuilder = new StringBuilder();
List <DataParameter> parameters = new List <DataParameter>();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sqlBuilder.Append("SELECT T1.MARKID,T1.OPERATETIME,T2.USERDES AS OPERATEUSER,T1.OPERATETYPE,T1.DATAKIND,T3.COMMENTS AS DATAKINDDES,T1.OriginalData,T1.ChangedData ");
sqlBuilder.Append("FROM T_BD_DATAMARK T1 ");
sqlBuilder.Append("left JOIN T_QM_USERINFO T2 ON t1.OPERATEUSER=T2.USERID ");
sqlBuilder.Append("left JOIN ALL_TAB_COMMENTS T3 ON T3.OWNER='PLP' AND T1.DATAKIND=T3.TABLE_NAME ");
sqlBuilder.Append("WHERE T1.MARKID=:MARKID");
//获取变更痕迹信息
info = session.Get <DataMark>(sqlBuilder.ToString(), new DataParameter("MARKID", info.MARKID));
//获取字段描述信息
if (columnDt != null)
{
sqlBuilder.Clear();
sqlBuilder.Append("SELECT T1.COLUMN_NAME AS COLUMNNAME, T1.COMMENTS AS COLUMNDES ");
sqlBuilder.Append("FROM USER_COL_COMMENTS T1, ALL_TAB_COMMENTS T2 ");
sqlBuilder.Append("WHERE T1.TABLE_NAME = T2.TABLE_NAME AND T1.TABLE_NAME = :TABLENAME");
parameters.Add(new DataParameter("TABLENAME", info.DATAKIND));
session.FillTable(columnDt, sqlBuilder.ToString(), parameters.ToArray());
}
}
return(info);
}
catch (Exception ex)
{
throw;
}
}
public WHMonthAccount Get(WHMonthAccount condition)
{
string sql = null;
WHMonthAccount info = null;
try
{
sql = @"select * from T_WH_MonthAccount
where Warehouse = @Warehouse and MatID = @MatID and AccountYear = @AccountYear and AccountMonth = @AccountMonth";
using (IDataSession session = AppDataFactory.CreateMainSession())
{
info = session.Get <WHMonthAccount>(sql
, new DataParameter("Warehouse", condition.Warehouse)
, new DataParameter("MatID", condition.MatID)
, new DataParameter("AccountYear", condition.AccountYear)
, new DataParameter("AccountMonth", condition.AccountMonth));
}
return(info);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 线程方法
/// </summary>
/// <param name="pObj"></param>
void ThreadFun(object pObj) // 来自委托：ParameterizedThreadStart
{
Orgaization organEntity = (Orgaization)pObj;
try
{
//根据企业ID.获取对应企业的服务地址
OrganInfo organInfo = null;
CommonCache.organServiceList.TryGetValue(organEntity.OrganID, out organInfo);
if (organInfo == null)
{
Console.WriteLine("当前企业(" + organEntity.OrganDESC + ")下没有配置服务地址,请联系管理员!");
return;
}
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client("BasicHttpBinding_IService1", organInfo.ServiceAddress);
//WCF未正常开放时.结束当前企业的循环
if (sc.State == CommunicationState.Closed || sc.State == CommunicationState.Faulted)
{
Console.WriteLine("未能连接客户端服务,请联系管理员!");
return;
}
//设备列表
List <DeviceInfo> deviceList = null;
//根据企业ID获取企业下的设备列表
using (IDataSession session = AppDataFactory.CreateMainSession())
{
string sql = "SELECT Id,DeviceCode,DeviceName FROM aifishingep.deviceinfo T WHERE T.ORGANID = @OrganID ORDER BY DeviceCode ";
List <DataParameter> dataParameter = new List <DataParameter>();
dataParameter.Add(new DataParameter {
ParameterName = "OrganID", DataType = DbType.String, Value = organEntity.OrganID
});
//插入基本信息
deviceList = session.GetList <DeviceInfo>(sql, dataParameter.ToArray()).ToList();
}
if (deviceList == null || deviceList.Count == 0)
{
Console.WriteLine("当前企业下没有可用设备,请联系管理员!");
return;
}
//循环设备
foreach (DeviceInfo di in deviceList)
{
HandleResult handleResult = null;
//判断企业的数据记录表中是不有记录.没有记录从数据库中取现有数据的最小日期
using (IDataSession session = AppDataFactory.CreateMainSession())
{
string sql = @"SELECT MAX(HandleEndTime) AS HandleEndTime FROM aifishingep.exchangeresult T
WHERE T.ORGANID = @OrganID AND T.DeviceSN = @DeviceSN";
List <DataParameter> dataParameter = new List <DataParameter>();
dataParameter.Add(new DataParameter {
ParameterName = "OrganID", DataType = DbType.String, Value = organEntity.OrganID
});
dataParameter.Add(new DataParameter {
ParameterName = "DeviceSN", DataType = DbType.String, Value = di.DeviceSN
});
//获取转发记录中时间的最大值
handleResult = session.Get <HandleResult>(sql, dataParameter.ToArray());
}
//查询的起始时间
DateTime st;
//如果没有已处理记录
if (handleResult != null && handleResult.HandleEndTime != new DateTime())
{
st = handleResult.HandleEndTime;
}
else
{
Console.WriteLine("当前企业没数据转发记录!");
//查询设备ID的最小日期值
st = getMinDate(di.DeviceSN);
}
//起始时间不存在或者没有记录
if (st == null || st == new DateTime())
{
continue;
}
//st = DateTime.Parse("2018-03-28 21:01:02");
//取出当前时间的前一分钟
DateTime currTime = DateTime.Now.AddMilliseconds(eachHandleLastTime);
//起始时间+设置的时间间隔.计算出理论结束时间
DateTime et = st.AddMilliseconds(eachHandleTime);
//跳出循环flag
bool looping = true;
while (looping)
{
//理论结束时间大于当前时间时.使用当前时间获取数据
if (et >= currTime)
{
//当前时间的前一分钟设置为结束时间
et = currTime;
//执行完成后要退回循环
looping = false;
}
bool handResult = doSaveData(sc, organEntity.OrganID, di.DeviceSN, st, et);
//数据未成功保存时,跳出当前循环
if (!handResult)
{
Console.WriteLine("转发企业(" + organEntity.OrganDESC + ")-设备(" + di.DeviceSN + ")-起始时间(" + st.ToString("yyyy-MM-dd HH:mm:ss") + ")-结束时间(" + et.ToString("yyyy-MM-dd HH:mm:ss") + "),发生异常请联系管理员!");
break;
}
//没有退出循环.继续增加指定时间
if (looping)
{
st = et;
//循环完.再为结束时间增加指定间隔的时间量
et = et.AddMilliseconds(eachHandleTime);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
Thread oldThread = null;
//清空缓存中企业对应的线程信息
CommonCache.threadList.TryGetValue(organEntity.OrganID, out oldThread);
if (oldThread.ThreadState != ThreadState.Stopped)
{
CommonCache.threadList.TryRemove(organEntity.OrganID, out oldThread);
oldThread.Abort();
}
}
}
/// <summary>
/// 获取用户和密码是否正确
/// </summary>
/// <param name="user">条件</param>
/// <returns>用户信息</returns>
public LoginInfo IsLogin(LoginInfo login)
{
StringBuilder sqlBuilder = new StringBuilder();
DataTable powerDt = new DataTable();
List <DataParameter> parameters = new List <DataParameter>();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取用户信息
sqlBuilder.Append(" SELECT * ");
sqlBuilder.Append(" FROM T_USER AS A WHERE LoginUserID = @LoginUserID AND PASSWORD = @PASSWORD ");
if (login.LoginUserID != "admin")
{
sqlBuilder.Append(" AND ISSTOP='0' ");
}
parameters.Add(new DataParameter {
ParameterName = "LoginUserID", DataType = DbType.String, Value = login.LoginUserID
});
parameters.Add(new DataParameter {
ParameterName = "PASSWORD", DataType = DbType.String, Value = login.PassWord
});
login = session.Get <LoginInfo>(sqlBuilder.ToString(), parameters.ToArray());
if (login != null)
{
//获取用户权限
sqlBuilder.Clear();
sqlBuilder.Append(@"
SELECT T1.AUTHORITYID FROM T_ROLEAUTHORITY T1
INNER JOIN T_USERROLE T2 ON T1.ROLEID = T2.ROLEID
WHERE T2.USERID = @USERID
UNION
SELECT AUTHORITYID FROM T_USERAUTHORITY
WHERE USERID = @USERID");
parameters.Clear();
parameters.Add(new DataParameter("USERID", login.UserID));
session.FillTable(powerDt, sqlBuilder.ToString(), parameters.ToArray());
login.Powers = new List <string>();
foreach (DataRow row in powerDt.Rows)
{
login.Powers.Add(row["AUTHORITYID"].ToString());
}
//获取用户所属的组织机构
sqlBuilder.Clear();
sqlBuilder.Append(" SELECT * ");
sqlBuilder.Append(" FROM T_USERORGAIZATION AS A WHERE USERID = @USERID");
parameters.Clear();
parameters.Add(new DataParameter {
ParameterName = "USERID", DataType = DbType.String, Value = login.UserID
});
}
}
return(login);
}
catch (Exception ex)
{
throw;
}
}
