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