public string saveForm(string sdt, string FormCode, string FormName, string NameSpace, string FrmUpName, string OrderID, int iHide, int iNoUse, int iSystem, int iUse) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.saveForm(Cls序列化.DeserializeDataTable(ClsDES.Decrypt(sdt)), ClsDES.Decrypt(FormCode), ClsDES.Decrypt(FormName), ClsDES.Decrypt(NameSpace), ClsDES.Decrypt(FrmUpName), ClsDES.Decrypt(OrderID), iHide, iNoUse, iSystem, iUse))); }
public string saveDefine1all(string vchrUid, string sUserName, string Name, string Text, string ClickedItemName, string ClickedItemText) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.saveDefine1all(ClsDES.Decrypt(vchrUid), ClsDES.Decrypt(sUserName), ClsDES.Decrypt(Name), ClsDES.Decrypt(Text), ClsDES.Decrypt(ClickedItemName), ClsDES.Decrypt(ClickedItemText)))); }
public ReturnOrderStaList GetOrderStaList(string JSon) { try { string OrderDayNum = string.Empty; string OrderDaySum = string.Empty; string UserID = string.Empty; string ResellerID = string.Empty; string BeginDate = string.Empty; string EndDate = string.Empty; string date_now = string.Empty; string nextdate = string.Empty; string strsql = string.Empty; string CompID = string.Empty; int fordate_start_month = 0; int fordate_end_month = 0; //ReturnOrderStaList returnorderstalist = new ReturnOrderStaList(); List <OrderYearList> orderyearlist = new List <OrderYearList>(); #region 取出JSon的值 JsonData JInfo = JsonMapper.ToObject(JSon); #endregion //判断传入的参数是否异常 if (JInfo.Count <= 0 || JInfo["UserID"].ToString() == "" || JInfo["ResellerID"].ToString() == "" || JInfo["BeginDate"].ToString() == "" || JInfo["EndDate"].ToString() == "") { return new ReturnOrderStaList() { Result = "F", Description = "参数异常" } } ; UserID = JInfo["UserID"].ToString(); ResellerID = JInfo["ResellerID"].ToString(); BeginDate = JInfo["BeginDate"].ToString(); EndDate = JInfo["EndDate"].ToString(); date_now = DateTime.Now.ToString("yyyy-MM-dd"); strsql = "select UserID from SYS_CompUser where CType = '2' and DisID = '" + ResellerID + "' and UserID = '" + UserID + "'"; strsql += " and isnull(dr,0) = 0"; UserID = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), ""); if (UserID == "")//判断用户是否存在 { return new ReturnOrderStaList() { Result = "F", Description = "未找到用户信息" } } ; strsql = "select CompID from BD_Distributor where ID = '" + ResellerID + "' and isnull(dr,0) = 0"; CompID = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), ""); if (CompID == "")//判断此经销商是否存在 { return new ReturnOrderStaList() { Result = "F", Description = "未找到经销商信息" } } ; nextdate = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"); //今日订单数 strsql = "select count(*) from DIS_Order where otype <> '9' and isnull(dr,0) = 0 and CompID = '" + CompID + "' "; strsql += "and DisID = '" + ResellerID + "' and OState in (2,4,5) and createdate >= '" + date_now + "'"; strsql += " and createdate < '" + nextdate + "'"; OrderDayNum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0"); //今日订单总额 strsql = "SELECT SUM(sumAmount) as sumAmount FROM [dbo].[MonthSaleRpt_view] where DisID=" + ResellerID + " and CompID=" + CompID + " and CreateDate>='" + date_now + "'"; //之前版本的sql //重新自己写得SQL //strsql = "select sum(TotalAmount) from DIS_Order where otype <> '9' and isnull(dr,0) = 0 and CompID = '" + CompID + "' "; //strsql += "and DisID = '" + ResellerID + "' and OState in (2,4,5) and createdate >= '" + date_now + "'"; OrderDaySum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0.00"); //考虑跨年的情况 DateTime date_start = DateTime.Parse(BeginDate); int year_begin = date_start.Year; DateTime date_end = DateTime.Parse(EndDate); int year_end = date_end.Year; for (int i = year_begin; i <= year_end; i++) { OrderYearList orderyear = new OrderYearList(); orderyear.Year = i.ToString(); if (year_begin == year_end) //没跨年获取每月数据的循环开始月与结束月 { fordate_start_month = date_start.Month; fordate_end_month = date_end.Month; } else if (i == year_begin)//跨年且年度等于开始时间的年度,循环开始月份是开始时间的月份,结束月份是12月 { fordate_start_month = date_start.Month; fordate_end_month = 12; } else if (i != year_end)//跨年且年度不等于开始和结束时间的年度,循环开始月份是1月,结束月份是12月 { fordate_start_month = 1; fordate_end_month = 12; } else//跨年且年度等于结束时间年度,循环开始月份是1月,结束月份是结束时间的月份 { fordate_start_month = 1; fordate_end_month = date_end.Month; } List <OrderMonthList> ordermonthlist = new List <OrderMonthList>(); for (int month = fordate_start_month; month <= fordate_end_month; month++) { OrderMonthList ordermonth = new OrderMonthList(); ordermonth.OrderMonth = month.ToString(); DateTime month_fristday = new DateTime(i, month, 1); //当月第一天日期 //DateTime month_lastday = month_fristday.AddMonths(1).AddDays(-1);//当月最后一天 DateTime month_lastday = month_fristday.AddMonths(1); //下个月第一天 //本月订单数 strsql = "select count(*) from DIS_Order where otype <> '9' and isnull(dr,0) = 0 and CompID = '" + CompID + "' "; strsql += "and DisID = '" + ResellerID + "' and OState in (2,4,5) and createdate >= '" + month_fristday.ToString("yyyy-MM-dd") + "'"; strsql += " and createdate < '" + month_lastday.ToString("yyyy-MM-dd") + "' "; ordermonth.OrderMonthNum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0"); //本月订单总额 strsql = "SELECT SUM(sumAmount) as sumAmount FROM [dbo].[MonthSaleRpt_view] where DisID=" + ResellerID + " and CompID=" + CompID + " and CreateDate>='" + month_fristday.ToString("yyyy-MM-dd") + "' "; strsql += " and createdate < '" + month_lastday.ToString("yyyy-MM-dd") + "'"; ordermonth.OrderMonthSum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0.00"); //本月退款单 strsql = "select count(*) from dis_order a inner join dis_orderreturn b on "; strsql += " a.id = b.orderid where a.otype <>'9' and isnull(a.dr,0) = 0 and isnull(b.dr,0) = 0"; strsql += " and a.ostate = '7' and b.auditdate>= '" + month_fristday.ToString("yyyy-MM-dd") + "'"; strsql += " and b.auditdate < '" + month_lastday.ToString("yyyy-MM-dd") + "' and a.CompID = '" + CompID + "'"; strsql += " and a.disid = '" + ResellerID + "'"; ordermonth.OrderOutMonthNum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0"); //本月退款额 strsql = "select sum(a.PayedAmount) from dis_order a inner join dis_orderreturn b on "; strsql += " a.id = b.orderid where a.otype <>'9' and isnull(a.dr,0) = 0 and isnull(b.dr,0) = 0"; strsql += " and a.ostate = '7' and b.auditdate>= '" + month_fristday.ToString("yyyy-MM-dd") + "'"; strsql += " and b.auditdate < '" + month_lastday.ToString("yyyy-MM-dd") + "' and a.CompID = '" + CompID + "'"; strsql += " and a.disid = '" + ResellerID + "'"; ordermonth.OrderOutMonthSum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0.00"); ordermonthlist.Add(ordermonth); } orderyear.OrderMonthList = ordermonthlist; orderyearlist.Add(orderyear); } return(new ReturnOrderStaList() { Result = "T", Description = "返回正确", OrderDayNum = OrderDayNum, OrderDaySum = OrderDaySum, OrderYearList = orderyearlist }); } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetResellerOrderStaList:" + JSon); return(new ReturnOrderStaList() { Result = "F", Description = "参数异常" }); } }
public static void ImportReturnOrder(DataRow[] rows) { string id = string.Empty; try { List <string> values = new List <string>(); values.Add("*"); Dictionary <string, string> keys = new Dictionary <string, string>(); keys.Add("cDefine14", ClsSystem.gnvl(rows[0]["YYBM"], "") + "-" + ClsSystem.gnvl(rows[0]["PSDBM"], "") + "-" + ClsSystem.gnvl(rows[0]["THDBH"], "")); DataSet ds = SqlHelper.Query(Program.ConnectionString, "DispatchList", values, keys, null); if (ds.Tables.Count > 0 & ds.Tables[0].Rows.Count > 0) { return; } //表头 DispatchList dispatchList = new DispatchList(); dispatchList.DLID = "10000" + (GetHeadID() + 1).ToString(); //查询DispatchList中cDLCode最大值 dispatchList.cDLCode = GetcDLCodeMax(); id = dispatchList.DLID; string cCusCode = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cCusCode from Customer_extradefine with(nolock) where ccdefine1='" + ClsSystem.gnvl(rows[0]["YYBM"], "") + "'", Program.ConnectionString), ""); string cpersoncode = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cCusPPerson from customer with(nolock) where cCusCode='" + cCusCode + "'", Program.ConnectionString), ""); dispatchList.cDepCode = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cDepCode from Person with(nolock) where cpersoncode='" + cpersoncode + "'", Program.ConnectionString), ""); dispatchList.cPersonCode = cpersoncode; dispatchList.cCusCode = cCusCode; dispatchList.cCusName = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cCusName from customer with(nolock) where cCusCode='" + cCusCode + "'", Program.ConnectionString), ""); dispatchList.cDefine11 = ClsSystem.gnvl(rows[0]["YYBM"], ""); dispatchList.cDefine12 = ClsSystem.gnvl(rows[0]["PSDBM"], ""); dispatchList.cDefine13 = ClsSystem.gnvl(rows[0]["PSDZ"], ""); dispatchList.cDefine14 = ClsSystem.gnvl(rows[0]["YYBM"], "") + "-" + ClsSystem.gnvl(rows[0]["PSDBM"], "") + "-" + ClsSystem.gnvl(rows[0]["THDBH"], ""); //制单人 dispatchList.cMaker = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cUser_Name from ua_user with(nolock) where cUser_Id='" + Program.userCode + "'", Program.ConnectionString), ""); dispatchList.WriteToSql(); //表体 int count = rows.Length; for (int i = 0; i < count; ++i) { decimal iTaxRate = 17M; string ZXSPBM = rows[i]["ZXSPBM"].ToString(); //2016-12-14 TODO: 修改数量 //decimal iQuantity = -(Public.GetNum(rows[i]["THSL"]) * Public.GetNum(rows[i]["BZNHSL"]));//数量 decimal iQuantity = -Public.GetNum(rows[i]["THSL"]); //数量 decimal iTaxUnitPrice = 0; //原币含税单价 //统编代码查找存货编码 string cinvcode = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cinvcode from inventory_extradefine where cidefine1='" + ZXSPBM + "'", Program.ConnectionString), ""); string sql = " select isnull(iInvNowCost,0) from SA_CusUPrice where cInvCode ='" + cinvcode + "' and cCusCode ='" + cCusCode + "' and dStartDate =(select MAX(dStartDate) from SA_CusUPrice where cinvcode='" + cinvcode + "' and cCusCode ='" + cCusCode + "')"; iTaxUnitPrice = Public.GetNum(rows[i]["THDJ"]); //iTaxUnitPrice = Public.GetNum(ClsSystem.gnvl(SqlAccess.ExecuteScalar(sql, Program.ConnectionString), "0")); //if (iTaxUnitPrice == 0) //{ // sql = " select iUPrice1 from SA_InvUPrice where cInvCode ='" + cinvcode + // "' and dStartDate =(select MAX(dStartDate) from SA_InvUPrice where cInvCode ='" + cinvcode + "')"; // iTaxUnitPrice = Public.GetNum(ClsSystem.gnvl(SqlAccess.ExecuteScalar(sql, Program.ConnectionString), "0")); //} decimal iSum = Public.GetNum(Public.ChinaRound(iTaxUnitPrice * iQuantity, 2)); //原币含税金额 decimal iUnitPrice = Public.ChinaRound(iTaxUnitPrice / (1M + iTaxRate / 100M), 4); //原币无税单价 decimal iMoney = Public.ChinaRound(iSum / (1M + iTaxRate / 100M), 2); //原币无税金额 decimal iTax = Public.ChinaRound(iSum - iMoney, 2); //原币税额 decimal iNatUnitPrice = Public.ChinaRound(iUnitPrice * 1, 4); //本币无税单价 decimal iNatSum = Public.ChinaRound(iSum * 1, 4); //本币价税合计 decimal iNatMoney = Public.ChinaRound(iNatSum / (1 + iTaxRate / 100M), 2); //本币无税金额 decimal iNatTax = Public.ChinaRound(iNatSum - iNatMoney, 2); //本币税额 DispatchLists dispatchLists = new DispatchLists(); dispatchLists.AutoID = (GetBodyID() + i + 1).ToString(); dispatchLists.DLID = dispatchList.DLID; //在DispatchLists_extradefine表中查询 dispatchLists.iDLsID = GetiDLsIDCodeMax().ToString(); //通过存货编码查找仓库编码 dispatchLists.cWhCode = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cDefWareHouse from Inventory where cInvCode='" + cinvcode + "'", Program.ConnectionString), ""); dispatchLists.cInvCode = cinvcode; dispatchLists.cInvName = Getcinvname(cinvcode); dispatchLists.iQuantity = iQuantity.ToString(); dispatchLists.iNum = dispatchLists.iQuantity; dispatchLists.iSettleQuantity = "0"; dispatchLists.iQuotedPrice = rows[i]["THDJ"].ToString(); dispatchLists.iUnitPrice = iUnitPrice.ToString(); dispatchLists.iTaxUnitPrice = iTaxUnitPrice.ToString(); dispatchLists.iMoney = iMoney.ToString(); dispatchLists.iTax = iTax.ToString(); dispatchLists.iSum = iSum.ToString(); dispatchLists.iNatUnitPrice = iNatUnitPrice.ToString(); dispatchLists.iNatMoney = iNatMoney.ToString(); dispatchLists.iNatTax = iNatTax.ToString(); dispatchLists.iNatSum = dispatchLists.iSettleNum = iNatSum.ToString(); dispatchLists.cBatch = rows[i]["SCPH"].ToString(); dispatchLists.cDefine28 = ZXSPBM; dispatchLists.cDefine29 = ClsSystem.gnvl(rows[i]["THDBH"], ""); dispatchLists.cDefine30 = ClsSystem.gnvl(rows[i]["CGJLDW"], ""); dispatchLists.cDefine32 = ClsSystem.gnvl(rows[i]["PSDBM"], ""); dispatchLists.cDefine33 = ClsSystem.gnvl(rows[i]["PSDZ"], ""); dispatchLists.cUnitID = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cSAComUnitCode from Inventory a with(nolock) where cinvcode='" + cinvcode + "'", Program.ConnectionString), ""); //计量单位编码 dispatchLists.dMDate = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select dMDate from CurrentStock where cInvCode='" + cinvcode + "' and cBatch='" + rows[i]["SCPH"].ToString() + "'", Program.ConnectionString), ""); //根据CurrentStock表按照批次号查找生产日期和失效日期 dispatchLists.dvDate = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select dvDate from CurrentStock where cInvCode='" + cinvcode + "' and cBatch = '" + rows[i]["SCPH"].ToString() + "'", Program.ConnectionString), ""); dispatchLists.cExpirationdate = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cExpirationdate from CurrentStock where cInvCode='" + cinvcode + "' and cBatch = '" + rows[i]["SCPH"].ToString() + "'", Program.ConnectionString), ""); dispatchLists.irowno = (i + 1).ToString(); dispatchLists.WriteToSql(); } } catch (Exception ex) { Dictionary <string, string> keys = new Dictionary <string, string>(); keys.Add("DLID", id); SqlHelper.Delete(Program.ConnectionString, "DispatchList", keys); SqlHelper.Delete(Program.ConnectionString, "DispatchLists", keys); throw ex; } }
public ReturnOrderSta GetOrderSta(string JSon) { try { string UserID = string.Empty; string ResellerID = string.Empty; string BeginDate = string.Empty; string EndDate = string.Empty; string BeginDate_Return = string.Empty; string EndDate_Return = string.Empty; string OrderNum = string.Empty; string OrderSum = string.Empty; string OrderOutNum = string.Empty; string OrderOutSum = string.Empty; string CompID = string.Empty; string strsql = string.Empty; #region 取出JSon的值 JsonData JInfo = JsonMapper.ToObject(JSon); #endregion //判断传入的参数是否异常 if (JInfo.Count <= 0 || JInfo["UserID"].ToString() == "" || JInfo["ResellerID"].ToString() == "" || JInfo["BeginDate"].ToString() == "" || JInfo["EndDate"].ToString() == "") { return new ReturnOrderSta() { Result = "F", Description = "参数异常" } } ; //传入的参数赋值 UserID = JInfo["UserID"].ToString(); ResellerID = JInfo["ResellerID"].ToString(); BeginDate = JInfo["BeginDate"].ToString(); EndDate = JInfo["EndDate"].ToString(); strsql = "select UserID from SYS_CompUser where CType = '2' and DisID = '" + ResellerID + "' and UserID = '" + UserID + "'"; strsql += " and isnull(dr,0) = 0"; UserID = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), ""); if (UserID == "")//判断用户是否存在 { return new ReturnOrderSta() { Result = "F", Description = "未找到用户信息" } } ; strsql = "select CompID from BD_Distributor where ID = '" + ResellerID + "' and isnull(dr,0) = 0"; CompID = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), ""); if (CompID == "")//判断此经销商是否存在 { return new ReturnOrderSta() { Result = "F", Description = "未找到经销商信息" } } ; //查询期间的订单总数 DateTime date_end = DateTime.Parse(EndDate); date_end = date_end.AddDays(1); strsql = "select count(*) from DIS_Order where createdate >= '" + BeginDate + "' and createdate < '" + date_end.ToString("yyyy-MM-dd") + "' "; strsql += " and DisID = '" + ResellerID + "' and CompID = '" + CompID + "' and OState in (2,4,5) "; strsql += " and isnull(dr,0) = 0 and otype <> '9'"; OrderNum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0"); //查询期间的订单总额 strsql = "SELECT SUM(sumAmount) as sumAmount FROM [dbo].[MonthSaleRpt_view] where CreateDate>='" + BeginDate + "' and "; strsql += " createdate < '" + date_end.ToString("yyyy-MM-dd") + "' and DisID=" + ResellerID + " and CompID=" + CompID + " and OState <>7"; //strsql += " and createdate < '" + date_end.ToString("yyyy-MM-dd") + "'"; OrderSum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0.00"); //查询期间退货单总数 strsql = "select count(*) from dis_order a inner join dis_orderreturn b on "; strsql += " a.id = b.orderid where b.auditdate>= '" + BeginDate + "' "; strsql += " and b.auditdate < '" + date_end.ToString("yyyy-MM-dd") + "' and a.disid = '" + ResellerID + "' "; strsql += " and a.ostate = '7' and a.CompID = '" + CompID + "'"; strsql += " and isnull(a.dr,0) = 0 and isnull(b.dr,0) = 0 and a.otype <>'9'"; OrderOutNum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0"); //查询期间退款总额 strsql = "select sum(a.PayedAmount) from dis_order a inner join dis_orderreturn b on "; strsql += " a.id = b.orderid where b.auditdate>= '" + BeginDate + "' "; strsql += " and b.auditdate < '" + date_end.ToString("yyyy-MM-dd") + "' and a.disid = '" + ResellerID + "' "; strsql += " and a.ostate = '7' and a.CompID = '" + CompID + "'"; strsql += " and isnull(a.dr,0) = 0 and isnull(b.dr,0) = 0 and a.otype <>'9' "; OrderOutSum = ClsSystem.gnvl(SqlAccess.ExecuteScalar(strsql, SqlHelper.LocalSqlServer), "0.00"); return(new ReturnOrderSta()//返回参数 { Result = "T", Description = "返回正确", BeginDate = BeginDate, EndDate = EndDate, OrderNum = OrderNum, OrderSum = OrderSum, OrderOutNum = OrderOutNum, OrderOutSum = OrderOutSum }); } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetResellerOrderSta:" + JSon); return(new ReturnOrderSta() { Result = "F", Description = "参数异常" }); } }
/// <summary> /// 查看是否启用微信支付或者支付宝支付 /// </summary> public ResultPayInfo GetPayInfo(string JSon, string version) { string disID = string.Empty; string UserID = string.Empty; string OrderType = string.Empty; string ReceiptNo = string.Empty; string PayPrice = string.Empty; string PayIDJSon = string.Empty; string partner = string.Empty; string seller = string.Empty; string private_key = string.Empty; string subject = string.Empty; //提示内容 string GoodsName = string.Empty; //订单所有商品的名称 string OrderNumberJSon = string.Empty; //订单支付流水号的json string OrderNumber = string.Empty; //订单支付流水号 string orderInfo = string.Empty; //订单信息 string OrderCode = string.Empty; //企业订单号 DataTable dt_order = null; Hi.BLL.BD_Distributor bll_dis = new Hi.BLL.BD_Distributor(); Hi.BLL.BD_Company bll_comp = new Hi.BLL.BD_Company(); Hi.BLL.DIS_Order bll_order = new Hi.BLL.DIS_Order(); ResultPayInfo payinfo = new ResultPayInfo(); Common comm = new Common(); try { #region//JSon取值 JsonData JInfo = null; JInfo = JsonMapper.ToObject(JSon); if (JInfo.Count > 0 && JInfo["UserID"].ToString().Trim() != "" && JInfo["ResellerID"].ToString().Trim() != "" && JInfo["OrderType"].ToString().Trim() != "" && JInfo["PayPrice"].ToString().Trim() != "" && JInfo["PayIDJson"].ToString().Trim() != "") { UserID = JInfo["UserID"].ToString(); disID = JInfo["ResellerID"].ToString(); OrderType = JInfo["OrderType"].ToString(); PayPrice = JInfo["PayPrice"].ToString(); PayIDJSon = JInfo["PayIDJson"].ToString(); } else { return(new ResultPayInfo() { Result = "F", Description = "参数异常" }); } if (OrderType == "0") { if (JInfo["ReceiptNo"].ToString().Trim() != "") { ReceiptNo = JInfo["ReceiptNo"].ToString(); } else { return(new ResultPayInfo() { Result = "F", Description = "参数异常" }); } } #endregion //判断登录信息是否正确 Hi.Model.SYS_Users user = new Hi.Model.SYS_Users(); if (!new Common().IsLegitUser(int.Parse(UserID), out user, 0, int.Parse(disID == "" ? "0" : disID))) { return new ResultPayInfo() { Result = "F", Description = "用户异常" } } ; //判断经销商信息是否异常 Hi.Model.BD_Distributor dis = bll_dis.GetModel(Convert.ToInt32(disID)); if (dis == null || dis.dr == 1 || dis.AuditState == 0 || dis.IsEnabled == 0) { return new ResultPayInfo() { Result = "F", Description = "经销商异常" } } ; //判断经销商对应的核心企业是否异常 Hi.Model.BD_Company comp = bll_comp.GetModel(dis.CompID); if (comp == null || comp.dr == 1 || comp.AuditState == 0 || comp.IsEnabled == 0) { return new ResultPayInfo() { Result = "F", Description = "核心企业异常" } } ; //判断此订单的信息是否异常,是否可支付 //根据订单号,取出订单数据放入dt中 if (OrderType == "0") { dt_order = bll_order.GetData(ReceiptNo).Tables[0]; if (Convert.ToInt32(dt_order.Rows[0]["OState"]) == (int)Enums.OrderState.待审核 || Convert.ToInt32(dt_order.Rows[0]["OState"]) == (int)Enums.OrderState.已作废 || Convert.ToInt32(dt_order.Rows[0]["PayState"]) == (int)Enums.PayState.已支付) { return new ResultPayInfo() { Result = "F", Description = "订单信息异常" } } ; } //获取Pay_PayWxandAli表的实体 Hi.Model.Pay_PayWxandAli payali = Common.GetPayWxandAli(comp.ID); if (payali == null || ClsSystem.gnvl(payali.ali_isno, "0") == "0") { return new ResultPayInfo() { Result = "F", Description = "核心企业无可用的支付宝收款账户" } } ; //对数据库中数据进行解密 //partner = Common.DesDecrypt(payali.ali_partner, Common.EncryptKey); //seller = Common.DesDecrypt(payali.ali_seller_email, Common.EncryptKey); //private_key = Common.DesDecrypt(payali.ali_key, Common.EncryptKey); partner = payali.ali_partner; seller = payali.ali_seller_email; private_key = payali.ali_RSAkey; //订单支付跟预付款充值的提示信息(两种请款下的提示信息是不同的) if (OrderType == "0") { subject = "医站通订单-" + ReceiptNo; } else { subject = "医站通预付款充值"; } //订单所有商品明细 if (OrderType == "0") { DataTable l = new Hi.BLL.DIS_OrderDetail().GetOrderDe("", " IsNUll(o.dr,0)=0 and o.OrderId=" + Convert.ToInt32(dt_order.Rows[0]["ID"])); foreach (DataRow dr in l.Rows) { GoodsName += dr["GoodsName"] + ","; } GoodsName = GoodsName.Substring(0, GoodsName.Length - 1);//去掉最后一个逗号 if (GoodsName.Length > 15) { GoodsName = GoodsName.Substring(0, 10) + "..."; } } //获取订单支付时的支付流水号 if (OrderType == "0") { OrderNumberJSon = new OrderPay().GetPayID(PayIDJSon); //解析返回的订单支付流水号的JSon JInfo = JsonMapper.ToObject(OrderNumberJSon); if (JInfo["Result"].ToString().Trim() == "F" || JInfo["PayNumb"].ToString().Trim() == "" || JInfo["Result"].ToString().Trim() == "" || JInfo["OrderCode"].ToString().Trim() == "") { return(new ResultPayInfo() { Result = "F", Description = "获取支付流水号异常" }); } else { OrderNumber = JInfo["PayNumb"].ToString(); OrderCode = JInfo["OrderCode"].ToString(); } } else//钱包充值时的流水号跟企业订单号 { List <string> list = new List <string>(); list = Getpayidyfk(user.ID, comp.ID, dis.ID, PayPrice); OrderNumber = list[0]; OrderCode = list[1]; if (OrderNumber == "" || OrderCode == "") { return new ResultPayInfo() { Result = "F", Description = "获取支付流水号异常" } } ; } //创建订单信息 orderInfo = comm.getOrderInfo(subject, GoodsName, PayPrice, OrderNumber, partner, seller); // 对订单做RSA 签名 //private_key = "MIICdwIBADANBgkqhkiG9w0BAQEFAASCAmEwggJdAgEAAoGBANDptrV3pWWdbnr6wT8lPkZ6kbRgsjf8CfXpQNrJyOsmktOaX8DQRh5nd0lSFTtbfeGV4oWXi26bv+1Vt+CfAsYssf+futRj0l6Cxx0psJapK7QEXq3HqjB0tM11M9ym75WFFvTSZs1DysUkRV35g5rXuRtBOWR2sqm9JRAen+29AgMBAAECgYEAzZ+L1xb5c4e960uOE1Hb9tDDQs/9+j6XqzQ3QmFj4Zeo4p9KaeRVb62U6lThUvgdcYDuYWEkuuyPvtEk1/CKb61AvEW69ehwLeDXOy9AzEgQpGFPb1bgJ+kU8YCpgcOGR9G55iVc0ZW7B2iyx111Wvij8pc+A2ZeuByAG1f8PoECQQD7wvCyBJRNb7Gv7iHF+zx2lDxG6LTX2rCAZdr8FyWVjZEBfL6uPI+/2J2AqtFPaLa25+jQc3b74r4wuGKsvxBhAkEA1G4aDQovfB9RO/c4I+NX4mmitpNt66IuqKp0a9pOL/YfpNtr5GBgmK4LMVASqIG74bw5wAV7zJkunlGGPusK3QJBALLiUm/KvS1AXbqpsymfV9jRfvrLQiPVaW/x72ULdVMMIaoy3rGiqmkgGtlfhhWsS5cutMfYIwTamVS4zrP7lkECQFTvDJVoHCI5d0ZNivG2ZR4OdFMhURKkTpl7RX8V0qsUcgR9An9WFWkWNT1rMXqUHGWd100yJBRirqP4Hn+rhDUCQBPVgm4jNd5WjKD0Oj39FmF5D89OviTgQK4xYxYUIfqLBhuGZ3kWDvAmeE6uRgVXjQncv/c68W8pS2huT0syom4="; //private_key = "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCnxj/9qwVfgoUh/y2W89L6BkRAFljhNhgPdyPuBV64bfQNN1PjbCzkIM6qRdKBoLPXmKKMiFYnkd6rAoprih3/PrQEB/VsW8OoM8fxn67UDYuyBTqA23MML9q1+ilIZwBC2AQ2UBVOrFXfFl75p6/B5KsiNG9zpgmLCUYuLkxpLQIDAQAB"; string sign = Com.Alipay.RSAFromPkcs8.sign(orderInfo, private_key, "utf-8"); //string sign = RSAFromPkcs8.sign(orderInfo, private_key, "utf-8"); sign = HttpUtility.UrlEncode(sign, Encoding.UTF8); //返回实体 // 完整的符合支付宝参数规范的订单信息 payinfo.Result = "T"; payinfo.Description = "返回成功"; payinfo.InfoString = orderInfo + "&sign=\"" + sign + "\"&" + comm.getSignType(); payinfo.OrderCode = OrderCode; } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetPayInfo:" + JSon); return(new ResultPayInfo() { Result = "F", Description = "参数异常" }); } return(payinfo); }
public ResultAli Result_Ali(string JSon, string version) { string disID = string.Empty; string UserID = string.Empty; Hi.BLL.BD_Distributor bll_dis = new Hi.BLL.BD_Distributor(); Hi.BLL.BD_Company bll_comp = new Hi.BLL.BD_Company(); ResultAli result = new ResultAli(); string partner = string.Empty; string seller = string.Empty; string private_key = string.Empty; try { #region//JSon取值 JsonData JInfo = JsonMapper.ToObject(JSon); if (JInfo.Count > 0 && JInfo["UserID"].ToString().Trim() != "" && JInfo["ResellerID"].ToString().Trim() != "") { disID = JInfo["ResellerID"].ToString(); UserID = JInfo["UserID"].ToString(); } else { return(new ResultAli() { Result = "F", Description = "参数异常" }); } #endregion //判断登录信息是否正确 Hi.Model.SYS_Users user = new Hi.Model.SYS_Users(); if (!new Common().IsLegitUser(int.Parse(UserID), out user, 0, int.Parse(disID == "" ? "0" : disID))) { return new ResultAli() { Result = "F", Description = "用户异常" } } ; //判断经销商信息是否异常 Hi.Model.BD_Distributor dis = bll_dis.GetModel(Convert.ToInt32(disID)); if (dis == null || dis.dr == 1 || dis.AuditState == 0 || dis.IsEnabled == 0) { return new ResultAli() { Result = "F", Description = "经销商异常" } } ; //判断经销商对应的核心企业是否异常 Hi.Model.BD_Company comp = bll_comp.GetModel(dis.CompID); if (comp == null || comp.dr == 1 || comp.AuditState == 0 || comp.IsEnabled == 0) { return new ResultAli() { Result = "F", Description = "核心企业异常" } } ; //获取Pay_PayWxandAli表的实体 Hi.Model.Pay_PayWxandAli payali = Common.GetPayWxandAli(comp.ID); if (payali == null || ClsSystem.gnvl(payali.ali_isno, "0") == "0") { return new ResultAli() { Result = "F", Description = "核心企业无可用的支付宝收款账户" } } ; #region //返回参数 result.Result = "T"; result.Description = "返回成功"; //对数据库中数据进行解密 partner = Common.DesDecrypt(payali.ali_partner, Common.EncryptKey); seller = Common.DesDecrypt(payali.ali_seller_email, Common.EncryptKey); private_key = Common.DesDecrypt(payali.ali_key, Common.EncryptKey); //对解密过的数据,再用我们的加密方法进行加密 partner = AESHelper.Encrpt_string(partner); seller = AESHelper.Encrpt_string(seller); private_key = AESHelper.Encrpt_string(private_key); //将我们这边加密完的数据,赋值给返回实体 result.PARTNER = partner; result.SELLER = seller; result.RSA_PRIVATE = private_key; #endregion } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "Result_Ali:" + JSon); return(new ResultAli() { Result = "F", Description = "参数异常" }); } return(result); }
public DateTime dtm当前服务器时间() { ClsSystem cls = new ClsSystem(); return(cls.dtm当前服务器时间()); }
public string dtBtnBaseInfo() { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.dtBtnBaseInfo())); }
public string dtFormBtnInfo(string fchrFrmNameID, string fchrFrmText) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.dtFormBtnInfo(ClsDES.Decrypt(fchrFrmNameID), ClsDES.Decrypt(fchrFrmText)))); }
public string dtForm(string fchrFrmNameID, string fchrFrmText, string Flag) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.dtForm(ClsDES.Decrypt(fchrFrmNameID), ClsDES.Decrypt(fchrFrmText), ClsDES.Decrypt(Flag)))); }
public string sDeptID(string sUid) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.sDeptID(ClsDES.Decrypt(sUid)))); }
public int sRoleRight(string sUid, string sInfo) { ClsSystem cls = new ClsSystem(); return(cls.sRoleRight(ClsDES.Decrypt(sUid), ClsDES.Decrypt(sInfo))); }
public int sUserRoleInfo(string vchrRoleID, string sUid) { ClsSystem cls = new ClsSystem(); return(cls.sUserRoleInfo(ClsDES.Decrypt(vchrRoleID), ClsDES.Decrypt(sUid))); }
public string saveUserInfoPwd(string vchrUid, string vchrPwd) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.saveUserInfoPwd(ClsDES.Decrypt(vchrUid), ClsDES.Decrypt(vchrPwd)))); }
public string dtSysObjects(string DataBase, string Flag) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.dtSysObjects(ClsDES.Decrypt(DataBase), ClsDES.Decrypt(Flag)))); }
public string saveTableColInfo(string sdt, string DataBase, string Table, int iSystem) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.saveTableColInfo(Cls序列化.DeserializeDataTable(ClsDES.Decrypt(sdt)), ClsDES.Decrypt(DataBase), ClsDES.Decrypt(Table), iSystem))); }
public string dtCreateBtn(string sUid, string sFormInfo) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.dtCreateBtn(ClsDES.Decrypt(sUid), ClsDES.Decrypt(sFormInfo)))); }
public ResultOrderList GetBriefingList(string JSon) { try { string UserID = string.Empty; string CompID = string.Empty; string criticalOrderID = string.Empty; //当前列表最临界点产品ID:初始-1 string getType = string.Empty; //方向 string rows = string.Empty; string sortType = string.Empty; string sort = string.Empty; string datetype = string.Empty; string ordertype = string.Empty; #region//JSon取值 JsonData JInfo = JsonMapper.ToObject(JSon); if (JInfo.Count > 0 && JInfo["UserID"].ToString() != "" && JInfo["CompID"].ToString() != "" && JInfo["CriticalOrderID"].ToString() != "" && JInfo["GetType"].ToString() != "" && JInfo["Rows"].ToString() != "" && JInfo["SortType"].ToString() != "" && JInfo["Sort"].ToString() != "" && JInfo["DateType"].ToString() != "" && JInfo["OrderType"].ToString() != "") { UserID = JInfo["UserID"].ToString(); CompID = JInfo["CompID"].ToString(); criticalOrderID = JInfo["CriticalOrderID"].ToString(); getType = JInfo["GetType"].ToString(); rows = JInfo["Rows"].ToString(); sortType = JInfo["SortType"].ToString(); sort = JInfo["Sort"].ToString(); datetype = JInfo["DateType"].ToString(); ordertype = JInfo["OrderType"].ToString(); } else { return(new ResultOrderList() { Result = "F", Description = "参数异常" }); } #endregion //判断登录信息是否异常 Hi.Model.SYS_Users one = new Hi.Model.SYS_Users(); if (!new Common().IsLegitUser(int.Parse(UserID), out one, int.Parse(CompID == "" ? "0" : CompID))) { return new ResultOrderList() { Result = "F", Description = "登录信息异常" } } ; //判断经销商信息是否异常 Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(Convert.ToInt32(CompID)); if (comp == null || comp.dr == 1 || comp.AuditState == 0 || comp.IsEnabled == 0) { return new ResultOrderList() { Result = "F", Description = "核心企业异常" } } ; DateTime date = DateTime.Now; DateTime date_start = new DateTime(); DateTime date_end = date.AddDays(1); //string strdate_start = string.Empty; // string strdate_end = date_end.ToString("yyyy-MM-dd"); string strwhere = ""; switch (datetype) { case "0": date_start = new DateTime(date.Year, date.Month, date.Day, 0, 0, 0); //strdate_start = date_start.ToString("yyyy-MM-dd"); break; case "1": DateTime startWeek = date.AddDays(1 - Convert.ToInt32(date.DayOfWeek.ToString("d"))); date_start = new DateTime(startWeek.Year, startWeek.Month, startWeek.Day, 0, 0, 0); //strdate_start = date_start.ToString("yyyy-MM-dd"); break; case "2": date_start = new DateTime(date.Year, date.Month, 1); //strdate_start = date_start.ToString("yyyy-MM-dd"); break; default: return(new ResultOrderList() { Result = "F", Description = "时间段类型异常" }); break; } switch (ordertype) { case "0": strwhere = " and isnull(dr,0)=0 and Otype!=9 and CompID=" + comp.ID + " and OState in (2,3,4,5,7) and CreateDate>='" + date_start + "' and CreateDate<='" + date_end + "'"; break; case "1": strwhere = " and isnull(dr,0)=0 and CompID=" + comp.ID + " and CreateDate>='" + date_start + "' and CreateDate<='" + date_end + "' and ReturnState =3"; break; case "2": string sql = "SELECT distinct orderID FROM [dbo].[CompCollection_view] where OrderID not in(select ID from Dis_Order where ISNULL(dr,0)=0 and (Otype=9 or OState not in(2,3,4,5,7)) and CompID=" + comp.ID + ") and status!=3 and CompID=" + comp.ID + " and Date>='" + date_start + "' and Date<'" + date_end + "' AND vedf9=1 "; DataTable dt_pay = SqlHelper.Query(SqlHelper.LocalSqlServer, sql).Tables[0]; string where = ""; for (int i = 0; i < dt_pay.Rows.Count; i++) { if (ClsSystem.gnvl(dt_pay.Rows[i]["orderID"], "") != "") { where += ","; where += ClsSystem.gnvl(dt_pay.Rows[i]["orderID"], ""); } } where = where.Substring(1, where.Length - 1); strwhere = " and id in (" + where + ")"; break; default: return(new ResultOrderList() { Result = "F", Description = "订单类型异常" }); break; } if (sortType == "1") //价格排序 { sortType = "CreateDate"; } else if (sortType == "2") //价格排序 { sortType = "TotalAmount"; } else { sortType = "ID"; } string strsql = new Common().PageSqlString(criticalOrderID, "ID", "DIS_Order", sortType, sort, strwhere, getType, rows); if (strsql == "") { return new ResultOrderList() { Result = "F", Description = "基础数据异常" } } ; #region 赋值 List <Order> OrderList = new List <Order>(); DataSet ds = SqlHelper.Query(SqlHelper.LocalSqlServer, strsql); if (ds.Tables.Count == 0) { return new ResultOrderList() { Result = "T", Description = "没有更多数据" } } ; DataTable orderList = ds.Tables[0]; if (orderList != null) { if (orderList.Rows.Count == 0) { return new ResultOrderList() { Result = "T", Description = "没有更多数据" } } ; foreach (DataRow row in orderList.Rows) { Order order = new Order(); Hi.Model.DIS_Order orderModel = new Hi.BLL.DIS_Order().GetModel(int.Parse(row["ID"].ToString())); if (orderModel == null || orderModel.dr == 1) { return new ResultOrderList() { Result = "F", Description = "订单异常" } } ; order.OrderID = orderModel.ID.ToString(); order.CompID = orderModel.CompID.ToString(); order.CompName = comp.CompName; order.State = Common.GetCompOrderType(orderModel.OState, orderModel.PayState, orderModel.Otype, orderModel.ReturnState); string IsEnSend, IsEnPay, IsEnReceive, IsEnReturn, IsEnAudit; Common.GetEspecialType(orderModel.OState.ToString(), orderModel.PayState.ToString(), orderModel.Otype.ToString(), orderModel.ReturnState.ToString(), out IsEnSend, out IsEnPay, out IsEnAudit, out IsEnReceive, out IsEnReturn); order.IsEnSend = IsEnSend; order.IsEnPay = IsEnPay; order.IsEnAudit = IsEnAudit; order.IsEnReceive = IsEnReceive; order.IsEnReturn = IsEnReturn; order.Otype = orderModel.Otype.ToString(); order.AddType = orderModel.AddType.ToString(); order.OState = orderModel.OState.ToString(); order.PayState = orderModel.PayState.ToString(); order.ReturnState = orderModel.ReturnState.ToString(); order.DisID = orderModel.DisID.ToString(); Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(orderModel.DisID); if (dis == null || dis.AuditState == 0 || dis.dr == 1) { return new ResultOrderList() { Result = "F", Description = "经销信息商异常" } } ; order.DisName = dis.DisName; order.DisUserID = orderModel.DisUserID.ToString(); Hi.Model.SYS_Users user = new Hi.BLL.SYS_Users().GetModel(int.Parse(order.DisUserID)); //if (user == null || user.IsEnabled == 0 || user.dr == 1) // return new ResultOrderList() { Result = "F", Description = "经销商用户信息异常" }; //order.DisUserName = orderModel.DisUserName; if (user != null && user.IsEnabled == 1 && user.dr == 0) { order.DisUserName = user.TrueName; } else { order.DisUserName = ""; } order.AddrID = orderModel.AddrID.ToString(); order.ReceiptNo = orderModel.ReceiptNo; if (ClsSystem.gnvl(orderModel.ArriveDate, "") != "0001/1/1 0:00:00" && ClsSystem.gnvl(orderModel.ArriveDate, "") != "") { order.ArriveDate = orderModel.ArriveDate.ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(orderModel.AddrID.ToString())) { Hi.Model.BD_DisAddr addr = new Hi.BLL.BD_DisAddr().GetModel(orderModel.AddrID); if (addr != null) { order.Zip = addr.Zip; } } order.Address = orderModel.Address; order.Contact = orderModel.Principal; order.Phone = orderModel.Phone; order.TotalAmount = orderModel.AuditAmount.ToString("0.00"); order.AuditTotalAmount = orderModel.AuditAmount.ToString("0.00"); order.PayedAmount = orderModel.PayedAmount.ToString("0.00"); order.CreateUserID = orderModel.CreateUserID.ToString(); order.CreateDate = orderModel.CreateDate.ToString("yyyy-MM-dd HH:mm"); order.ReturnMoneyDate = orderModel.ReturnMoneyDate.ToString(); order.ReturnMoneyUser = orderModel.ReturnMoneyUser; order.ReturnMoneyUserId = orderModel.ReturnMoneyUserId.ToString(); List <Hi.Model.DIS_OrderOut> outList = new Hi.BLL.DIS_OrderOut().GetList("", " OrderID='" + orderModel.ID + "' and CompID='" + orderModel.CompID + "' and DisID='" + orderModel.DisID + "' and ISNULL(dr,0)=0", ""); if (outList.Count != 0) { Hi.Model.DIS_OrderOut orderOut = new Hi.Model.DIS_OrderOut(); foreach (Hi.Model.DIS_OrderOut Out in outList) { orderOut = Out; } order.SendID = orderOut.ID.ToString(); order.SendDate = orderOut.SendDate.ToString(); ////order.Express = orderOut.Express; ////order.ExpressNo = orderOut.ExpressNo; ////order.ExpressPerson = orderOut.ExpressPerson; ////order.ExpressTel = orderOut.ExpressTel; ////order.ExpressBao = orderOut.ExpressBao; ////order.PostFee = orderOut.PostFee.ToString("0.00"); order.ActionUser = orderOut.ActionUser; List <Hi.Model.DIS_Logistics> exlist = Common.GetExpress(orderOut.ID.ToString()); if (exlist != null) { order.SendRemark = exlist[0].Context; } order.IsAudit = orderOut.IsAudit.ToString(); order.AuditUserID = orderOut.AuditUserID.ToString(); order.AuditDate = orderOut.AuditDate.ToString(); order.AuditRemark = orderOut.AuditRemark == null ? "" : orderOut.AuditRemark.ToString(); order.SignDate = orderOut.SignDate.ToString(); order.IsSign = orderOut.IsSign.ToString(); order.SignUserId = orderOut.SignUserId.ToString(); order.SignUser = orderOut.SignUser; order.SignRemark = orderOut.SignRemark; } //todo:不知道的排序 //order.SortIndex = orderModel.SortIndex.ToString(); order.IsDel = orderModel.dr.ToString(); //明细 List <OrderDetail> orderDetail = new List <OrderDetail>(); List <Hi.Model.DIS_OrderDetail> detailList = new Hi.BLL.DIS_OrderDetail().GetList("", " OrderID='" + orderModel.ID + "' and DisID='" + orderModel.DisID + "' and ISNULL(dr,0)=0", ""); if (detailList == null) //|| detailList.Count==0 { return new ResultOrderList() { Result = "F", Description = "订单明细异常" } } ; List <Hi.Model.BD_GoodsAttrs> list_attrs = null; foreach (Hi.Model.DIS_OrderDetail detail in detailList) { string SKUName = string.Empty; OrderDetail ordetail = new OrderDetail(); ordetail.SKUID = detail.GoodsinfoID.ToString(); //通过GoodsInfoID找到GoodsID Hi.Model.BD_GoodsInfo goodsInfo = new Hi.BLL.BD_GoodsInfo().GetModel(detail.GoodsinfoID); if (goodsInfo == null) { //if (goodsInfo == null || goodsInfo.IsEnabled == false || goodsInfo.dr == 1) return new ResultOrderList() { Result = "F", Description = "SKU信息异常" } } ; ordetail.ProductID = goodsInfo.GoodsID.ToString(); //通过GoodsID找到GoodsName Hi.Model.BD_Goods goods = new Hi.BLL.BD_Goods().GetModel(goodsInfo.GoodsID); if (goods == null) { //if (goods == null || goods.IsEnabled == 0 | goods.dr == 1) return new ResultOrderList() { Result = "F", Description = "商品异常" } } ; ordetail.ProductName = goods.GoodsName; SKUName += goods.GoodsName; list_attrs = new Hi.BLL.BD_GoodsAttrs().GetList("AttrsName", "GoodsID = " + goodsInfo.GoodsID + " and CompID = " + comp.ID + " and ISNULL(dr,0) = 0", ""); if (list_attrs != null && list_attrs.Count != 0) { foreach (Hi.Model.BD_GoodsAttrs attr in list_attrs) { SKUName += attr.AttrsName; } } ordetail.SKUName = SKUName; //todo:描述是什么 ordetail.ValueInfo = goodsInfo.ValueInfo; ordetail.SalePrice = detail.Price.ToString("0.00"); ordetail.TinkerPrice = detail.AuditAmount.ToString("0.00"); ordetail.Num = detail.GoodsNum.ToString("0.00"); ordetail.Remark = detail.Remark; //ordetail.IsPro = .Trim() == "0" || detail.vdef1.Trim() == "" ? "0" : "1"; //是否是促销商品 //是否是促销商品 ordetail.IsPro = ClsSystem.gnvl(detail.vdef1, "").Trim() == "0" || ClsSystem.gnvl(detail.vdef1, "").Trim() == "" ? "0" : "1"; if (ordetail.IsPro != "0") { ordetail.ProNum = detail.vdef5; if (detail.vdef1 != "" && detail.vdef1.Length > 0) { Hi.Model.BD_Promotion pro = new Hi.BLL.BD_Promotion().GetModel(Convert.ToInt32(detail.vdef1)); if (pro != null) { List <Hi.Model.BD_PromotionDetail> dList = new Hi.BLL.BD_PromotionDetail().GetList( "", " ProID=" + pro.ID + " and GoodInfoID ='" + ordetail.SKUID + "' and dr=0", ""); string info = string.Empty; if (dList != null && dList.Count > 0) { if (pro.Type == 0 && pro.ProType == 1) { info = "赠品"; } else if (pro.Type == 0 && pro.ProType == 2) { info = "商品优惠价" + dList[0].GoodsPrice.ToString("0.00"); } else if (pro.Type == 1 && pro.ProType == 3) { info = "商品数量满" + pro.Discount.ToString("0.00") + "赠" + dList[0].GoodsPrice.ToString("0.00") + dList[0].GoodsUnit; } else if (pro.Type == 1 && pro.ProType == 4) { info = "商品打折" + pro.Discount.ToString("0.00") + "%"; } } ordetail.proInfo = new PromotionInfo() { ProID = detail.vdef1, ProTitle = pro.ProTitle, ProInfos = info, Type = pro.Type.ToString(), ProTpye = pro.ProType.ToString(), Discount = pro.Discount.ToString("0.00"), ProStartTime = pro.ProStartTime.ToString("yy-MM-dd"), ProEndTime = pro.ProEndTime.ToString("yy-MM-dd") }; } } } List <Pic> Pic = new List <Pic>(); if (goods.Pic != "" && goods.Pic != "X") { Pic pic = new Pic(); pic.ProductID = goodsInfo.GoodsID.ToString(); pic.IsDeafult = "1"; pic.PicUrl = ConfigurationManager.AppSettings["ImgViewPath"].ToString().Trim() + "GoodsImg/" + goods.Pic; Pic.Add(pic); } ordetail.ProductPicUrlList = Pic; orderDetail.Add(ordetail); } order.OrderDetailList = orderDetail; OrderList.Add(order); } } else { return(new ResultOrderList() { Result = "F", Description = "没有更多数据" }); } #endregion return(new ResultOrderList() { Result = "T", Description = "获取成功", OrderList = OrderList }); } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetBriefingList:" + JSon); return(new ResultOrderList() { Result = "F", Description = "参数异常" }); } }
public string dtMainSetTree(string sUid, string sProForm) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.dtMainSetTree(ClsDES.Decrypt(sUid), ClsDES.Decrypt(sProForm)))); }
public ResultWX Result_WX(string JSon, string version) { string disID = string.Empty; string UserID = string.Empty; Hi.BLL.BD_Distributor bll_dis = new Hi.BLL.BD_Distributor(); Hi.BLL.BD_Company bll_comp = new Hi.BLL.BD_Company(); ResultWX result = new ResultWX(); string appid = string.Empty; string mchid = string.Empty; string key = string.Empty; try { #region//JSon取值 JsonData JInfo = JsonMapper.ToObject(JSon); if (JInfo.Count > 0 && JInfo["UserID"].ToString().Trim() != "" && JInfo["ResellerID"].ToString().Trim() != "") { disID = JInfo["ResellerID"].ToString(); UserID = JInfo["UserID"].ToString(); } else { return(new ResultWX() { Result = "F", Description = "参数异常" }); } #endregion //判断登录信息是否正确 Hi.Model.SYS_Users user = new Hi.Model.SYS_Users(); if (!new Common().IsLegitUser(int.Parse(UserID), out user, 0, int.Parse(disID == "" ? "0" : disID))) { return new ResultWX() { Result = "F", Description = "用户异常" } } ; //判断经销商信息是否异常 Hi.Model.BD_Distributor dis = bll_dis.GetModel(Convert.ToInt32(disID)); if (dis == null || dis.dr == 1 || dis.AuditState == 0 || dis.IsEnabled == 0) { return new ResultWX() { Result = "F", Description = "经销商异常" } } ; //判断经销商对应的核心企业是否异常 Hi.Model.BD_Company comp = bll_comp.GetModel(dis.CompID); if (comp == null || comp.dr == 1 || comp.AuditState == 0 || comp.IsEnabled == 0) { return new ResultWX() { Result = "F", Description = "核心企业异常" } } ; //获取Pay_PayWxandAli表的实体 Hi.Model.Pay_PayWxandAli paywx = Common.GetPayWxandAli(comp.ID); if (paywx == null || ClsSystem.gnvl(paywx.wx_Isno, "0") == "0") { return new ResultWX() { Result = "F", Description = "核心企业无可用的微信收款账户" } } ; #region //返回参数 result.Result = "T"; result.Description = "返回成功"; //对数据库中取出的值进行解密 appid = Common.DesDecrypt(paywx.wx_appid, Common.EncryptKey); mchid = Common.DesDecrypt(paywx.wx_mchid, Common.EncryptKey); key = Common.DesDecrypt(paywx.wx_key, Common.EncryptKey); //对解密过的字段,用我们这边的方法重新加密 appid = AESHelper.Encrpt_string(appid); mchid = AESHelper.Encrpt_string(mchid); key = AESHelper.Encrpt_string(key); //将加密完的值赋给返回实体 result.AppID = appid; result.Mchid = mchid; //result.AppSecret = paywx.wx_appsechet; result.APPkey = key; #endregion //return result; } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "Result_WX:" + JSon); return(new ResultWX() { Result = "F", Description = "参数异常" }); } return(result); }
public string sfchrFrmNameID() { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.sfchrFrmNameID())); }
///<summary> ///获取钱包充值流水号 ///</summary> public List <string> Getpayidyfk(int UserID, int CompID, int DisID, string price) { int prepayid = 0; int payid = 0; int regid = 0; List <string> list = new List <string>(); Hi.Model.PAY_PrePayment Prepay = new Hi.Model.PAY_PrePayment(); Hi.BLL.PAY_PrePayment bll_prepay = new Hi.BLL.PAY_PrePayment(); Hi.BLL.PAY_Payment bll_pay = new Hi.BLL.PAY_Payment(); Hi.BLL.PAY_RegisterLog bll_reg = new Hi.BLL.PAY_RegisterLog(); Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(DisID); try { //在表PAY_PrePayment中生成一条数据 Prepay.CompID = CompID; Prepay.DisID = DisID; Prepay.OrderID = 0; Prepay.Start = 2; Prepay.PreType = 1; Prepay.price = Convert.ToDecimal(price); Prepay.Paytime = DateTime.Now; Prepay.CreatDate = DateTime.Now; Prepay.OldId = 0; Prepay.CrateUser = UserID; Prepay.AuditState = 2; Prepay.AuditUser = 0; Prepay.IsEnabled = 1; Prepay.ts = DateTime.Now; Prepay.modifyuser = UserID; prepayid = bll_prepay.Add(Prepay); if (prepayid > 0) { //如果pay_prepayment表中插入数据成功的话,在pay_payment表中插入一条数据 int keyID = prepayid; Hi.Model.PAY_PrePayment Prepay_M = bll_prepay.GetModel(prepayid); string guid = Guid.NewGuid().ToString().Replace("-", ""); Hi.Model.PAY_Payment pay = new Hi.Model.PAY_Payment(); pay.OrderID = keyID; pay.DisID = DisID; pay.PayUser = dis.DisName; pay.PayPrice = Convert.ToDecimal(price); pay.guid = Common.Number_repeat(guid); pay.IsAudit = 2; pay.vdef3 = "2"; pay.CreateDate = DateTime.Now; pay.CreateUserID = UserID; pay.ts = DateTime.Now; pay.modifyuser = UserID; pay.Channel = "6"; payid = bll_pay.Add(pay); //如果pay_prepayment表中插入数据成功的话,在PAY_RegisterLog表中插入一条数据 Hi.Model.PAY_RegisterLog reg = new Hi.Model.PAY_RegisterLog(); reg.OrderId = keyID; reg.Ordercode = WebConfigurationManager.AppSettings["OrgCode"] + Convert.ToString(keyID); reg.number = pay.guid; reg.Price = Convert.ToDecimal(price); reg.Payuse = "企业钱包充值"; reg.PayName = dis.DisName; reg.DisID = DisID; reg.PayTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); reg.BankID = "支付宝"; reg.CreateUser = UserID; reg.CreateDate = DateTime.Now; reg.LogType = 1375; regid = bll_reg.Add(reg); if (payid > 0 && regid > 0) { //返回的list第一行放支付流水号,第二行放企业订单号(支付时生成) list.Add(ClsSystem.gnvl(pay.guid, "")); list.Add(ClsSystem.gnvl(reg.Ordercode, "")); return(list); } } } catch { } return(null); }
public string delForm(string FormCode) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.delForm(ClsDES.Decrypt(FormCode)))); }
//获取医院名称 public static string GetYYMC(string yybm) { return(ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cus.cCusName from Customer_extradefine ex join Customer cus on cus.cCusCode=ex.cCusCode where ex.ccdefine1='" + ClsSystem.gnvl(yybm, "") + "'", Program.ConnectionString), "")); }
public string delRoleInfo(string sRoleID) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.delRoleInfo(ClsDES.Decrypt(sRoleID)))); }
//查询退货单信息 private void buttonReturnOrderQuery_Click(object sender, EventArgs e) { try { FormReturnOrderFilter formReturnOrderFilter = new FormReturnOrderFilter(); if (formReturnOrderFilter.ShowDialog() != DialogResult.OK) { return; } string xmlData = formReturnOrderFilter.FilterCondition; if (ClsSystem.gnvl(xmlData, "") != "") { string resultXml = SendMessage.SetMessage("YQ011", xmlData); string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG"); if (result != "00000") { //获取失败信息 } else { dataGridViewReturnOrder.Rows.Clear(); TextReader textReader = new StringReader(resultXml); DataSet ds = new DataSet(); ds.ReadXml(textReader); result = SendMessage.ReadXMl(resultXml, "MAIN", "JLS"); if (int.Parse(result) > 0) { if (ds.Tables.Count > 3) { DataTable db = ds.Tables[3]; for (int i = 0; i < db.Rows.Count; ++i) { dataGridViewReturnOrder.Rows.Add(); dataGridViewReturnOrder.Rows[i].Cells["SELECTED"].Value = true; dataGridViewReturnOrder.Rows[i].Cells["SFWJ"].Value = ClsSystem.gnvl(ds.Tables[1].Rows[0]["SFWJ"], ""); dataGridViewReturnOrder.Rows[i].Cells["THDBH"].Value = ClsSystem.gnvl(db.Rows[i]["THDBH"], ""); dataGridViewReturnOrder.Rows[i].Cells["YQBM"].Value = ClsSystem.gnvl(db.Rows[i]["YQBM"], ""); dataGridViewReturnOrder.Rows[i].Cells["YYBM"].Value = ClsSystem.gnvl(db.Rows[i]["YYBM"], ""); //TODO:附加医院名称 dataGridViewReturnOrder.Rows[i].Cells["YYMC"].Value = OrderInfo.GetYYMC(ClsSystem.gnvl(db.Rows[i]["YYBM"], "")); dataGridViewReturnOrder.Rows[i].Cells["PSDBM"].Value = ClsSystem.gnvl(db.Rows[i]["PSDBM"], ""); dataGridViewReturnOrder.Rows[i].Cells["PSDZ"].Value = ClsSystem.gnvl(db.Rows[i]["PSDZ"], ""); dataGridViewReturnOrder.Rows[i].Cells["THDTJRQ"].Value = ClsSystem.gnvl(db.Rows[i]["THDTJRQ"], ""); //TODO:显示提交方式名称 dataGridViewReturnOrder.Rows[i].Cells["THDTJFS"].Value = OrderInfo.GetTJFSName(ClsSystem.gnvl(db.Rows[i]["THDTJFS"], "")); //TODO:显示处理状态名称 dataGridViewReturnOrder.Rows[i].Cells["THDCLZT"].Value = OrderInfo.GetTHDCLZTName(ClsSystem.gnvl(db.Rows[i]["THDCLZT"], "")); dataGridViewReturnOrder.Rows[i].Cells["DLCGBZ"].Value = ClsSystem.gnvl(db.Rows[i]["DLCGBZ"], ""); //TODO:显示商品类型名称 dataGridViewReturnOrder.Rows[i].Cells["SPLX"].Value = OrderInfo.GetSPLXName(ClsSystem.gnvl(db.Rows[i]["SPLX"], "")); //TODO:显示药品类型名称 dataGridViewReturnOrder.Rows[i].Cells["YPLX"].Value = OrderInfo.GetYPLXName(ClsSystem.gnvl(db.Rows[i]["YPLX"], "")); dataGridViewReturnOrder.Rows[i].Cells["ZXSPBM"].Value = ClsSystem.gnvl(db.Rows[i]["ZXSPBM"], ""); dataGridViewReturnOrder.Rows[i].Cells["CPM"].Value = ClsSystem.gnvl(db.Rows[i]["CPM"], ""); dataGridViewReturnOrder.Rows[i].Cells["YPJX"].Value = ClsSystem.gnvl(db.Rows[i]["YPJX"], ""); dataGridViewReturnOrder.Rows[i].Cells["GG"].Value = ClsSystem.gnvl(db.Rows[i]["GG"], ""); dataGridViewReturnOrder.Rows[i].Cells["CGJLDW"].Value = ClsSystem.gnvl(db.Rows[i]["CGJLDW"], ""); dataGridViewReturnOrder.Rows[i].Cells["YYDWMC"].Value = ClsSystem.gnvl(db.Rows[i]["YYDWMC"], ""); dataGridViewReturnOrder.Rows[i].Cells["BZNHSL"].Value = ClsSystem.gnvl(db.Rows[i]["BZNHSL"], ""); dataGridViewReturnOrder.Rows[i].Cells["SCQYMC"].Value = ClsSystem.gnvl(db.Rows[i]["SCQYMC"], ""); dataGridViewReturnOrder.Rows[i].Cells["SCPH"].Value = ClsSystem.gnvl(db.Rows[i]["SCPH"], ""); dataGridViewReturnOrder.Rows[i].Cells["THSL"].Value = ClsSystem.gnvl(db.Rows[i]["THSL"], ""); dataGridViewReturnOrder.Rows[i].Cells["THDJ"].Value = ClsSystem.gnvl(db.Rows[i]["THDJ"], ""); dataGridViewReturnOrder.Rows[i].Cells["THZJ"].Value = ClsSystem.gnvl(db.Rows[i]["THZJ"], ""); dataGridViewReturnOrder.Rows[i].Cells["THYY"].Value = ClsSystem.gnvl(db.Rows[i]["THYY"], ""); } } } } } } catch (Exception ex) { MessageBox.Show("退货单查询失败! " + ex.Message); } }
public string dtTableColInfo(string DataBase, string Table) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.dtTableColInfo(ClsDES.Decrypt(DataBase), ClsDES.Decrypt(Table)))); }
/// <summary> /// 获取企业产品分类列表 /// </summary> /// <param name="JSon"></param> /// <returns></returns> public ResultGoodsCategory GetResellerProductClassifyList(string JSon) { try { string userID = string.Empty; string disID = string.Empty; string companyID = string.Empty; //绑定的企业ID(目前只绑定一家,默认传入0) JsonData JInfo = JsonMapper.ToObject(JSon); if (JInfo.Count > 0 && JInfo["UserID"].ToString() != "" && JInfo["ResellerID"].ToString() != "" && JInfo["CompanyID"].ToString() != "") { userID = JInfo["UserID"].ToString(); disID = JInfo["ResellerID"].ToString(); companyID = JInfo["CompanyID"].ToString(); } else { return(new ResultGoodsCategory() { Result = "F", Description = "参数异常" }); } Hi.Model.SYS_Users user = new Hi.Model.SYS_Users(); if (!new Common().IsLegitUser(int.Parse(userID), out user, int.Parse(companyID), int.Parse(disID == "" ? "0" : disID))) { return new ResultGoodsCategory() { Result = "F", Description = "参数异常" } } ; Hi.Model.BD_Company comp = new Hi.Model.BD_Company(); if (companyID.Trim() == "0")//经销商分类:compID传0 { Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(int.Parse(disID.Trim())); if (dis == null || dis.dr == 1 || dis.IsEnabled == 0) { return new ResultGoodsCategory() { Result = "F", Description = "经销商信息异常" } } ; comp = new Hi.BLL.BD_Company().GetModel(dis.CompID); } else //企业分类 { comp = new Hi.BLL.BD_Company().GetModel(int.Parse(companyID.Trim())); } if (comp == null || comp.dr == 1 || comp.IsEnabled == 0) { return new ResultGoodsCategory() { Result = "T", Description = "企业异常" } } ; string strsql = "select GoodsTypeID as ClassifyID, CategoryCode as ClassifyCode,CategoryName as ClassifyName,"; strsql = strsql + "ParentID,SortIndex from BD_GoodsCategory "; strsql = strsql + "where CompID='" + comp.ID + "' and ISNULL(dr,0)=0 and IsEnabled = 1 "; DataTable dt = SqlAccess.ExecuteSqlDataTable(strsql, ConfigurationSettings.AppSettings["ConnectionString"].ToString()); List <ProductClassify> pList = new List <ProductClassify>(); for (int i = 0; i < dt.Rows.Count; i++) { ProductClassify pClassifies = new ProductClassify(); pClassifies.ClassifyID = ClsSystem.gnvl(dt.Rows[i]["ClassifyID"], ""); pClassifies.ClassifyName = ClsSystem.gnvl(dt.Rows[i]["ClassifyName"], ""); pClassifies.ParentID = ClsSystem.gnvl(dt.Rows[i]["ParentID"], ""); pClassifies.SortIndex = ClsSystem.gnvl(dt.Rows[i]["SortIndex"], ""); pList.Add(pClassifies); } ProductClassify classifies = new ProductClassify(); classifies.ClassifyID = "-1"; classifies.ClassifyName = "全部分类"; classifies.ParentID = "0"; classifies.SortIndex = "0"; pList.Add(classifies); return(new ResultGoodsCategory() { Result = "T", Description = "获取成功", CompanyID = comp.ID.ToString(), CompanyName = comp.CompName, ProductClassifyList = pList }); } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetResellerProductClassifyList :" + JSon); return(new ResultGoodsCategory() { Result = "F", Description = "异常" }); } }
public string saveDefine1(string vchrUid) { ClsSystem cls = new ClsSystem(); return(ClsDES.Encrypt(cls.saveDefine1(ClsDES.Decrypt(vchrUid)))); }