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