/// <summary> /// 查询退货分析报表 /// </summary> /// <param name="entity"></param> /// <returns></returns> public List <EntityReturnAnalysisReport> GetReturnAnalysis(EntityReturnAnalysisRQC entity) { List <EntityReturnAnalysisReport> list = new List <EntityReturnAnalysisReport>(); //string sql = string.Format(@"exec prc_report_ReturnAnalysis '{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}','{0}'", // entity.DateBeg, entity.DateEed, entity.Depart1, entity.Depart2, entity.cCusCode1, entity.cCusCode2, entity.cCusDefine11, entity.cCusDefine12, entity.ICategory1, entity.ICategory2, // entity.InvCode1, entity.InvCode2, entity.SumQuantity1, entity.SumQuantity2, entity.SumMoney1, entity.SumMoney2, entity.ReProportion1, entity.ReProportion2); //return this.DB_SqlHelper.ExecuteDataTable(CommandType.Text, sql); string SQL_StoredProcedure = "prc_report_ReturnAnalysis"; SqlParameter[] sp_para = new SqlParameter[4]; sp_para[0] = new SqlParameter("@datebeg", entity.DateBeg); sp_para[1] = new SqlParameter("@dateend", entity.DateEed); //sp_para[2] = new SqlParameter("@Depart1", entity.Depart1); //sp_para[3] = new SqlParameter("@Depart2", entity.Depart2); sp_para[2] = new SqlParameter("@cCusCode", entity.cCusCode); //sp_para[5] = new SqlParameter("@cCusCode2", entity.cCusCode2); //sp_para[6] = new SqlParameter("@cCusDefine11", entity.cCusDefine11); //sp_para[7] = new SqlParameter("@cCusDefine12", entity.cCusDefine12); //sp_para[8] = new SqlParameter("@ICategory1", entity.ICategory1); //sp_para[9] = new SqlParameter("@ICategory2", entity.ICategory2); sp_para[3] = new SqlParameter("@InvCode", entity.InvCode); //sp_para[11] = new SqlParameter("@InvCode2", entity.InvCode2); //sp_para[12] = new SqlParameter("@SumQuantity1", entity.SumQuantity1); // sp_para[13] = new SqlParameter("@SumQuantity2", entity.SumQuantity2); //sp_para[14] = new SqlParameter("@SumMoney1", entity.SumMoney1); //sp_para[15] = new SqlParameter("@SumMoney2", entity.SumMoney2); //sp_para[16] = new SqlParameter("@ReProportion1", entity.ReProportion1); //sp_para[17] = new SqlParameter("@ReProportion2", entity.ReProportion2); DataTable dt = new DataTable(); dt = DB_SqlHelper.ExecuteDataTable(CommandType.StoredProcedure, SQL_StoredProcedure, sp_para); for (int i = 0; i < dt.Rows.Count; i++) { EntityReturnAnalysisReport data = new EntityReturnAnalysisReport(); DataRow dr = dt.Rows[i]; data.cDepCode = dr["cDepCode"].ToString(); data.cDepName = dr["cDepName"].ToString(); data.cCusCode = dr["cCusCode"].ToString(); data.cCusName = dr["cCusName"].ToString(); data.cCusAbbName = dr["cCusAbbName"].ToString(); data.cCusDefine1 = dr["cCusDefine1"].ToString(); data.cInvCode = dr["cInvCode"].ToString(); data.cInvName = dr["cInvName"].ToString(); data.cInvStd = dr["cInvStd"].ToString(); data.cInvCCode = dr["cInvCCode"].ToString(); data.cInvCName = dr["cInvCName"].ToString(); data.cComUnitCode = dr["cComUnitCode"].ToString(); data.cComUnitName = dr["cComUnitName"].ToString(); data.thIQuantity = Convert.ToDecimal(dr["thIQuantity"].ToString()); data.thINatSum = Convert.ToDecimal(dr["thINatSum"].ToString()); data.fhIQuantity = Convert.ToDecimal(dr["fhIQuantity"].ToString()); data.fhINatSum = Convert.ToDecimal(dr["fhINatSum"].ToString()); data.actualQty = Convert.ToDecimal(dr["actualQty"].ToString()); data.actualSum = Convert.ToDecimal(dr["actualSum"].ToString()); //data.percentSum = dr["percentSum"].ToString(); list.Add(data); } return(list); }
public string GetModels(string UserCode, string CipherPassword, int ModelType, string StrAccID, string Act, string Entity, string dModifyDate) { //Entity = System.Web.HttpUtility.UrlDecode(Entity); string plainPassword = DefineEncryptDecrypt.Decrypt(CipherPassword); int AccYear = U8BllBase.GetBeginYear(StrAccID); if (AccYear == 0) { return(ControllerHelp.GetReturnStr(0, string.Format("没有找到账套号{0}", StrAccID))); } ModelsType mt = (ModelsType)ModelType; string msg = ""; switch (mt) { case ModelsType.CurrentStock: // 库存量查询 if (Act == "get") { EntityCurrentStock entity = JsonConvert.DeserializeObject <EntityCurrentStock>(Entity); CurrentStockBll bll = new CurrentStockBll(StrAccID, AccYear, UserCode, plainPassword); List <EntityCurrentStock> list = bll.GetCurrentStock(entity, out msg); return(ControllerHelp.GetReturnStr(string.IsNullOrWhiteSpace(msg) ? 1 : 0, "", list)); } break; case ModelsType.Sale: // 查询销售订单是否存在 1表示不存在,2表示存在 if (Act == "query") { SoMainBll bll = new SoMainBll(StrAccID, AccYear, UserCode, plainPassword); EntitySaleHead entity = JsonConvert.DeserializeObject <EntitySaleHead>(Entity); int num = bll.QuerySale(entity.cSOCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.DispatchList1: //退货单 1表示不存在,2表示存在 if (Act == "query") { DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword); EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity); int num = bll.QueryDispatchList(entity.cDLCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.DispatchList2: //发货单 1表示不存在,2表示存在 if (Act == "query") { DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword); EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity); int num = bll.QueryDispatchList(entity.cDLCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.RdRecord09: // 配送出库单(其他出库单) 1表示不存在,2表示存在 if (Act == "query") { RdRecord09Bll bll = new RdRecord09Bll(StrAccID, AccYear, UserCode, plainPassword); EntityRdRecord09Head entity = JsonConvert.DeserializeObject <EntityRdRecord09Head>(Entity); int num = bll.QueryRdRecord09(entity.cCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.Ap_CloseBill: //收款单(汇款通知单)1表示不存在,2表示存在 if (Act == "query") { Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword); EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity); int num = bll.QueryAp_CloseBill(entity.cVouchID); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.PayAp_CloseBill: //付款单(汇款通知单)1表示不存在,2表示存在 if (Act == "query") { Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword); EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity); int num = bll.QueryAp_CloseBill(entity.cVouchID); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.ReturnAnalysis: //退货分析表查询 if (Act == "get") { ReturnAnalysisBll bll = new ReturnAnalysisBll(StrAccID, AccYear, UserCode, plainPassword); EntityReturnAnalysisRQC entity = JsonConvert.DeserializeObject <EntityReturnAnalysisRQC>(Entity); List <EntityReturnAnalysisReport> list = bll.GetReturnAnalysis(entity); return(ControllerHelp.GetReturnStr(1, "", list)); } break; case ModelsType.Customer: //客户档案 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); EntityCustomer entity = JsonConvert.DeserializeObject <EntityCustomer>(Entity); List <EntityCustomer> customer = bll.GetCustomer(entity.cCusCode); return(ControllerHelp.GetReturnStr(1, "", customer)); } break; case ModelsType.Vendor: //供应商档案 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntityVendor> vendor = bll.GetVendor(); return(ControllerHelp.GetReturnStr(1, "", vendor)); } break; case ModelsType.PurchaseType: //采购类型 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntityPurchaseType> purchasetype = bll.GetPurchaseType(); return(ControllerHelp.GetReturnStr(1, "", purchasetype)); } break; case ModelsType.Inventory: //存货档案 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntityInventory> inventory = new List <EntityInventory>(); if (string.IsNullOrWhiteSpace(dModifyDate)) { inventory = bll.GetInventory(); } else { inventory = bll.GetInventory(Convert.ToDateTime(dModifyDate)); } return(ControllerHelp.GetReturnStr(1, "", inventory)); } break; case ModelsType.WareHouse: //仓库档案(入库仓库) if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntityWareHouse> warehouse = bll.GetWareHouse(); return(ControllerHelp.GetReturnStr(1, "", warehouse)); } break; case ModelsType.rd_Style: //入库类别档案 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <Entityrd_Style> rd_style = bll.Getrd_Style(); return(ControllerHelp.GetReturnStr(1, "", rd_style)); } break; case ModelsType.SettleStyle: //结算方式 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntitySettleStyle> settlestyle = bll.GetSettleStyle(); return(ControllerHelp.GetReturnStr(1, "", settlestyle)); } break; case ModelsType.CustomerProperty: //经营属性 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); string cuscode = Entity; var customer = bll.GetCustomerProperty(cuscode); return(ControllerHelp.GetReturnStr(1, "", customer)); } break; case ModelsType.InventoryPrice: //存货入库含税单价 if (Act == "get") { if (!string.IsNullOrWhiteSpace(Entity)) { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); EntityInventoryPrice entity = JsonConvert.DeserializeObject <EntityInventoryPrice>(Entity); var inventoryPrice = bll.GetInventoryPrice(entity.cVenCode, entity.cInvCode); return(ControllerHelp.GetReturnStr(1, "", inventoryPrice)); } } break; case ModelsType.PO_Pomain: //采购订单 if (Act == "query") { PO_PomainBll bll = new PO_PomainBll(StrAccID, AccYear, UserCode, plainPassword); EntityPO_Pomain entity = JsonConvert.DeserializeObject <EntityPO_Pomain>(Entity); int num = bll.GetPO_Pomain(entity.cPOID); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.RdRecord01: //采购入库单 if (Act == "query") { RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword); EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity); int num = bll.GetRdRecord01(entity.cCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.Ap_Vouch: //其他应付单 if (Act == "query") { Ap_VouchBll bll = new Ap_VouchBll(StrAccID, AccYear, UserCode, plainPassword); EntityAp_VouchHead entity = JsonConvert.DeserializeObject <EntityAp_VouchHead>(Entity); int num = bll.GetAp_Vouch(entity.cVouchID); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; } return(ControllerHelp.GetReturnStr(0, "GetModels(查询)中没有找到可对应的操作项")); }