public bool GetT_MenuListByPage(ref List <T_MenuInfo> modelList, UserInfo user, T_MenuInfo t_menu, ref DividPage page, ref string strError) { T_MENU_Func tfunc = new T_MENU_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_menu, ref page, ref strError)); }
/// <summary> /// 获取检验通知书导出数据 /// </summary> /// <param name="strErrMsg"></param> /// <returns></returns> public bool GetQualityExportListByPage(ref List <QuanlityExportInfo> modelList, QuanlityExportInfo model, ref DividPage page, UserInfo user, ref string strError) { if (page == null) { page = new DividPage(); } List <QuanlityExportInfo> lstModel = new List <QuanlityExportInfo>(); try { using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_GetQualityExportInfo", GetFilterSql(model, user), "*", "Order By CreateDate Desc")) { while (dr.Read()) { lstModel.Add(GetQualityExport_ModelFromDataReader(dr)); } } modelList = lstModel; return(true); } catch (Exception ex) { strError = ex.Message; return(false); } finally { } }
public bool GetT_AreaListByPage(ref List <T_AreaInfo> modelList, UserInfo user, T_AreaInfo t_area, ref DividPage page, ref string strError) { T_Area_Func tfunc = new T_Area_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_area, ref page, ref strError)); }
public bool GetT_PickRuleListByPage(ref List <T_PickRuleInfo> modelList, UserInfo user, T_PickRuleInfo t_pickrule, ref DividPage page, ref string strError) { T_PickRule_Func tfunc = new T_PickRule_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_pickrule, ref page, ref strError)); }
public bool GetT_RetentionDetailChangeListByPage(ref List <T_RetentionDetailChangeInfo> modelList, UserInfo user, T_RetentionDetailChangeInfo t_retentiondetailchange, ref DividPage page, ref string strError) { T_RetentionDetailChange_Func tfunc = new T_RetentionDetailChange_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_retentiondetailchange, ref page, ref strError)); }
public static bool GetPrintRecordListByPage(ref List <Barcode_Model> modelList, Barcode_Model model, ref DividPage page, ref string strError) { return(WMSWebService.service.GetPrintRecordListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError)); }
public bool GetProfitLossListByPage(ref List <ProfitLossInfo> modelList, ProfitLossInfo model, ref DividPage page, UserInfo user, ref string strError) { List <ProfitLossInfo> lstModel = new List <ProfitLossInfo>(); try { using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_ProfitLoss", GetFilterSql(model, user), "*", "Order By CheckID Desc, AreaNo, MaterialNo, AccountQty Desc, ScanQty Desc")) { while (dr.Read()) { lstModel.Add(GetModelFromDataReader(dr)); } } modelList = lstModel; return(true); } catch (Exception ex) { strError = ex.Message; return(false); } finally { } }
public bool GetT_OutStockCreateListByPage(ref List <T_OutStockCreateInfo> modelList, UserInfo user, T_OutStockCreateInfo t_outstockdetail, ref DividPage page, ref string strError) { T_OutStockCreate_Func tfunc = new T_OutStockCreate_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_outstockdetail, ref page, ref strError)); }
public bool GetQualityDetailListByPage(ref List <DeliveryReceiveDetail_Model> modelList, DeliveryReceiveDetail_Model model, ref DividPage page, UserInfo user, ref string strError) { if (page == null) { page = new DividPage(); } List <DeliveryReceiveDetail_Model> lstModel = new List <DeliveryReceiveDetail_Model>(); try { using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_GETQUALITYDETAILINFO", GetFilterSql(model, user), "*", "Order By rowno Asc")) { while (dr.Read()) { lstModel.Add(GetDeliveryReceiveDetail_ModelFromDataReader(dr)); } } modelList = lstModel; return(true); } catch (Exception ex) { strError = ex.Message; return(false); } finally { } }
public bool GetT_ContactCompanyListByPage(ref List <T_ContactCompanyInfo> modelList, UserInfo user, T_ContactCompanyInfo t_contactcompany, ref DividPage page, ref string strError) { T_ContactCompany_Func tfunc = new T_ContactCompany_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_contactcompany, ref page, ref strError)); }
public bool GetT_DepInterfaceListByPage(ref List <T_DepInterfaceInfo> modelList, UserInfo user, T_DepInterfaceInfo t_depinterface, ref DividPage page, ref string strError) { T_DepInterface_Func tfunc = new T_DepInterface_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_depinterface, ref page, ref strError)); }
public bool GetT_SupplierAddressListByPage(ref List <T_SupplierAddressInfo> modelList, UserInfo user, T_SupplierAddressInfo t_supplieraddress, ref DividPage page, ref string strError) { T_SupplierAddress_Func tfunc = new T_SupplierAddress_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_supplieraddress, ref page, ref strError)); }
public static bool GetCensorshipDetailByPage(ref List <DeliveryReceiveDetail_Model> lstDetail, DeliveryReceiveDetail_Model queryDetail, ref DividPage page, ref string strError) { return(WMSWebService.service.GetQualityDetailListByPage(ref lstDetail, queryDetail, ref page, Common_Var.CurrentUser, ref strError)); }
public bool GetT_QualityChangeDetailListByPage(ref List <T_QualityChangeDetailInfo> modelList, UserInfo user, T_QualityChangeDetailInfo t_qualitychangedetail, ref DividPage page, ref string strError) { T_QualityChangeDetail_Func tfunc = new T_QualityChangeDetail_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_qualitychangedetail, ref page, ref strError)); }
public static bool GetStockDetailListByPage(ref List <Stock_Model> modelList, Stock_Model model, ref DividPage page, ref string strError) { return(WMSWebService.service.GetStockDetailListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError)); }
public bool GetT_TeamListByPage(ref List <T_Team> modelList, UserInfo user, T_Team t_customer, ref DividPage page, ref string strError) { T_Team_Func tfunc = new T_Team_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_customer, ref page, ref strError)); }
public static bool GetReceiveTransListByPage(ref List <ReceiveTransInfo> modelList, ReceiveTransInfo model, ref DividPage page, ref string strError) { return(WMSWebService.service.GetReceiveTransListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError)); }
public bool QueryFastInList(Task_Model taskModel, string BeginTime, string EndTime, ref DividPage dividpage, ref List <Task_Model> lsttask, ref string strErrMsg) { if (dividpage == null) { dividpage = new DividPage(); } lsttask = new List <Task_Model>(); try { using (SqlDataReader dr = Common_DB.QueryByDividPage(ref dividpage, "v_queryfastinlist", GetFilterSql(taskModel, BeginTime, EndTime), "*", "Order by CREATEDATETIME desc")) { while (dr.Read()) { lsttask.Add(GetModelFromDataReader(dr)); } dividpage.CurrentPageRecordCounts = lsttask.Count; } if (lsttask == null || lsttask.Count == 0) { strErrMsg = "没有快速入库单信息!"; return(false); } else { return(true); } } catch (Exception ex) { strErrMsg = ex.Message; return(false); } }
public bool GetT_OutTaskListByPage(ref List <T_OutStockTaskInfo> modelList, UserInfo user, T_OutStockTaskInfo t_task, ref DividPage page, ref string strError) { T_OutStockTask_Func tfunc = new T_OutStockTask_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_task, ref page, ref strError)); }
/// <summary> /// 重写获取数据列表方法 /// 先从缓存读取,读取异常或者失败从数据库读取 /// </summary> /// <param name="user"></param> /// <param name="model"></param> /// <param name="page"></param> /// <returns></returns> public override List <T_RuleAllInfo> GetModelListByPage(UserModel user, T_RuleAllInfo model, ref DividPage page, string condition) { //object obj = ExampleCache.GetExampleCache().Get("ruleall"); ////设置缓存 //if (obj != null) //{ // return (List<T_RuleAllInfo>)obj; //} List <T_RuleAllInfo> modelList = base.GetModelListByPage(user, model, ref page, condition); //ExampleCache.GetExampleCache().Set("ruleall", modelList); return(modelList); }
public bool GetStockDetailListByPage(ref List <Stock_Model> modelList, Stock_Model model, ref DividPage page, UserInfo user, ref string strError) { if (page == null) { page = new DividPage(); } List <Stock_Model> lstModel = new List <Stock_Model>(); try { using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_StockDetail", GetFilterSql(model, user), "*", "Order By CreateTime desc,WarehouseNo,HouseNo,AreaNo,MaterialNo,Qty")) { while (dr.Read()) { lstModel.Add(GetModelFromDataReader(dr)); } } modelList = lstModel; return(true); } catch (Exception ex) { strError = ex.Message; return(false); } finally { } }
public static bool GetWarehouseListByPage(ref List <WarehouseInfo> modelList, WarehouseInfo model, ref DividPage page, ref string strError) { return(WMSWebService.service.GetWarehouseListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError)); }
private void GetQueryData() { ChensControl.DividPage clientPage = chensPage1.dDividPage; DividPage _serverMainPage = new DividPage(); Common.Common_Func.GetServerPageFromClientPage(ref _serverMainPage, clientPage); Task_Model TM = new Task_Model(); if (txt_djno.Text.Trim().Length > 0)//单据号 { TM.VoucherNo = txt_djno.Text.Trim(); } if (txt_mateducment.Text.Trim().Length > 0)//物料凭证号 { TM.MaterialDoc = txt_mateducment.Text.Trim(); } if (txt_ontaskno.Text.Trim().Length > 0)//上架任务号 { TM.TaskNo = txt_ontaskno.Text.Trim(); } if (txt_peo.Text.Trim().Length > 0)//制单人 { TM.CreateUserNo = txt_peo.Text.Trim(); } if (cmb_state.Text.Trim().Length > 0)//状态 { TM.TaskStatus = (int)cmb_state.SelectedValue; } string BeginTime = "", EndTime = ""; if (begintime.Checked) { BeginTime = begintime.Value.ToString("yyyy-MM-dd"); } if (endtime.Checked) { EndTime = endtime.Value.ToString("yyyy-MM-dd"); } List <Task_Model> lsttask = new List <Task_Model>(); string strErr = ""; bindingSource1.DataSource = null; try { bool bResult = WMS.Common.WMSWebService.service.QueryFastInList(TM, BeginTime, EndTime, ref _serverMainPage, ref lsttask, ref strErr); Common.Common_Func.GetClientPageFromServerPage(_serverMainPage, ref clientPage); chensPage1.ShowPage(); bindingSource1.DataSource = lsttask; if (bResult == false) { if (strErr.Equals("没有快速入库单信息!")) { return; } else { MessageBox.Show(strErr); return; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static bool GetMenuListByPage(ref List <MenuInfo> modelList, MenuInfo model, ref DividPage page, ref string strError) { //MenuInfo[] modelArray = modelList.ToArray(); //bool bResult = WMSWebService.service.GetMenuListByPage(ref modelArray, model, ref page, Common_Var.CurrentUser, ref strError); //if (bResult) modelList = modelArray.ToList(); //return bResult; return(WMSWebService.service.GetMenuListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError)); }
public bool GetT_InTaskDetailsListByPage(ref List <T_InStockTaskDetailsInfo> modelList, UserInfo user, T_InStockTaskDetailsInfo t_taskdetails, ref DividPage page, ref string strError) { T_InTaskDetails_Func tfunc = new T_InTaskDetails_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_taskdetails, ref page, ref strError)); }
public static bool GetPreparationListByPage(ref List <Preparation> modelList, Preparation model, ref DividPage page, ref string strError) { return(WMSWebService.service.GetPreparationListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError)); }
public bool GetCheckTransListByPage(ref List<CheckTransInfo> modelList, CheckTransInfo model, ref DividPage page, UserInfo user, ref string strError) { List<CheckTransInfo> lstModel = new List<CheckTransInfo>(); try { using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_CheckTrans", GetFilterSql(model, user), "*", "Order By CheckID Desc,ID Desc")) { while (dr.Read()) { lstModel.Add(GetModelFromDataReader(dr)); } } modelList = lstModel; return true; } catch (Exception ex) { strError = ex.Message; return false; } finally { } }
public static bool GetBuildingListByPage(ref List <Building> modelList, Building model, ref DividPage page, ref string strError) { return(WMSWebService.service.GetBuildingListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError)); }
public bool GetCheckInfo(Check_Model taskmo, ref DividPage dividpage, ref List <Check_Model> lsttask, ref string strErrMsg) { Check_DB db = new Check_DB(); return(db.GetCheckInfo(taskmo, ref dividpage, ref lsttask, ref strErrMsg)); }
public bool GetT_WareHouseListByPage(ref List <T_WareHouseInfo> modelList, UserInfo user, T_WareHouseInfo t_warehouse, ref DividPage page, ref string strError) { T_WareHouse_Func tfunc = new T_WareHouse_Func(); return(tfunc.GetModelListByPage(ref modelList, user, t_warehouse, ref page, ref strError)); }