public void UpdateOrderStatusForErp(string orderid, string spid, int OrderStatus, string authKey)
{
if (authKey == key)
{
SOSOshop.BLL.Order.Orders bll = new SOSOshop.BLL.Order.Orders();
bll.UpdateOrderStatusForErp(orderid, spid, OrderStatus);
}
}
public void UpdateOrdersMQ_1(string orderid, string authKey)
{
if (authKey == key)
{
SOSOshop.BLL.Order.Orders bll = new SOSOshop.BLL.Order.Orders();
bll.UpdateOrdersMQ_1(orderid);
}
}
//分页数据初始化
protected override void StartLoad(int PageIndex, string strWhere)
{
bll = new SOSOshop.BLL.Order.Orders();
int recordCount, pageCount;
AspNetPager1.PageSize = 10;
#region 搜索条件
System.Text.StringBuilder sb = new StringBuilder();
sb.Append(" and (isnull(Product_ID_02,-1)=0) AND Product_bShelves=1 AND beactive='是'");
if (!string.IsNullOrEmpty(TextBox6.Text))
{
sb.AppendFormat(" and Product_Name like('%{0}%')", Library.Lang.Input.Filter(TextBox6.Text));
}
if (!string.IsNullOrEmpty(TextBox1.Text))
{
sb.AppendFormat(" and DrugsBase_Manufacturer like('%{0}%')", Library.Lang.Input.Filter(TextBox1.Text));
}
if (!string.IsNullOrEmpty(TextBox2.Text))
{
sb.AppendFormat(" and DrugsBase_ApprovalNumber like('%{0}%')", Library.Lang.Input.Filter(TextBox2.Text));
}
if (DropDownList2.SelectedValue == "1")
{
sb.Append(" and stock>0");
}
else if (DropDownList2.SelectedValue == "2")
{
sb.Append(" and stock<1");
}
if (DropDownList1.SelectedValue == "1")
{
sb.Append(" and product_id in (SELECT DISTINCT ProId FROM dbo.OrderProduct) ");
}
else if (DropDownList1.SelectedValue == "2")
{
sb.Append(" and product_id not in (SELECT DISTINCT ProId FROM dbo.OrderProduct) ");
}
#endregion
var dt = bll.GetListByPage("Product", "*,(SELECT iden FROM dbo.Product_Centre WHERE product_id=T.Product_ID) iden,ISNULL((SELECT 1 FROM DrugsBase_ZYC WHERE DrugsBase_ID=T.DrugsBase_ID),0) is_ZYC", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, "product_id desc", sb.ToString(), out recordCount, out pageCount);
tablist.DataSource = dt;
AspNetPager1.RecordCount = recordCount;
tablist.DataBind();
foreach (GridViewRow item in tablist.Rows)
{
var Label1 = item.FindControl("Label1") as Label;
if (Label1 != null)
{
Label1.Text = Public.GetSpecificationAndS(dt.Rows[item.RowIndex]);
}
}
}
public string GetNotFiling(string authKey)
{
if (authKey == key)
{
SOSOshop.BLL.Order.Orders bll = new SOSOshop.BLL.Order.Orders();
return(string.Join(",", bll.ExecuteTable("SELECT MobilePhone FROM dbo.memberinfo a INNER JOIN dbo.memberaccount b ON b.UID = a.UID WHERE a.Code=''").AsEnumerable().Select(x => "'" + x.Field <string>("MobilePhone") + "'")));
}
return("");
}
public List <SOSOshop.BLL.Order.OrderList> GetOrderList(string authKey)
{
if (authKey == key)
{
SOSOshop.BLL.Order.Orders bll = new SOSOshop.BLL.Order.Orders();
return(bll.GetOrdersMQ_1());
}
return(null);
}
/// <summary>
/// 定时分单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
while (true)
{
try
{
SOSOshop.BLL.Order.Orders bll = new SOSOshop.BLL.Order.Orders();
bll.AsySplitOrder();
}
catch (Exception ex)
{
SOSOshop.BLL.Logs.Log.LogServiceAdd(ex.Message, 0, "", "定时分单backgroundWorker1_DoWork", ex.ToString(), 2);
}
System.Threading.Thread.Sleep(20 * 1000);
}
}
//分页数据初始化
protected override void StartLoad(int PageIndex, string strWhere)
{
bll = new SOSOshop.BLL.Order.Orders();
int recordCount, pageCount;
AspNetPager1.PageSize = 10;
#region 搜索条件
System.Text.StringBuilder sb = new StringBuilder();
//只有查看自己的权限
if (!SOSOshop.BLL.PowerPass.isPass("001030002"))
{
if (SOSOshop.BLL.PowerPass.isPass("001030001"))
{
sb.AppendFormat(" AND product_id_02 IN (select p1.product_id from dbo.spzl p1 inner join dbo.spzl_jg p2 on p1.spid=p2.spid AND p1.sx1=p2.jigid AND p2.cgy='{0}')", adminInfo.AdminName);
}
}
if (!string.IsNullOrEmpty(TextBox6.Text))
{
sb.AppendFormat(" and Product_Name like('%{0}%')", Library.Lang.Input.Filter(TextBox6.Text));
}
if (!string.IsNullOrEmpty(TextBox1.Text))
{
sb.AppendFormat(" and DrugsBase_Manufacturer like('%{0}%')", Library.Lang.Input.Filter(TextBox1.Text));
}
if (!string.IsNullOrEmpty(TextBox2.Text))
{
sb.AppendFormat(" and DrugsBase_ApprovalNumber like('%{0}%')", Library.Lang.Input.Filter(TextBox2.Text));
}
if (!string.IsNullOrEmpty(TextBox4.Text))
{
sb.AppendFormat(" and product_id in (SELECT ProId FROM dbo.OrderProduct a INNER JOIN dbo.Orders b ON a.OrderId = b.OrderId WHERE AddTime>'{0}' AND Status<6 AND Status<>4 AND b.OrderStatus>0 AND b.OrderStatus<>4 )", TextBox4.Text);
}
if (!string.IsNullOrEmpty(TextBox5.Text))
{
sb.AppendFormat(" and product_id in (SELECT ProId FROM dbo.OrderProduct a INNER JOIN dbo.Orders b ON a.OrderId = b.OrderId WHERE AddTime<'{0}' AND Status<6 AND Status<>4 AND b.OrderStatus>0 AND b.OrderStatus<>4 )", TextBox5.Text);
}
#endregion
sb.Append(" AND Stock2>0");
var dt = bll.GetListByPage("View_Stock_Lock", "*,ISNULL((SELECT 1 FROM DrugsBase_ZYC WHERE DrugsBase_ID=T.DrugsBase_ID),0) is_ZYC", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, "Stock2 desc", sb.ToString(), out recordCount, out pageCount);
tablist.DataSource = dt.GetSpecification();
AspNetPager1.RecordCount = recordCount;
tablist.DataBind();
}
//分页数据初始化
protected override void StartLoad(int PageIndex, string strWhere)
{
if (!IsPostBack)
{
SelectEditer();
//BindOutSellPerson();
}
bll = new SOSOshop.BLL.Order.Orders();
int recordCount, pageCount;
AspNetPager1.PageSize = 10;
#region 搜索条件
System.Text.StringBuilder sb = new StringBuilder();
SOSOshop.Model.AdminInfo aInfo = null;
aInfo = SOSOshop.BLL.AdministrorManager.Get();
if (!SOSOshop.BLL.PowerPass.isPass("005004001") && SOSOshop.BLL.PowerPass.isPass("005004005"))
{
//外销按地区
if (bll.ExecuteScalar("SELECT role FROM dbo.yxs_administrators WHERE adminid=" + UserId).ToString().Contains("60"))
{
sb.AppendFormat(" and ReceiverId IN (SELECT UID FROM dbo.memberinfo WHERE Borough IN (SELECT ResponseCounty FROM ResponseRegionsOfOutSellPerson WHERE PersonID={0})) ", aInfo.AdminId);
}
else
{
sb.AppendFormat(" and ReceiverId IN (SELECT uid FROM dbo.memberinfo WHERE Editer={0} or OSPId={0}) ", aInfo.AdminId);
}
}
//订单号
string OrderId = TextBox6.Text;
if (!string.IsNullOrEmpty(Request.QueryString["OrderId"]))
{
OrderId = Request.QueryString["OrderId"];
TextBox6.Text = OrderId;
}
if (!string.IsNullOrEmpty(OrderId))
{
string[] OrderIds = OrderId.Split(',');
if (OrderIds.Length > 1)
{
sb.Append(" and OrderId IN ('" + string.Join("','", OrderIds) + "')");
}
else
{
sb.AppendFormat(" and OrderId like('%{0}%')", OrderId);
}
}
//买家姓名
if (!string.IsNullOrEmpty(TextBox1.Text))
{
sb.AppendFormat(" and UserName like('%{0}%')", TextBox1.Text);
}
//买家单位
if (!string.IsNullOrEmpty(TextBox2.Text))
{
sb.AppendFormat(" and parentCorpName like('%{0}%')", TextBox2.Text);
}
//买家类型
if (DropDownList1.SelectedValue != "0")
{
sb.AppendFormat(" and ReceiverId in (SELECT UID FROM dbo.memberaccount WHERE CompanyClass='{0}')", DropDownList1.SelectedValue);
}
//品种
if (!string.IsNullOrEmpty(TextBox3.Text))
{
sb.AppendFormat(" and orderid in (SELECT OrderId FROM OrderProduct WHERE ProName LIKE('%{0}%'))", TextBox3.Text);
}
//付款方式
if (DropDownList2.SelectedValue != "0")
{
sb.AppendFormat(" and Payment={0}", DropDownList2.SelectedValue);
}
//订单状态
if (DropDownListStatus.SelectedValue != "0")
{
//已经支付也算成待审核
if (DropDownListStatus.SelectedValue == "1")
{
sb.Append(" and (OrderStatus=3 or OrderStatus=1)");
}
else
{
sb.AppendFormat(" and OrderStatus={0}", DropDownListStatus.SelectedValue);
}
}
if (!Library.Lang.DataValidator.isNULL(TextBox4.Text, TextBox5.Text))
{
sb.AppendFormat(" and (ShopDate>'{0}' and ShopDate<'{1}')", TextBox4.Text, DateTime.Parse(TextBox5.Text).AddHours(24));
}
//交易员
if (ddlEditer.SelectedIndex > 0)
{
sb.AppendFormat(" and EXISTS(SELECT * FROM memberinfo WHERE UID=t.ReceiverId and Editer=" + ddlEditer.SelectedValue + ")");
}
//生产厂家
if (!string.IsNullOrEmpty(txtManufacturer.Text.Trim()))
{
sb.AppendFormat(" AND orderid IN (SELECT OrderId FROM dbo.OrderProduct a INNER JOIN dbo.Product b ON a.ProId=b.Product_ID WHERE b.DrugsBase_Manufacturer LIKE('%{0}%')) ", txtManufacturer.Text.Trim());
}
//批准文号
if (!string.IsNullOrEmpty(txtApprovalNumber.Text.Trim()))
{
sb.AppendFormat(" AND orderid IN (SELECT OrderId FROM dbo.OrderProduct a INNER JOIN dbo.Product b ON a.ProId=b.Product_ID WHERE b.DrugsBase_ApprovalNumber LIKE('%{0}%')) ", txtApprovalNumber.Text.Trim());
}
#endregion
var dt = bll.GetListByPage("Orders", @"*,
(SELECT COUNT(1) FROM OrderProduct WHERE OrderId=t.orderid) pcount,
(SELECT TOP 1 ProName FROM OrderProduct WHERE OrderId=t.orderid )ProName,
isnull((SELECT IsSpecialTrade FROM memberpermission WHERE UID=t.ReceiverId),0)IsSpecialTrade,
(SELECT name FROM yxs_administrators as a INNER JOIN memberinfo as m ON a.adminid=m.Editer WHERE m.UID=t.ReceiverId)adminname",
AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, "ShopDate desc", sb.ToString(), out recordCount, out pageCount);
tablist.DataSource = dt;
AspNetPager1.RecordCount = recordCount;
tablist.DataBind();
//统计数据
if (recordCount > 0)
{
string sql = "select OrderId,TotalPrice into #T038 from Orders t where 1=1 " + sb + " SELECT (SELECT COUNT(DISTINCT ProId) FROM OrderProduct WHERE OrderId IN (select OrderId from #T038)) c_pcount, (SELECT sum(TotalPrice) from #T038) c_TotalPrice DROP TABLE #T038";
DataSet ds = bll.ExecuteDataSet(sql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
c_pcount = int.Parse(ds.Tables[0].Rows[0][0].ToString());
c_TotalPrice = decimal.Parse(ds.Tables[0].Rows[0][1].ToString());
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
#region 是否符合功能处理全新
if ((int)dt.Rows[i]["OrderStatus"] != 1 && (int)dt.Rows[i]["OrderStatus"] != 3)//订单状态如果不等于已提交则不能取消
{
tablist.Rows[i].FindControl("LinkButton1").Visible = false;
}
//先隐藏审核按钮
tablist.Rows[i].FindControl("LinkButton2").Visible = false;
//显示确认支付按钮（1订单状态未取消，未确认支付，审核,和是货到付款的订单）
if ((int)dt.Rows[i]["OrderStatus"] < 3 && (int)dt.Rows[i]["OrderStatus"] != 2 && (int)dt.Rows[i]["OrderStatus"] > 0 && (int)dt.Rows[i]["Payment"] == 2)
{
tablist.Rows[i].FindControl("LinkButton2").Visible = true;
}
//订单已被拆分
if ((int)dt.Rows[i]["OrderType"] == 0)
{
tablist.Rows[i].FindControl("LinkButton1").Visible = false;
tablist.Rows[i].FindControl("LinkButton2").Visible = false;
}
#endregion
#region 确认是否有权限
if (!SOSOshop.BLL.PowerPass.isPass("005004002"))//是否有取消订单的权限
{
tablist.Rows[i].FindControl("LinkButton1").Visible = false;
}
if (!SOSOshop.BLL.PowerPass.isPass("005004003"))//是否有确认支付的权限
{
tablist.Rows[i].FindControl("LinkButton2").Visible = false;
}
//是快捷交易的订单不能处理
if (1 == int.Parse(dt.Rows[i]["IsSpecialTrade"].ToString()))
{
//tablist.Rows[i].FindControl("LinkButton1").Visible = false;
tablist.Rows[i].FindControl("LinkButton2").Visible = false;
}
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SOSOshop.BLL.PromptInfo.Popedom("008009014", "对不起，您没有权限进行查看");
int uid = 0; int.TryParse(Request["UID"], out uid);
SOSOshop.Model.MemberAccount a = null;
SOSOshop.Model.MemberInfo b = null;
SOSOshop.Model.MemberPermission c = null;
if (uid > 0)
{
//查询数据
a = new SOSOshop.BLL.MemberAccount().GetModel(uid);
if (a != null)
{
b = new SOSOshop.BLL.MemberInfo().GetModel(uid);
}
if (a != null)
{
c = new SOSOshop.BLL.MemberPermission().GetModelWithNoCache(uid);
}
}
if (a != null && b != null && c != null)
{
//买家ID
this.hfUID.Value = uid.ToString();
//买家单位
this.ltlMemberinfo.Text = string.Format("<b>{0}</b> <b>{1}</b> <span>（类别：{2} {3}）</span>",
new SOSOshop.BLL.DbBase().ExecuteScalar("select Name from DrugsBase_Enterprise where ID=" + b.ParentId),
b.TrueName,
a.UserType >= 0 ? Enum.GetName(typeof(SOSOshop.Model.MemberKeyValue.UserType), a.UserType) : "",
b.Member_Class >= 0 ? Enum.GetName(typeof(SOSOshop.Model.MemberKeyValue.Member_Class), b.Member_Class) : "");
//权限列表
this.cb_IsCOD.SelectedValue = c.IsCOD ? "1" : "0";
this.cb_IsLookPrice_01.SelectedValue = c.IsLookPrice_01 ? "1" : "0";
this.cb_IsLookPrice_02.SelectedValue = c.IsLookPrice_02 ? "1" : "0";
this.cb_IsLookProduct_01.SelectedValue = c.IsLookProduct_01 ? "1" : "0";
this.cb_IsLookProduct_02.SelectedValue = c.IsLookProduct_02 ? "1" : "0";
this.cb_IsLookStock.SelectedValue = c.IsLookStock ? "1" : "0";
this.cb_IsMoneyAndShipping.SelectedValue = c.IsMoneyAndShipping ? "1" : "0";
this.cb_IsPeriodicalSettle.SelectedValue = c.IsPeriodicalSettle ? "1" : "0";
this.cb_IsTrade.SelectedValue = c.IsTrade ? "1" : "0";
this.cb_IsPriorDistribution.SelectedValue = c.IsPriorDistribution ? "1" : "0";
this.cb_IsShippingFor48h.SelectedValue = c.IsShippingFor48h ? "1" : "0";
this.cb_IsSpecialTrade.SelectedValue = c.IsSpecialTrade ? "1" : "0";
//授权
bool isCheckUp = SOSOshop.BLL.PowerPass.isPass("008009014");
this.cb_IsCOD.Enabled = isCheckUp;
this.cb_IsLookPrice_01.Enabled = isCheckUp;
this.cb_IsLookPrice_02.Enabled = isCheckUp;
this.cb_IsLookProduct_01.Enabled = isCheckUp;
this.cb_IsLookProduct_02.Enabled = isCheckUp;
this.cb_IsLookStock.Enabled = isCheckUp;
this.cb_IsMoneyAndShipping.Enabled = isCheckUp;
this.cb_IsPeriodicalSettle.Enabled = isCheckUp;
this.cb_IsTrade.Enabled = isCheckUp;
this.cb_IsPriorDistribution.Enabled = isCheckUp;
this.cb_IsShippingFor48h.Enabled = isCheckUp;
this.cb_IsSpecialTrade.Enabled = isCheckUp;
//建档通过
bool bBuyFilingStatus = 1 == _101shop.admin.v3.member.BuyerLib.GetGSP(uid);
this.cb_IsSpecialTrade.Enabled = !bBuyFilingStatus && a.State == 0;//已审核的未建档的才能开通快捷交易的权限
//权限【拥有快捷开通交易的权限】, 第一次建档状态.通过 > 允许已经建档通过的会员的定单可以执行流程
int UID_BuyFilingStatus = (bBuyFilingStatus ? 1 : 0);
//var lbll = new SOSOshop.BLL.Logs.Log("LogService");
string oks = "买家" + b.Code + "的建档已经通过";
if (UID_BuyFilingStatus > 0 && c.IsSpecialTrade && !b.Code.StartsWith("del", StringComparison.CurrentCultureIgnoreCase))
{
SOSOshop.BLL.Order.Orders obll = new SOSOshop.BLL.Order.Orders();
obll.LetOrders2(b.Code, "一级单位");
//SOSOshop.BLL.Logs.Log.LogServiceAdd(oks, uid, b.TrueName, "往来单位消息处理1", "同步商城买家" + b.Code + "成功！", 0);
}
if (b.Member_Class != 0)
{
cb_IsPriorDistribution.Enabled = false;
c.IsPriorDistribution = false;
cb_IsPriorDistribution.SelectedValue = "0";
}
}
else
{
Response.Write("<center><br><h3>未知买家！</h3>"); Response.End();
}
}
}
