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