public IEnumerable <QuerySchemaConfigModel> GetSchemaEntryByUserIdAndType(int userId, bool isConditionOut) { DataTable data = SqlHelper.ExecuteDataTable(" select a.UserId,a.Id BtnN,a.SchemaSeq,a.SchemaName,b.Id,b.OrgId,b.Label,b.BatchNo,b.ProductionModel,b.IsConditionOut,c.ContentTrans,b.SpecificationValueBegin,b.SpecificationValueEnd from SJUserQuerySchema a join SJUserQuerySchemaEntry b on a.Id=b.SchemaId join SJUserQuerySchemaSeq c on c.Id=a.SchemaSeq where a.UserId=@UserId and IsConditionOut = @IsConditionOut ;", new SqlParameter[] { new SqlParameter("@UserId", userId), new SqlParameter("@IsConditionOut", isConditionOut) }); return(SqlHelper.DataTableToModelList <QuerySchemaConfigModel>(data)); }
public IEnumerable <CrystalPrintConfigModel> GetCrystalPrintConfig(int typeId, string hostName) { DataTable data = SqlHelper.ExecuteDataTable(@" SELECT * FROM SJCrystalPrintConfig where TypeId=@TypeId and HostName=@HostName", new SqlParameter[] { new SqlParameter("@TypeId", typeId), new SqlParameter("@HostName", hostName) }); return(SqlHelper.DataTableToModelList <CrystalPrintConfigModel>(data)); }
public List <ProductiveTaskListModel> GetAllProductiveTaskListByDate(DateTime productionDate) { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJICMOList WHERE FProductionDate=@ProductionDate AND FType<>'其他' ORDER BY FBatchNo,FOrgID" , new SqlParameter[] { new SqlParameter("@ProductionDate", productionDate) }); return(SqlHelper.DataTableToModelList <ProductiveTaskListModel>(data)); }
public List <PrintSchemaParameterModel> GetPrintSchemaParameter(int userId, int schemaId) { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJPrintSchemaParameterModel where SchemaId=@SchemaId and UserId=@UserId;" , new SqlParameter[] { new SqlParameter("@SchemaId", schemaId), new SqlParameter("@UserId", userId) }); return(SqlHelper.DataTableToModelList <PrintSchemaParameterModel>(data)); }
/// <summary> /// 主页面 Datagrid数据 /// </summary> public List <LabelPrintHistoryModel> GetLabelPrintHistoryDataByDate(DateTime date, int userId) { DataTable data = SqlHelper.ExecuteDataTableProcedure(@"SJGetLabelPrintHistoryDataByDateUser" , new SqlParameter[] { new SqlParameter("@ProductionDate", date), new SqlParameter("@UserID", userId) }); return(SqlHelper.DataTableToModelList <LabelPrintHistoryModel>(data)); }
public IEnumerable <QuerySchemaConfigModel> GetSchemaEntryByUserId(int userId) { DataTable data = SqlHelper.ExecuteDataTable(@"select a.UserId,a.Id BtnN,a.SchemaSeq,a.SchemaName,b.Id,b.OrgId,b.Label,b.BatchNo,b.ProductionModel,b.IsConditionOut,b.SafeCode,b.CreateTime,b.SpecificationValueBegin,b.SpecificationValueEnd,a.SchemaPageSize from SJUserQuerySchema a join SJUserQuerySchemaEntry b on a.Id=b.SchemaId where a.UserId=@UserId;", new SqlParameter[] { new SqlParameter("@UserId", userId) }); return(SqlHelper.DataTableToModelList <QuerySchemaConfigModel>(data)); }
// 查看该用户某个打印状态记录 public IEnumerable <LabelPrintCurrencyModel> GetPrintResultRecord(DateTime date, int userID, string pringStatus) { ObservableCollection <LabelPrintCurrencyModel> list = new ObservableCollection <LabelPrintCurrencyModel>(); DataTable data = SqlHelper.ExecuteDataTable(" SELECT A.*,B.F_107 SafeCode ,B.F_108 DangerousIngredient, B.F_109 DangerousComment FROM SJLabelPrintResult A left join t_ICItemCustom B on A.FItemID=B.FItemID WHERE UserID=@UserID AND PrintStatus =@PrintStatus AND ProductionDate=@ProductionDate;" , new SqlParameter[] { new SqlParameter("@ProductionDate ", date), new SqlParameter("@UserID ", userID), new SqlParameter("@PrintStatus", pringStatus) }); return(SqlHelper.DataTableToModelList <LabelPrintCurrencyModel>(data)); }
/// <summary> /// 获取某个批号,在销售订单上的VOC名称 /// </summary> /// <param name="batchno"></param> /// <returns></returns> public List <VOCBucketCountModel> GetVocNameListsByBatchNo(DateTime productionDate, string batchNo, string label, string orgId) { DataTable data = SqlHelper.ExecuteDataTable(@" select b.VOCName,c.PrintCount from SJICMOList a join SJSEORDList b on a.FSEOrderEntryID = b.FSEOrderEntryID join SJLabelPrintHistory c on c.ProductiveTaskListID = a.id where a.FProductionDate= @FProductionDate and a.FBatchNo=@FBatchNo and isnull(a.VocVersion,0)=0 and a.FLabel =@FLabel and a.FOrgID =@FOrgID " , new SqlParameter[] { new SqlParameter("@FBatchNo", batchNo), new SqlParameter("@FProductionDate", productionDate), new SqlParameter("@FLabel", label), new SqlParameter("@FOrgID", orgId) }); return(SqlHelper.DataTableToModelList <VOCBucketCountModel>(data)); }
/// <summary> /// 获取某个批号,在销售订单上的VOC名称 /// </summary> /// <param name="batchno"></param> /// <returns></returns> public List <VOCBucketCountModel> GetVocNameListsByICMOBillNo(string billNo) { DataTable data = SqlHelper.ExecuteDataTable(@" select VOCName,cast(sum(FBZTQty)as int) BucketCount from t_BOS_ICMOOrder a join t_BOS_ICMOOrderEntry b on a.fid = b.Fid join SJSEORDList e on e.fid = b.FID_SRC and e.FEntryID = b.FEntryID_SRC where a.FBillNo = @FBillNo group by VOCName ", new SqlParameter[] { new SqlParameter("@FBillNo", billNo) }); return(SqlHelper.DataTableToModelList <VOCBucketCountModel>(data)); }
public IEnumerable <QuerySchemaModel> GetMySchema(int userId) { DataTable data = SqlHelper.ExecuteDataTable(" select * from SJUserQuerySchema where UserId=@UserId; ", new SqlParameter[] { new SqlParameter("@UserId", userId) }); return(SqlHelper.DataTableToModelList <QuerySchemaModel>(data)); }
public IEnumerable <QuerySchemaModel> GetAllSchemaName(int userId) { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJUserQuerySchema where UserId=@UserId", new SqlParameter[] { new SqlParameter("@UserId", userId) }); return(SqlHelper.DataTableToModelList <QuerySchemaModel>(data)); }
//public LabelPrintCommonAdjustmentModel ToModel(DataRow row) //{ // return new LabelPrintCommonAdjustmentModel // { // ID = (int)row["ID"], // OrgID = (string)row["OrgID"], // Label = (string)row["Label"], // ProductionName = (string)row["ProductionName"], // ExpirationMonth = SqlHelper.SetString(row["ExpirationMonth"]), // ExpirationDay = SqlHelper.SetInt(row["ExpirationDay"]), // CbIdentTypeModel = new CbIdentTypeModel { IdentityType =(int)row["IdentityType"] , IdentityTypeDesc = (string)row["IdentityTypeDesc"] } // }; //} #endregion #region 特殊要求界面 public IEnumerable <LabelPrintSpecialRequestModel> GetAllSpecialRequest() { DataTable data = SqlHelper.ExecuteDataTable(" select * from SJPrintCustLabelSpecialRequest ", null); return(SqlHelper.DataTableToModelList <LabelPrintSpecialRequestModel>(data)); }
public IEnumerable <LabelPrintCommonAdjustmentModel> GetAllLabelPrintCommonAdjustment() { DataTable data = SqlHelper.ExecuteDataTable(@" SELECT * FROM SJPrintCustLabelCommonAdjustment ORDER BY ID DESC ; "); return(SqlHelper.DataTableToModelList <LabelPrintCommonAdjustmentModel>(data)); }
/// <summary> /// 获取打印模板字段设置值 /// </summary> public IEnumerable <PrintTemplateRefModel> GetPrintTemplateRef() { DataTable data = SqlHelper.ExecuteDataTable(" SELECT ID,ModuleName,ModuleTable,TemplateFieldName ,TemplateFieldDesc,Example FROM SJPrintTemplateRef ", null); return(SqlHelper.DataTableToModelList <PrintTemplateRefModel>(data)); }
// 查看该用户的所有打印结果记录 public IEnumerable <LabelPrintCurrencyModel> GetPrintResultRecordByUserID(int userID, string pringStatus) { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJLabelPrintResult WHERE UserID=@UserID;", new SqlParameter[] { new SqlParameter("@UserID ", userID) }); return(SqlHelper.DataTableToModelList <LabelPrintCurrencyModel>(data)); }
// 按日期一次性获取打印数据 public IEnumerable <LabelPrintCurrencyModel> GetCurrencyPrintingDataByDate(DateTime date) { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJLabelPrintResult where ProductionDate=@ProductionDate ;", new SqlParameter[] { new SqlParameter("@ProductionDate ", date) }); return(SqlHelper.DataTableToModelList <LabelPrintCurrencyModel>(data)); }
public List <ProductionClassModel> GetAllType() { DataTable data = SqlHelper.ExecuteDataTable("SELECT * FROM SJProductionType ", null); return(SqlHelper.DataTableToModelList <ProductionClassModel>(data)); }
//获取用户模板查询明细 public IEnumerable <QuerySchemaEntryModel> GetQuerySchemaEntryBySchemaId(int schemaId) { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJUserQuerySchemaEntry where SchemaId=@SchemaId ;", new SqlParameter[] { new SqlParameter("@SchemaId ", schemaId) }); return(SqlHelper.DataTableToModelList <QuerySchemaEntryModel>(data)); }
public List <BucketModel> GetAllBucket() { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJPackageBucketInfo ORDER BY FBucketID DESC ", null); return(SqlHelper.DataTableToModelList <BucketModel>(data)); }