protected void Page_Load(object sender, EventArgs e)
{
//user = LoginModel.IsLogined(this);
//dis = new Hi.BLL.BD_Distributor().GetModel(user.DisID);
//if (!IsPostBack)
// user = LoginModel.IsLogined(this);
//if (user != null)
//{
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (!IsPostBack)
{
this.txtPager.Value = "12";
if (Request.QueryString["type"] == "1")
{
this.txtArriveDate.Value = DateTime.Now.AddDays(1 - DateTime.Now.Day).ToString("yyyy-MM-dd");
this.txtArriveDate1.Value = DateTime.Now.ToString("yyyy-MM-dd");
}
else if (Request.QueryString["type"] + "" == "2")
{
this.txtArriveDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
this.txtArriveDate1.Value = DateTime.Now.ToString("yyyy-MM-dd");
}
Common.ListComps(this.ddrComp, this.UserID.ToString(), this.CompID.ToString());
ViewState["strwhere"] = Where();
Bind();
}
//}
}
protected void Page_Load(object sender, EventArgs e)
{
//user = LoginModel.IsLogined(this);
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (!IsPostBack)
{
txtPager.Value = "12";
Bind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (!IsPostBack)
{
this.txtPager.Value = "12";
this.txtArriveDate.Value = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd");
this.txtArriveDate1.Value = DateTime.Now.ToString("yyyy-MM-dd");
ViewState["strwhere"] = Where();
Bind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//user = LoginModel.IsLogined(this);
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (!IsPostBack)
{
txtCreateDate.Value = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd");
txtEndCreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtPager.Value = "12";
Bind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (ConfigurationManager.AppSettings["IsFinancing"] != "1")
{
Response.Redirect("../NoOperable.aspx", true);
Response.End();
}
lblErr.InnerHtml = "";
//user = LoginModel.IsLogined(this);
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (!IsPostBack)
{
DataMoney();
}
}
protected void Page_Load(object sender, EventArgs e)
{
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (!IsPostBack)
{
this.txtPager.Value = "12";
this.txtArriveDate.Value = DateTime.Now.AddDays(1 - DateTime.Now.Day).ToString("yyyy-MM-dd");
this.txtArriveDate1.Value = DateTime.Now.ToString("yyyy-MM-dd");
Common.ListComps(this.ddrComp, this.UserID.ToString(), this.CompID.ToString());
ViewState["strwhere"] = Where();
Bind();
}
}
public void Add_Addre()
{
int disid = int.Parse(Request["disid"].ToString());
dis = new Hi.BLL.BD_Distributor().GetModel(disid);
if (dis != null)
{
dis.Address = "";
JavaScriptSerializer js = new JavaScriptSerializer();
string str = js.Serialize(dis);
Response.Clear();
Response.Write(str);
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
user = new Hi.BLL.SYS_Users().GetModel(this.UserID);
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (Request["code"] != null)
{
Hi.Model.SYS_PhoneCode phonecode = new Hi.BLL.SYS_PhoneCode().GetModel("支付密码找回", user.Phone, Common.DesDecrypt(Request.QueryString["code"], Common.EncryptKey));
if (phonecode == null)
{
Response.Redirect("PayPWDEdit.aspx", true);
}
}
else
{
Response.Redirect("PayPWDEdit.aspx", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//user = LoginModel.IsLogined(this);
//string DisId = Request["disId"] + "";
this.hidID.Value = this.DisID.ToString();
Phone = new Hi.BLL.SYS_Users().GetModel(this.UserID).Phone;
dis = new Hi.BLL.BD_Distributor().GetModel(DisID);
if (dis != null)
{
disphone = dis.Phone;
}
else
{
disphone = "该代理商不存在";
}
Bind(DisID.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
user = new Hi.BLL.SYS_Users().GetModel(this.UserID);
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (!IsPostBack)
{
if (Request.QueryString["type"] != null && Request.QueryString["type"].ToString() == "zhifu" && Request["ordid"] != null)
{
updatepay.Style["display"] = "none";
PhonePay.Style["display"] = "block";
hidfh.Value = Request.QueryString["ordid"].ToString();
OrderID = Request.QueryString["ordid"].ToString();
}
if (Request.QueryString["type"] != null && Request.QueryString["type"] == "1")
{
A_Affirm();
}
if ((user.IsFirst == 0 || user.IsFirst == 1) && TypeID == 5)
{
paypwdli.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new Hi.BLL.BD_DisAddr().GetModel(this.DisID.ToString());
coutn = (ds.Tables[0].Rows.Count + 1).ToString();
rptdelivery.DataSource = ds;
rptdelivery.DataBind();
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (dis != null)
{
Principal = dis.Principal;
Phone = dis.Phone;
ID = dis.ID.ToString();
}
string phone = new Hi.BLL.SYS_Users().GetModel(this.UserID).Phone;
phones = AESHelper.Encrypt_php(phone);
userphone = phone.Substring(0, 3) + "*****" + phone.Substring(phone.Length - 4);
if (!string.IsNullOrEmpty(Request["type"]) && Request["type"].ToString() == "add")
{
Add_Addre();
}
}
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 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);
}
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session != null)
{
logUser = Session["UserModel"] as LoginModel;
dis = new Hi.BLL.BD_Distributor().GetModel(logUser.DisID);
//com = new Hi.BLL.BD_Company().GetModel(logUser.CompID);
//if (com != null)
//{
// string lg = com.CompLogo;
// logo = lg == "" ? "../Config/image/logo8.jpg" : System.Configuration.ConfigurationManager.AppSettings["ImgViewPath"] + "CompImage/" + lg;
//}
if (logUser.Url != null)
{
//罗汉
if (logUser.Url.IndexOf("lhhome") != -1)
{
bol = true;
}
//酒隆仓
if (logUser.Url.IndexOf("jlc") != -1)
{
bol = true;
}
}
Hi.Model.SYS_Users sysuser = new Hi.BLL.SYS_Users().GetModel(logUser.UserID);
if (sysuser.TrueName != null && sysuser.TrueName.ToString() != "")
{
ShowName = sysuser.TrueName.ToString();
}
else
{
ShowName = sysuser.UserName.ToString();
}
if (ShowName.Length > 6)
{
ShowName = ShowName.Substring(0, 6) + "...";
}
}
DataTable dt = new Hi.BLL.DIS_ShopCart().GetGoodsCart(" sc.[CompID]=" + logUser.CompID + " and sc.[DisID]=" + logUser.DisID + "and sc.dr=0", "sc.[CreateDate] desc ");
string cart = "";
int i = 0;
if (dt != null && dt.Rows.Count > 0)
{
//查询购物车商品数量、总价
DataTable dtsum = new Hi.BLL.DIS_ShopCart().SumCartNum(logUser.CompID.ToString(), logUser.DisID.ToString());
if (dtsum != null && dtsum.Rows.Count > 0)
{
this.Top_CartNum.InnerText = dtsum.Rows[0]["cart"].ToString().ToDecimal(0).ToString("0");
}
foreach (DataRow item in dt.Rows)
{
i++;
if (i > 4)
{
cart += "<div class=\"border\"><span>购物车还有<span id=\"num\">" + (dtsum.Rows[0]["cart"].ToString().ToDecimal(0) - 4) + "</span>个商品</span><a class=\"cklink\" href=\"" + ResolveUrl("../Distributor/Shop.aspx") + "\">去购物车</a></div>";
break;
}
cart += "<i class=\"GoGoodsInfo\" goods_tip=\"" + item["GoodsID"] + "\" tip=\"" + item["GoodsinfoID"] + "\">" + Common.MySubstring(item["GoodsName"].ToString(), 15, "...") + "<span class=\"goodsnum\"> " + item["GoodsNum"].ToString().ToDecimal(0).ToString("0") + "</span><span>x</span></i>";
}
}
cart = !string.IsNullOrEmpty(cart) ? cart : "<i tip=\"title\">购物车中还没有商品，赶紧选购吧！</i>";
this.tgnCar.InnerHtml = cart;
}
public ResultJSC GetDisNum(string JSon)
{
try
{
#region JSon取值
string UserID = string.Empty;
string DisID = string.Empty;
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo.Count > 0 && JInfo["UserID"].ToString() != "" && JInfo["DisID"].ToString() != "")
{
UserID = JInfo["UserID"].ToString();
DisID = JInfo["DisID"].ToString();
}
else
{
return(new ResultJSC()
{
Result = "F", Description = "参数异常"
});
}
if (!new Common().IsLegitUser(int.Parse(UserID), out user, 0, int.Parse(DisID)))
{
return new ResultJSC()
{
Result = "F", Description = "未找到用户信息"
}
}
;
dis = new Hi.BLL.BD_Distributor().GetModel(Convert.ToInt32(DisID));
if (dis == null)
{
return new ResultJSC()
{
Result = "F", Description = "未找到经销商信息"
}
}
;
#endregion
//获取当前时间
DateTime date = DateTime.Now;
//当天0点0分
DateTime day0 = new DateTime(date.Year, date.Month, date.Day, 0, 0, 0);
//当月第一天
DateTime day1 = new DateTime(date.Year, date.Month, 1);
//获取当前时间加一天
DateTime Sday = date.AddDays(1);
#region 本月订单
List <Hi.Model.DIS_Order> orderl = new Hi.BLL.DIS_Order().GetList("",
" isnull(dr,0)=0 and Otype!=9 and CompID=" + dis.CompID + " and DisID=" + dis.ID, "");
if (orderl != null)
{
if (orderl.Count > 0)
{
//待支付订单
string strwhere =
" (( Otype=1 and OState not in (-1,0,1) and PayState in (0,1) ) or( Otype<>1 and OState in(2,4,5) and PayState in (0,1) )) and OState<>6 and DisID='" +
dis.ID + "' and ReturnState in(0,1) and isnull(dr,0)=0";
List <Hi.Model.DIS_Order> ol = new Hi.BLL.DIS_Order().GetList("", strwhere, "");
if (ol != null && ol.Count > 0)
{
payCount = ol.Count;
}
//待收货订单
ReceiveCount = orderl.FindAll(p => p.OState == (int)Enums.OrderState.已发货).Count;
//赊销订单
salesorder = orderl.FindAll(p => p.Otype == (int)Enums.OType.赊销订单).Count;
//当天订单数
dayOrderCount =
orderl.FindAll(
p =>
p.ReturnState == (int)Enums.ReturnState.未退货 &&
p.CreateDate >= day0).Count;
//本月订单数
orderCount =
orderl.FindAll(
p =>
p.ReturnState == (int)Enums.ReturnState.未退货 &&
p.CreateDate >= Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM"))).Count;
}
}
#endregion
#region 当天订购额
string daysql = "SELECT SUM(sumAmount) as sumAmount FROM [dbo].[MonthSaleRpt_view] where DisID=" +
dis.ID + " and CompID=" + dis.CompID + " and CreateDate>='" + day0 + "'";
DataTable dayDt = SqlHelper.Query(SqlHelper.LocalSqlServer, daysql).Tables[0];
if (dayDt != null)
{
if (dayDt.Rows.Count > 0)
{
decimal sumAmount = dayDt.Rows[0]["sumAmount"].ToString() == ""
? sum.ToString().ToDecimal()
: Convert.ToDecimal(dayDt.Rows[0]["sumAmount"]);
DaySum = (sumAmount / 10000).ToString();
}
}
#endregion
#region 本月订购额
string monthsql = "SELECT SUM(sumAmount) as sumAmount FROM [dbo].[MonthSaleRpt_view] where DisID=" +
dis.ID + " and CompID=" + dis.CompID + " and CreateDate>='" + day1 +
"' and CreateDate<='" + Sday + "'";
DataTable monthDt = SqlHelper.Query(SqlHelper.LocalSqlServer, monthsql).Tables[0];
if (monthDt != null)
{
if (monthDt.Rows.Count > 0)
{
decimal sumAmount = monthDt.Rows[0]["sumAmount"].ToString() == ""
? sum.ToString().ToDecimal()
: Convert.ToDecimal(monthDt.Rows[0]["sumAmount"]);
MonthSum = (sumAmount / 10000).ToString();
}
}
#endregion
#region 当天付款额
//付款额
string daypaggersql = "SELECT SUM(Price) as Price FROM [dbo].[CompCollection_view] where DisID=" + dis.ID +
"and CompID=" + dis.CompID + " and Date>='" + day0 + "' and Date<='" + Sday + "'";
DataTable daypaggerdt = SqlHelper.Query(SqlHelper.LocalSqlServer, daypaggersql).Tables[0];
if (daypaggerdt != null)
{
if (daypaggerdt.Rows.Count > 0)
{
decimal Price = daypaggerdt.Rows[0]["Price"].ToString() == ""
? sum.ToString().ToDecimal()
: Convert.ToDecimal(daypaggerdt.Rows[0]["Price"]);
DayPaymentSum = (Price / 10000).ToString();
}
}
#endregion
#region 本月付款额
//本月付款额
string paggersql = "SELECT SUM(Price) as Price FROM [dbo].[CompCollection_view] where DisID=" + dis.ID +
"and CompID=" + dis.CompID + " and Date>='" + day1 + "' and Date<='" + Sday + "'";
DataTable paggerdt = SqlHelper.Query(SqlHelper.LocalSqlServer, paggersql).Tables[0];
if (paggerdt != null)
{
if (paggerdt.Rows.Count > 0)
{
decimal Price = paggerdt.Rows[0]["Price"].ToString() == ""
? sum.ToString().ToDecimal()
: Convert.ToDecimal(paggerdt.Rows[0]["Price"]);
PaymentSum = (Price / 10000).ToString();
}
}
#endregion
#region 本月应付额
//本月应付额
decimal AuditAmount = 0;
decimal payAmount = 0;
//赊销订单 未支付的
//string ArrearageSql = "SELECT SUM(AuditAmount) as AuditAmount FROM [dbo].[ArrearageRpt_view] where DisID=" + user.DisID + "and CompID=" + user.CompID + " and CreateDate>='" + day1 + "' and CreateDate<='" + Sday + "'";
//DataTable ArrearageDt = SqlHelper.Query(SqlHelper.LocalSqlServer, ArrearageSql).Tables[0];
//if (ArrearageDt != null)
//{
// if (ArrearageDt.Rows.Count > 0)
// {
// AuditAmount = ArrearageDt.Rows[0]["AuditAmount"].ToString() == "" ? sum.ToString().ToDecimal() : Convert.ToDecimal(ArrearageDt.Rows[0]["AuditAmount"]);
// }
//}
//未支付订单金额
string paysql =
" select SUM(AuditAmount) as AuditAmount from DIS_Order where (( Otype=1 and OState not in (-1,0,1) and PayState=0 ) or( Otype<>1 and OState=2 and PayState=0 )) and OState<>6 and ReturnState=0 and isnull(dr,0)=0 and CompID=" +
dis.CompID + " and DisID=" + dis.ID + " and CreateDate>='" + day1 + "' and CreateDate<='" + Sday +
"'";
DataTable payDt = SqlHelper.Query(SqlHelper.LocalSqlServer, paysql).Tables[0];
if (payDt != null && payDt.Rows.Count > 0)
{
payAmount = payDt.Rows[0]["AuditAmount"].ToString() == ""
? 0
: payDt.Rows[0]["AuditAmount"].ToString().ToDecimal(0);
}
PayableSum = ((payAmount + AuditAmount) / 10000).ToString();
#endregion
return(new ResultJSC()
{
Result = "T",
Description = "返回正确",
MonthSum = MonthSum,
OrderCount = orderCount.ToString(),
PaymentSum = PaymentSum,
PayableSum = PayableSum,
DayPaymentSum = DayPaymentSum,
DaySum = DaySum,
DayOrderCount = dayOrderCount.ToString()
});
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetDisNum:" + JSon);
return(new ResultJSC()
{
Result = "F", Description = "参数异常"
});
}
}
public static string Edit(string KeyID, string CompID, string DisID, string UserID, string HtID, string ForceDate, string InvalidDate, string HidFfileName1, string validDate1, string HidFfileName2, string validDate2, string HidFfileName3, string validDate3, string HidFfileName4, string validDate4, string ApplyRemark)
{
//
Common.ResultMessage Msg = new Common.ResultMessage();
Hi.Model.YZT_CMerchants cmModel = new Hi.BLL.YZT_CMerchants().GetModel(KeyID.ToInt(0));
Hi.Model.YZT_FirstCamp firstcamp = new Hi.Model.YZT_FirstCamp();
//判断是否是该厂商的代理商
List <Hi.Model.SYS_CompUser> compulist = new Hi.BLL.SYS_CompUser().GetList("", " UserID=" + UserID + " and CompID=" + CompID + " and DisID=" + DisID + "", "");
Hi.Model.SYS_Users usersModel = new Hi.BLL.SYS_Users().GetModel(UserID);
//首营信息
string sql = "select an.*,fc.ID from YZT_Annex an left join YZT_FCmaterials fc on an.fcID =fc.ID and an.fileAlias in (4) and an.type in(5,7,8,9) where fc.DisID=" + DisID + " and ISNULL(fc.dr,0)=0 and fc.type=2 and ISNULL(an.dr,0)=0";
DataTable dt = SqlHelper.GetTable(SqlHelper.LocalSqlServer, sql);
LoginModel uModel = null;
if (HttpContext.Current.Session["UserModel"] is LoginModel)
{
uModel = HttpContext.Current.Session["UserModel"] as LoginModel;
}
SqlTransaction Tran = null;
try
{
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
if (DisID == "0")
{
Hi.Model.BD_Distributor Distributor = new Hi.Model.BD_Distributor();
Distributor.CompID = 0;
Distributor.DisName = uModel.CompName;
Distributor.IsEnabled = 1;
Distributor.Paypwd = Util.md5("123456");
Distributor.Phone = uModel.Phone;
Distributor.AuditState = 0;
Distributor.CreateDate = DateTime.Now;
Distributor.CreateUserID = uModel.UserID;
Distributor.ts = DateTime.Now;
Distributor.modifyuser = uModel.UserID;
Distributor.IsCheck = 0;
Distributor.CreditType = 0;
Distributor.pic = "";
//Distributor.creditCode = txt_creditCode;
Distributor.Leading = "";
Distributor.Licence = "";
int DistributorID = 0;
if ((DistributorID = new Hi.BLL.BD_Distributor().Add(Distributor, Tran)) > 0)
{
DisID = DistributorID.ToString();
//代理商账户登录
Hi.Model.SYS_CompUser compuser = new Hi.Model.SYS_CompUser();
compuser.UserID = UserID.ToInt(0);
compuser.CompID = CompID.ToInt(0);
compuser.DisID = DisID.ToInt(0);
compuser.AreaID = 0;
compuser.RoleID = usersModel == null ? 0 : usersModel.RoleID;
compuser.CType = 2;
compuser.UType = 5;
compuser.IsAudit = 0;
compuser.IsEnabled = 1;
compuser.ts = DateTime.Now;
compuser.CreateUserID = UserID.ToInt(0);
compuser.modifyuser = UserID.ToInt(0);
compuser.CreateDate = DateTime.Now;
if (new Hi.BLL.SYS_CompUser().Add(compuser, Tran) <= 0)
{
Tran.Rollback();
Msg.code = "用户信息添加失败";
return(new JavaScriptSerializer().Serialize(Msg));
}
}
else
{
Tran.Rollback();
Msg.code = "用户信息添加失败";
return(new JavaScriptSerializer().Serialize(Msg));
}
}
else
{
if (compulist != null && compulist.Count <= 0)
{
//代理商账户登录
Hi.Model.SYS_CompUser compuser = new Hi.Model.SYS_CompUser();
compuser.UserID = UserID.ToInt(0);
compuser.CompID = CompID.ToInt(0);
compuser.DisID = DisID.ToInt(0);
compuser.AreaID = 0;
compuser.RoleID = usersModel == null ? 0 : usersModel.RoleID;
compuser.CType = 2;
compuser.UType = 5;
compuser.IsAudit = 0;
compuser.IsEnabled = 1;
compuser.ts = DateTime.Now;
compuser.CreateUserID = UserID.ToInt(0);
compuser.modifyuser = UserID.ToInt(0);
compuser.CreateDate = DateTime.Now;
if (new Hi.BLL.SYS_CompUser().Add(compuser, Tran) <= 0)
{
Tran.Rollback();
Msg.code = "用户信息添加失败";
return(new JavaScriptSerializer().Serialize(Msg));
}
}
}
List <Hi.Model.YZT_FirstCamp> fcamplist = new Hi.BLL.YZT_FirstCamp().GetList("", " CMID=" + KeyID + " and DisID=" + DisID + " and CompID=" + CompID + " and HtID=" + HtID, "");
if (fcamplist != null && fcamplist.Count > 0)
{
Tran.Rollback();
Msg.code = "已申请合作";
return(new JavaScriptSerializer().Serialize(Msg));
}
firstcamp.CMID = KeyID.ToInt(0);
firstcamp.CompID = CompID.ToInt(0);
firstcamp.DisID = DisID.ToInt(0);
firstcamp.ForceDate = ForceDate != "" ? Convert.ToDateTime(ForceDate) : DateTime.MinValue;
firstcamp.InvalidDate = InvalidDate != "" ? Convert.ToDateTime(InvalidDate) : DateTime.MinValue;
firstcamp.State = 0;
firstcamp.HtID = HtID.ToInt(0);
firstcamp.Applyremark = ApplyRemark;
firstcamp.ts = DateTime.Now;
firstcamp.modifyuser = UserID.ToInt(0);
firstcamp.CreateDate = DateTime.Now;
firstcamp.CreateUserID = UserID.ToInt(0);
int id = new Hi.BLL.YZT_FirstCamp().Add(firstcamp, Tran);
if (id > 0)
{
//string annexdel = " fileAlias=1 and type in(5,7,9,8) and fcID=" + id;
//new Hi.BLL.YZT_Annex().AnnexDelete(annexdel, Tran);
List <Hi.Model.YZT_FCmaterials> fcmlist = new Hi.BLL.YZT_FCmaterials().GetList("", "DisID=" + DisID + " and type=2", "");
int fcmid = 0;
Hi.Model.YZT_FCmaterials fcmmodel = null;
if (fcmlist != null && fcmlist.Count > 0)
{
fcmmodel = fcmlist[0];
fcmid = fcmmodel.ID;
}
else
{
fcmmodel = new Hi.Model.YZT_FCmaterials();
fcmmodel.CompID = 0;
fcmmodel.DisID = DisID.ToInt(0);
fcmmodel.type = 2;
fcmmodel.ts = DateTime.Now;
fcmmodel.modifyuser = UserID.ToInt(0);
fcmmodel.CreateUserID = UserID.ToInt(0);
fcmmodel.CreateDate = DateTime.Now;
fcmmodel.dr = 0;
fcmid = new Hi.BLL.YZT_FCmaterials().Add(fcmmodel, Tran);
}
int count = id;
string ProvideData = cmModel.ProvideData;
if (ProvideData.IndexOf("1") > -1)
{
//营业执照
Hi.Model.YZT_Annex annexModel1 = insertAnnex(id, 5, HidFfileName1, validDate1, UserID, "1");
count = new Hi.BLL.YZT_Annex().Add(annexModel1, Tran);
Hi.Model.YZT_Annex updateModel1 = UpFCmaterials(dt, 5, HidFfileName1, validDate1, UserID);
if (updateModel1 != null)
{
new Hi.BLL.YZT_Annex().Update(updateModel1, Tran);
}
else
{
Hi.Model.YZT_Annex annexModel11 = insertAnnex(fcmid, 5, HidFfileName1, validDate1, UserID, "4");
new Hi.BLL.YZT_Annex().Add(annexModel11, Tran);
}
}
if (ProvideData.IndexOf("2") > -1)
{
//医疗器械经营许可证
Hi.Model.YZT_Annex annexModel2 = insertAnnex(id, 7, HidFfileName2, validDate2, UserID, "1");
count = new Hi.BLL.YZT_Annex().Add(annexModel2, Tran);
Hi.Model.YZT_Annex updateModel2 = UpFCmaterials(dt, 7, HidFfileName2, validDate2, UserID);
if (updateModel2 != null)
{
new Hi.BLL.YZT_Annex().Update(updateModel2, Tran);
}
else
{
Hi.Model.YZT_Annex annexModel11 = insertAnnex(fcmid, 7, HidFfileName2, validDate2, UserID, "4");
new Hi.BLL.YZT_Annex().Add(annexModel11, Tran);
}
}
if (ProvideData.IndexOf("3") > -1)
{
//开户许可证
Hi.Model.YZT_Annex annexModel3 = insertAnnex(id, 9, HidFfileName3, validDate3, UserID, "1");
count = new Hi.BLL.YZT_Annex().Add(annexModel3, Tran);
Hi.Model.YZT_Annex updateModel3 = UpFCmaterials(dt, 9, HidFfileName3, validDate3, UserID);
if (updateModel3 != null)
{
new Hi.BLL.YZT_Annex().Update(updateModel3, Tran);
}
else
{
Hi.Model.YZT_Annex annexModel11 = insertAnnex(fcmid, 9, HidFfileName3, validDate3, UserID, "4");
new Hi.BLL.YZT_Annex().Add(annexModel11, Tran);
}
}
if (ProvideData.IndexOf("4") > -1)
{
//医疗器械备案
Hi.Model.YZT_Annex annexModel4 = insertAnnex(id, 8, HidFfileName4, validDate4, UserID, "1");
count = new Hi.BLL.YZT_Annex().Add(annexModel4, Tran);
Hi.Model.YZT_Annex updateModel4 = UpFCmaterials(dt, 8, HidFfileName4, validDate4, UserID);
if (updateModel4 != null)
{
new Hi.BLL.YZT_Annex().Update(updateModel4, Tran);
}
else
{
Hi.Model.YZT_Annex annexModel11 = insertAnnex(fcmid, 8, HidFfileName4, validDate4, UserID, "4");
new Hi.BLL.YZT_Annex().Add(annexModel11, Tran);
}
}
if (count <= 0)
{
Tran.Rollback();
Msg.code = "编辑异常！";
return(new JavaScriptSerializer().Serialize(Msg));
}
Tran.Commit();
Msg.result = true;
}
else
{
Tran.Rollback();
Msg.code = "编辑异常！";
}
}
catch (Exception)
{
Msg.code = "编辑异常！";
throw;
}
return(new JavaScriptSerializer().Serialize(Msg));
}
/// <summary>
///核心企业新增经销商
/// </summary>
/// <param name="JSon"></param>
/// <returns></returns>
public ReseltResellerEdit AddReseller(string JSon)
{
string UserID = string.Empty;
string CompID = string.Empty;
try
{
#region//JSon取值
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo["UserID"].ToString().Trim() == "" || JInfo["CompID"].ToString().Trim() == "" || JInfo["Reseller"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "参数异常"
}
}
;
UserID = JInfo["UserID"].ToString();
CompID = JInfo["CompID"].ToString();
JsonData Reseller = JInfo["Reseller"];
//判断登录信息是否异常
Hi.Model.SYS_Users one = new Hi.Model.SYS_Users();
if (!new Common().IsLegitUser(int.Parse(UserID), out one, Int32.Parse(CompID)))
{
return(new ReseltResellerEdit()
{
Result = "F", Description = "登录信息异常"
});
}
//判断核心企业信息是否异常
Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(Int32.Parse(CompID));
if (comp == null || comp.dr == 1 || comp.IsEnabled == 0 || comp.AuditState == 0)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "核心企业信息异常"
}
}
;
#endregion
#region//判断传入的经销商信息是否正确
string resellername = Common.NoHTML(Reseller["ResellerName"].ToString().Trim());
string resellercode = Common.NoHTML(Reseller["ResellerCode"].ToString().Trim());
string address = Common.NoHTML(Reseller["Address"].ToString().Trim());
if (resellername == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入经销商名称"
}
}
;
//判断经销商名字是否已存在
if (Common.DisExistsAttribute("DisName", resellername, CompID.ToString()))
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商名称已经存在"
}
}
;
if (Reseller["ResellerProvince"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请选择经销商地址中的省"
}
}
;
if (Reseller["ResellerCity"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请选择经销商地址中的市"
}
}
;
if (Reseller["ResellerArea"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请选择经销商地址中的区"
}
}
;
if (address == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入经销商地址中的详细地址"
}
}
;
#endregion
#region//判断登录信息的正确信
JsonData account = Reseller["Account"];
string username = Common.NoHTML(account["UserName"].ToString().Trim());
string truename = Common.NoHTML(account["TrueName"].ToString().Trim());
if (account["UserName"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入登录账号"
}
}
;
//判断登录账号是否已经存在
if (Common.GetUserExists(username))
{
return new ReseltResellerEdit()
{
Result = "F", Description = "该登录账号已存在"
}
}
;
if (truename == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入姓名"
}
}
;
if (account["Phone"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请登录信息中的手机号码"
}
}
;
//判断手机号有没被注册过
Regex Phonereg = new Regex("^0?(13[0-9]|15[012356789]|18[0-9]|14[57]|17[7])[0-9]{8}$");
if (!Phonereg.IsMatch(account["Phone"].ToString()))
{
return new ReseltResellerEdit()
{
Result = "F", Description = "登录信息中的手机号格式错误"
}
}
;
if (Common.GetUserExists("Phone", account["Phone"].ToString()))
{
return new ReseltResellerEdit()
{
Result = "F", Description = "登录信息中的手机号已被注册"
}
}
;
#endregion
//创建需要导入的经销商实体
Hi.Model.BD_Distributor disModel = new Hi.Model.BD_Distributor();
disModel.CompID = comp.ID;
disModel.DisCode = resellercode;
disModel.DisName = resellername;
//传入分类ID的话，判断分类ID是否正确
if (Reseller["ResellerClassifyID"].ToString().Trim() != "" && Reseller["ResellerClassifyID"].ToString() != "0")
{
Hi.Model.BD_DisType distpye = new Hi.BLL.BD_DisType().GetModel(Int32.Parse(Reseller["ResellerClassifyID"].ToString().Trim()));
if (distpye == null || distpye.CompID != comp.ID)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商分类异常"
}
}
;
if (distpye.dr == 1)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "此经销商分类已被删除"
}
}
;
//if (distpye.IsEnabled != 0)
// return new ReseltResellerEdit() { Result = "F", Description = "此经销商分类已被禁用" };
disModel.DisTypeID = distpye.ID;
}
else
{
disModel.DisTypeID = 0;
}
//传入区域ID的话，判断区域ID是否正确
if (Reseller["AreaID"].ToString().Trim() != "" && Reseller["AreaID"].ToString() != "0")
{
Hi.Model.BD_DisArea disarea = new Hi.BLL.BD_DisArea().GetModel(Int32.Parse(Reseller["AreaID"].ToString().Trim()));
if (disarea == null || disarea.CompanyID != comp.ID)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商区域异常"
}
}
;
if (disarea.dr == 1)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "此经销商区域已被删除"
}
}
;
disModel.AreaID = disarea.ID;
}
else
{
disModel.AreaID = 0;
}
disModel.DisLevel = "";
disModel.Province = Reseller["ResellerProvince"].ToString();
disModel.City = Reseller["ResellerCity"].ToString();
disModel.Area = Reseller["ResellerArea"].ToString();
disModel.Address = address;
//没输入经销商中的联系人，需要将登录信息的姓名赋值给联系人
string principal = Common.NoHTML(Reseller["Principal"].ToString().Trim());
string phone = Common.NoHTML(Reseller["Phone"].ToString().Trim());
if (principal == "")
{
disModel.Principal = truename;
}
else
{
disModel.Principal = principal;
}
//没输入联系人手机号，需要将登录信息中的手机号赋值给联系人手机号
if (phone == "")
{
disModel.Phone = account["Phone"].ToString();
}
else
{
disModel.Phone = phone;
}
disModel.Leading = "";
disModel.LeadingPhone = "";
disModel.Licence = "";
disModel.Tel = Common.NoHTML(Reseller["Tel"].ToString());
disModel.Zip = Common.NoHTML(Reseller["Zip"].ToString());
disModel.Fax = Common.NoHTML(Reseller["Fax"].ToString());
disModel.Remark = "";
disModel.DisAccount = 0;
disModel.IsCheck = 1;
disModel.CreditType = 0;
disModel.CreditAmount = 0;
disModel.Paypwd = Common.md5("123456");
disModel.AuditState = 2;
disModel.IsEnabled = 1;
disModel.CreateUserID = one.ID;
disModel.CreateDate = DateTime.Now;
disModel.ts = DateTime.Now;
disModel.dr = 0;
disModel.modifyuser = one.ID;
//开启事务，并将dismodel插入经销商表中
SqlConnection conn = new SqlConnection(SqlHelper.LocalSqlServer);
//开启数据库连接
if (conn.State.ToString().ToLower() != "open")
{
conn.Open();
}
//开启事务
SqlTransaction mytran = conn.BeginTransaction();
int DisID = 0;
try
{
//在经销商表中插入一条数据
if ((DisID = new Hi.BLL.BD_Distributor().Add(disModel, mytran)) > 0)
{
//经销商表插入成功的话继续新增角色
List <Hi.Model.SYS_Role> list_role = new Hi.BLL.SYS_Role().GetList("", "isnull(dr,0)=0 and isenabled=1 and DisID=" + DisID + " and RoleName='企业管理员'", "");
if (list_role == null || list_role.Count == 0)
{
//新增角色（企业管理员）
Hi.Model.SYS_Role role = new Hi.Model.SYS_Role();
role.CompID = comp.ID;
role.DisID = DisID;
role.RoleName = "企业管理员";
role.IsEnabled = 1;
role.SortIndex = "1";
role.CreateDate = DateTime.Now;
role.CreateUserID = one.ID;
role.ts = DateTime.Now;
role.modifyuser = one.ID;
role.dr = 0;
int Roid = new Hi.BLL.SYS_Role().Add(role, mytran);
//新增管理员用户和角色
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
user.UserName = username;
// user.CompID = CompID;
// user.Type = 5;
// user.RoleID = Roid;
user.TrueName = truename;
user.UserPwd = Common.md5("123456");
user.Phone = account["Phone"].ToString();
user.AuditState = 2;
user.IsEnabled = 1;
user.CreateUserID = one.ID;
user.CreateDate = DateTime.Now;
user.ts = DateTime.Now;
user.modifyuser = one.ID;
int AddUserid = new Hi.BLL.SYS_Users().Add(user, mytran);
///用户明细表
Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = comp.ID;
CompUser.DisID = DisID;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = one.ID;
CompUser.modifyuser = one.ID;
CompUser.CType = 2;
CompUser.UType = 5;
CompUser.IsEnabled = 1;
CompUser.IsAudit = 2;
CompUser.RoleID = 0;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = AddUserid;
int compuserid = new Hi.BLL.SYS_CompUser().Add(CompUser, mytran);
//新增角色用户
Hi.Model.SYS_RoleUser RoleUser = new Hi.Model.SYS_RoleUser();
RoleUser.FunType = 1;
RoleUser.UserID = AddUserid;
RoleUser.RoleID = Roid;
RoleUser.IsEnabled = true;
RoleUser.CreateUser = UserID;
RoleUser.CreateDate = DateTime.Now;
RoleUser.ts = DateTime.Now;
RoleUser.dr = 0;
int roleuserid = new Hi.BLL.SYS_RoleUser().Add(RoleUser, mytran);
//新增角色权限表
Hi.Model.SYS_RoleSysFun rolesys = null;
List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("", " Type=2", "");
foreach (Hi.Model.SYS_SysFun sys in funList)
{
rolesys = new Hi.Model.SYS_RoleSysFun();
rolesys.CompID = comp.ID;
rolesys.DisID = DisID;
rolesys.RoleID = Roid;
rolesys.FunCode = sys.FunCode;
rolesys.FunName = sys.FunName;
rolesys.IsEnabled = 1;
rolesys.CreateUserID = one.ID;
rolesys.CreateDate = DateTime.Now;
rolesys.ts = DateTime.Now;
rolesys.modifyuser = one.ID;
if (new Hi.BLL.SYS_RoleSysFun().Add(rolesys, mytran) <= 0)
{
mytran.Rollback();
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
}
//新增收货地址
Hi.Model.BD_DisAddr addr = new Hi.Model.BD_DisAddr();
addr.Province = disModel.Province;
addr.City = disModel.City;
addr.Area = disModel.Area;
addr.DisID = DisID;
addr.Principal = disModel.Principal;
addr.Phone = disModel.Phone;
addr.Address = disModel.Province + disModel.City + disModel.Area + disModel.Address;
addr.IsDefault = 1;
addr.ts = DateTime.Now;
addr.CreateDate = DateTime.Now;
addr.CreateUserID = one.ID;
addr.modifyuser = one.ID;
int addrid = new Hi.BLL.BD_DisAddr().Add(addr, mytran);
//判断所有表是否都插入成功了吗
if (Roid <= 0 || AddUserid <= 0 || compuserid <= 0 || roleuserid <= 0 || addrid <= 0)
{
mytran.Rollback();
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
}
else
{
mytran.Rollback();
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
}
else
{
mytran.Rollback();
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
mytran.Commit();
}
catch (Exception ex)
{
mytran.Rollback();
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "AddReseller:" + JSon);
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
finally
{
conn.Close();
mytran.Dispose();
}
return(new ReseltResellerEdit()
{
Result = "T", Description = "新增成功"
});
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "AddReseller:" + JSon);
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
}
public void btnAddList_Click(object sender, EventArgs e)
{
string path = "";
int count = 0;
int index = 0;
SqlTransaction Tran = null;
try
{
if (FileUpload1.HasFile == false)//HasFile用来检查FileUpload是否有指定文件
{
JScript.AlertMsgOne(this, "请您选择代理商Excel模板文件", JScript.IconOption.错误);
return; //当无文件时,返回
}
string IsXls = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower(); //System.IO.Path.GetExtension获得文件的扩展名
if (IsXls != ".xls" && IsXls != ".xlsx")
{
JScript.AlertMsgOne(this, "请您选择代理商Excel模板文件", JScript.IconOption.错误);
return;//当选择的不是Excel文件时,返回
}
if (!Directory.Exists(Server.MapPath("TemplateFile")))
{
Directory.CreateDirectory(Server.MapPath("TemplateFile"));
}
string filename = FileUpload1.FileName;
string name = filename.Replace(IsXls, "");
path = Server.MapPath("TemplateFile/") + name + "-" + DateTime.Now.ToString("yyyyMMddhhmmssffff") + IsXls;
FileUpload1.SaveAs(path);
DataTable dt = Common.ExcelToDataTable(path, TitleIndex);
if (dt == null)
{
throw new Exception("Excel表中无数据");
}
if (dt.Rows.Count == 0)
{
throw new Exception("Excel表中无数据");
}
string Discode = string.Empty;
string DisName = string.Empty;
string DisUserName = string.Empty;
string DisAddrees = string.Empty;
string DisPerson = string.Empty;
string DisPhone = string.Empty;
string DisRemark = string.Empty;
string Provice = string.Empty;
string City = string.Empty;
string Area = string.Empty;
string DisCategory = string.Empty;
string DisLevel = string.Empty;
DataRow[] rows = dt.Select();
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
Eroor = false;
TitleError = string.Empty;
foreach (DataRow row in rows)
{
int typeID = 0;
int AreaID = 0;
try
{
//这个判断有bug呀，是遇到空行就停止的意思吗？
if (row["代理商名称 *\n（2-20个汉字或字母，推荐使用中文名称）"].ToString().Trim() == "" && row["管理员姓名 *\n（请填写真实姓名，以便更好地为您服务）"].ToString().Trim() == "" && row["详细地址 *\n（常用收货地址）"].ToString().Trim() == "")
{
break;
}
index++;
if (row["代理商名称 *\n（2-20个汉字或字母，推荐使用中文名称）"].ToString().Trim() == "示例代理商名称1" || row["代理商名称 *\n（2-20个汉字或字母，推荐使用中文名称）"].ToString().Trim() == "示例代理商名称2" || row["代理商名称 *\n（2-20个汉字或字母，推荐使用中文名称）"].ToString().Trim() == "示例代理商名称3")
{
continue;
}
DisName = DisExistsAttribute("DisName", CheckDisLen(CheckVal(row["代理商名称 *\n（2-20个汉字或字母，推荐使用中文名称）"].ToString().Trim(), "代理商名称", index), index), "代理商名称", index, Tran);
DisPerson = CheckVal(row["管理员姓名 *\n（请填写真实姓名，以便更好地为您服务）"].ToString().Trim(), "管理员姓名", index);
DisUserName = UserExistsAttribute("username", CheckVal(row["管理员登录帐号 *\n（2-20个文字、字母、数字，可以录入代理商姓名、简称等，一经设定无法更改，将来可用手机号进行登录）"].ToString().Trim(), "管理员登录帐号", index), "管理员登录帐号", index, Tran);
DisPhone = CheckPhone(CheckVal(row["管理员手机 *\n（登录、发送验证短信）"].ToString().Trim(), "管理员手机", index), "管理员手机", index, Tran);
Provice = CheckVal(row["所在省*"].ToString().Trim(), "省", index);
City = CheckVal(row["所在市*"].ToString().Trim(), "市", index);
if (City.IndexOf("_") > 0)
{
City = City.Substring(City.IndexOf("_") + 1, City.Length - City.IndexOf("_") - 1);
}
Area = CheckVal(row["所在区*"].ToString().Trim(), "区", index);
DisAddrees = CheckVal(row["详细地址 *\n（常用收货地址）"].ToString().Trim(), "详细地址（常用收货地址）", index);
DisCategory = row["代理商分类"].ToString().Trim();
DisLevel = row["代理商区域"].ToString().Trim();
bool disType = true;
if (!string.IsNullOrEmpty(DisCategory))
{
disType = CheckDisCategory(DisCategory, index, out typeID);
}
if (!string.IsNullOrEmpty(DisLevel))
{
CheckDisLevel(DisLevel, index, out AreaID);
}
DisRemark = row["备注"].ToString().Trim();
if (Eroor)
{
continue;
}
}
catch (Exception ex)
{
if (ex is ApplicationException)
{
Eroor = true;
TitleError += ex.Message;
continue;
}
else
{
throw new Exception("代理商Excel模版格式错误，请重新下载模版填入数据后导入。");
}
}
Hi.Model.BD_Distributor Dis = new Hi.Model.BD_Distributor();
//Dis.DisCode = Discode;
Dis.CompID = CompID;
Dis.DisName = DisName;
Dis.Province = Provice;
Dis.City = City;
Dis.Area = Area;
Dis.Address = DisAddrees;
Dis.Principal = DisPerson;
Dis.Phone = DisPhone;
Dis.DisTypeID = typeID; //add by 2016.5.9
Dis.AreaID = AreaID; //add by 2016.5.10
Dis.Remark = DisRemark;
Dis.IsCheck = 0;
Dis.CreditType = 0; //不可以赊销
Dis.Paypwd = Util.md5("123456");
Dis.IsEnabled = 1;
Dis.AuditState = 2;
Dis.CreateDate = DateTime.Now;
Dis.CreateUserID = UserID;
Dis.ts = DateTime.Now;
Dis.modifyuser = UserID;
int disid = 0;
if ((disid = new Hi.BLL.BD_Distributor().Add(Dis, Tran)) > 0)
{
List <Hi.Model.SYS_Role> l = new Hi.BLL.SYS_Role().GetList("", "isnull(dr,0)=0 and isenabled=1 and DisID=" + disid + " and RoleName='企业管理员'", "", Tran);
if (l.Count == 0)
{
//新增角色（企业管理员）
Hi.Model.SYS_Role role = new Hi.Model.SYS_Role();
role.CompID = CompID;
role.DisID = disid;
role.RoleName = "企业管理员";
role.IsEnabled = 1;
role.SortIndex = "1";
role.CreateDate = DateTime.Now;
role.CreateUserID = UserID;
role.ts = DateTime.Now;
role.modifyuser = UserID;
role.dr = 0;
int Roid = new Hi.BLL.SYS_Role().Add(role, Tran);
//新增管理员用户和角色
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
user.UserName = DisUserName;
user.Phone = DisPhone;
user.TrueName = DisPerson;
user.UserPwd = Util.md5("123456");
user.IsEnabled = 1;
user.AuditState = 2;
user.CreateDate = DateTime.Now;
user.CreateUserID = UserID;
user.ts = DateTime.Now;
user.modifyuser = UserID;
int AddUserid = new Hi.BLL.SYS_Users().Add(user, Tran);
///用户明细表
Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = CompID;
CompUser.DisID = disid;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = UserID;
CompUser.modifyuser = UserID;
CompUser.CType = 2;
CompUser.UType = 5;
CompUser.IsEnabled = 1;
CompUser.IsAudit = 2;
CompUser.RoleID = Roid;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = AddUserid;
new Hi.BLL.SYS_CompUser().Add(CompUser, Tran);
//新增角色权限表 //暂时屏蔽下
Hi.Model.SYS_RoleSysFun rolesys = null;
List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("", " Type=2", "", Tran);
foreach (Hi.Model.SYS_SysFun sys in funList)
{
rolesys = new Hi.Model.SYS_RoleSysFun();
rolesys.CompID = CompID;
rolesys.DisID = disid;
rolesys.RoleID = Roid;
rolesys.FunCode = sys.FunCode;
rolesys.FunName = sys.FunName;
rolesys.IsEnabled = 1;
rolesys.CreateUserID = UserID;
rolesys.CreateDate = DateTime.Now;
rolesys.ts = DateTime.Now;
rolesys.modifyuser = UserID;
new Hi.BLL.SYS_RoleSysFun().Add(rolesys, Tran);
}
}
Hi.Model.BD_DisAddr addr = new Hi.Model.BD_DisAddr();
addr.Province = Provice;
addr.City = City;
addr.Area = Area;
addr.DisID = disid;
addr.Principal = DisPerson;
addr.Phone = DisPhone;
addr.Address = Provice + City + Area + DisAddrees;
addr.IsDefault = 1;
addr.ts = DateTime.Now;
addr.CreateDate = DateTime.Now;
addr.CreateUserID = UserID;
addr.modifyuser = UserID;
new Hi.BLL.BD_DisAddr().Add(addr, Tran);
}
else
{
throw new ApplicationException("导入失败，服务器异常请重试。");
}
count++;
}
if (!Eroor)
{
Tran.Commit();
if (Request["nextstep"] + "" == "1")
{
JScript.AlertMethod(this, "导入成功,共导入" + count + "条代理商", JScript.IconOption.笑脸, "function(){ window.location.href=window.location.href+'?nextstep=1'; /* $(window.parent.leftFrame.document).find('.menuson li.active').removeClass('active');window.parent.leftFrame.document.getElementById('ktxzjxs').className = 'active';*/}");
}
else
{
JScript.AlertMethod(this, "导入成功,共导入" + count + "条代理商", JScript.IconOption.笑脸, "function(){ window.location.href=window.location.href; }");
}
}
else
{
Tran.Rollback();
JScript.AlertMethod(this, TitleError, JScript.IconOption.错误, "function(){ addList(); }");
}
}
catch (Exception ex)
{
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
}
JScript.AlertMethod(this, ex.Message, JScript.IconOption.错误, "function(){ $('a.bulk').trigger('click'); }");
}
finally
{
if (!string.IsNullOrEmpty(path))
{
if (File.Exists(path))
{
File.Delete(path);
}
}
}
}
/// <summary>
/// 同步代理商基本档案方法
/// </summary>
public void DisTransfer(XmlDocument Doc, string Method)
{
Regex rgx = null;
try
{
int SumDisAdd = 0;
int SumDisTB = 0;
int SumTypeAdd = 0;
int SumTypeTB = 0;
int SumAddressAdd = 0;
int SumAddressTB = 0;
DataTable dt = null;
int Disid = 0;
TranSaction = DBUtility.SqlHelper.CreateStoreTranSaction();
if (Method == "InsertCusClass")
{
#region 代理商分类新增/同步方法
XmlElement elment = Doc.DocumentElement;
XmlNodeList nodeList = Doc.DocumentElement.SelectNodes("bill");
foreach (XmlNode nodel in nodeList)
{
XmlNode nodel1 = nodel.SelectSingleNode("header");
string TypeCode = nodel1.SelectSingleNode("customerclasscode").InnerText.Trim();
string ParentCode = nodel1.SelectSingleNode("customerclassprecode").InnerText.Trim();
string TypeName = nodel1.SelectSingleNode("customerclassname").InnerText.Trim();
Hi.Model.BD_DisType type = null;
dt = ImportDisProD.GetDataSource("*", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction);
if (dt.Rows.Count > 0)
{
if (string.IsNullOrWhiteSpace(TypeName))
{
CreateReturnXML(TypeCode, false, "分类（同步）：分类名称为空");
SetErrorTb("分类（同步）", "分类名称为空【分类名称：" + TypeName + "，分类编码：" + TypeCode + "】");
continue;
}
else if (string.IsNullOrWhiteSpace(TypeCode))
{
CreateReturnXML(TypeCode, false, "分类（同步）：分类编码为空");
SetErrorTb("分类（同步）", "分类编码为空【分类名称：" + TypeName + "，分类编码：" + TypeCode + "】");
continue;
}
else if ((FindTb = ImportDisProD.GetDataSource("1 name", "BD_DisType", " and isnull(dr,0)=0 and TypeName='" + TypeName + "' and Typecode<>'" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0)
{
CreateReturnXML(TypeCode, false, "分类（同步）：分类名称已存在");
SetErrorTb("分类（同步）", "分类名称已存在【分类名称：" + TypeName + "，分类编码：" + TypeCode + "】");
continue;
}
type = Common.GetEntity <Hi.Model.BD_DisType>(dt);
type.TypeName = TypeName;
if (new Hi.BLL.BD_DisType().Update(type, TranSaction))
{
CreateReturnXML(TypeCode, true);
SumTypeTB++;
}
}
else
{
if (string.IsNullOrWhiteSpace(TypeName))
{
CreateReturnXML(TypeCode, false, "分类（新增）：分类名称为空");
SetErrorTb("分类（新增）", "分类名称为空【分类名称：" + TypeName + "，分类编码：" + TypeCode + "】");
continue;
}
else if (string.IsNullOrWhiteSpace(TypeCode))
{
CreateReturnXML(TypeCode, false, "分类（新增）：分类编码为空");
SetErrorTb("分类（新增）", "分类编码为空【分类名称：" + TypeName + "，分类编码：" + TypeCode + "】");
continue;
}
else if ((ImportDisProD.GetDataSource("1 name", "BD_DisType", " and isnull(dr,0)=0 and (TypeName='" + TypeName + "') and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0)
{
CreateReturnXML(TypeCode, false, "分类（新增）：分类名称或编码已存在");
SetErrorTb("分类（新增）", "分类名称或编码已存在【分类名称：" + TypeName + "，分类编码：" + TypeCode + "】");
continue;
}
if (!string.IsNullOrWhiteSpace(ParentCode))
{
FindTb = ImportDisProD.GetDataSource(" ID", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + ParentCode + "' and CompID=" + CompID + "", "", TranSaction);
if (FindTb.Rows.Count > 0)
{
type = new Hi.Model.BD_DisType();
type.CreateDate = DateTime.Now;
type.CreateUserID = UserID;
type.IsEnabled = 1;
type.modifyuser = UserID;
type.TypeName = TypeName;
type.TypeCode = TypeCode;
type.ts = DateTime.Now;
type.CompID = CompID;
type.ParentId = FindTb.Rows[0]["ID"].ToString().ToInt(0);
if (new Hi.BLL.BD_DisType().Add(type, TranSaction) > 0)
{
CreateReturnXML(TypeCode, true);
SumTypeAdd++;
}
}
else
{
CreateReturnXML(TypeCode, false, "分类（新增）：查找不到父分类");
SetErrorTb("分类（新增）", "查找不到父分类，【分类名称：" + TypeName + "，分类编码：" + TypeCode + "】");
}
}
else
{
type = new Hi.Model.BD_DisType();
type.CreateDate = DateTime.Now;
type.CreateUserID = UserID;
type.IsEnabled = 1;
type.CompID = CompID;
type.modifyuser = UserID;
type.TypeName = TypeName;
type.TypeCode = TypeCode;
type.ts = DateTime.Now;
type.ParentId = 0;
if (new Hi.BLL.BD_DisType().Add(type, TranSaction) > 0)
{
CreateReturnXML(TypeCode, true);
SumTypeAdd++;
}
}
}
}
#endregion
}
else if (Method == "InsertDisArea")
{
#region 代理商地址新增/同步
XmlElement elment = Doc.DocumentElement;
rgx = new Regex(@"^0?1[0-9]{10}$");
XmlNodeList nodeList1 = Doc.DocumentElement.SelectNodes("bill");
foreach (XmlNode nodel2 in nodeList1)
{
XmlNode nodel3 = nodel2.SelectSingleNode("header");
string addcode = nodel3.SelectSingleNode("addresscode").InnerText.Trim();
string DisCode = nodel3.SelectSingleNode("customercode").InnerText.Trim();
string Principal = nodel3.SelectSingleNode("linkperson").InnerText.Trim();
string Address = nodel3.SelectSingleNode("address").InnerText.Trim();
string Phone = nodel3.SelectSingleNode("handphone").InnerText.Trim();
string Tel = nodel3.SelectSingleNode("phone").InnerText.Trim();
int isdefault = nodel3.SelectSingleNode("default").InnerText.Trim().ToInt(0);
if ((FindTb = ImportDisProD.GetDataSource("ID", "BD_Distributor", " and isnull(dr,0)=0 and DisCode='" + DisCode + "' and CompID=" + CompID + " ", "", TranSaction)).Rows.Count == 0)
{
CreateReturnXML(addcode, false, "代理商地址：查找不到代理商，代理商编码:" + DisCode + "");
SetErrorTb("代理商地址", "查找不到代理商【地址：" + Address + "，地址编码：" + addcode + "，代理商编码：" + DisCode + "】");
continue;
}
Disid = FindTb.Rows[0]["ID"].ToString().ToInt(0);
dt = ImportDisProD.GetDataSource("*", "BD_DisAddr", " and isnull(dr,0)=0 and Code='" + addcode + "' and Disid=" + Disid + "", "", TranSaction);
if (dt.Rows.Count > 0)
{
if (string.IsNullOrWhiteSpace(addcode))
{
CreateReturnXML(addcode, false, "代理商地址（同步）：地址编码为空");
SetErrorTb("代理商地址（同步）", "地址编码为空【地址：" + Address + "，地址编码：" + addcode + "】");
continue;
}
else if (string.IsNullOrWhiteSpace(Principal))
{
//CreateReturnXML(addcode, false, "代理商地址（同步）：联系人为空");
//SetErrorTb("代理商地址（同步）", "联系人为空【地址：" + Address + "，地址编码：" + addcode + "】");
//continue;
Principal = "";
}
else if (string.IsNullOrWhiteSpace(Address))
{
CreateReturnXML(addcode, false, "代理商地址（同步）：地址为空");
SetErrorTb("代理商地址（同步）", "地址为空【地址：" + Address + "，地址编码：" + addcode + "】");
continue;
}
else if (!rgx.IsMatch(Phone))
{
//CreateReturnXML(addcode, false, "代理商地址（同步）：手机格式不正确");
//SetErrorTb("代理商地址（同步）", "手机格式不正确【地址：" + Address + "，地址编码：" + addcode + "】");
//continue;
Phone = "";
}
Hi.Model.BD_DisAddr addr = Common.GetEntity <Hi.Model.BD_DisAddr>(dt);
addr.Address = addr.Province + addr.City + addr.Area + Address;
addr.Principal = Principal;
addr.Phone = Phone;
addr.Tel = Tel;
addr.IsDefault = isdefault;
if (new Hi.BLL.BD_DisAddr().Update(addr, TranSaction))
{
CreateReturnXML(addcode, true);
SumAddressTB++;
}
}
else
{
if (string.IsNullOrWhiteSpace(addcode))
{
CreateReturnXML(addcode, false, "代理商地址（同步）：地址编码为空");
SetErrorTb("代理商地址（新增）", "地址编码为空【地址：" + Address + "，地址编码：" + addcode + "】");
continue;
}
else if (string.IsNullOrWhiteSpace(Principal))
{
//CreateReturnXML(addcode, false, "代理商地址（同步）：联系人为空");
//SetErrorTb("代理商地址（新增）", "联系人为空【地址：" + Address + "，地址编码：" + addcode + "】");
//continue;
Principal = "";
}
else if (string.IsNullOrWhiteSpace(Address))
{
CreateReturnXML(addcode, false, "代理商地址（同步）：地址为空");
SetErrorTb("代理商地址（新增）", "地址为空【地址：" + Address + "，地址编码：" + addcode + "】");
continue;
}
else if (!rgx.IsMatch(Phone))
{
//CreateReturnXML(addcode, false, "代理商地址（同步）：手机格式不正确");
//SetErrorTb("代理商地址（新增）", "手机格式不正确【地址：" + Address + "，地址编码：" + addcode + "】");
//continue;
Phone = "";
}
else if ((ImportDisProD.GetDataSource("1 name", "BD_DisAddr", " and isnull(dr,0)=0 and (Code='" + addcode + "') and Disid=" + Disid + "", "", TranSaction)).Rows.Count > 0)
{
CreateReturnXML(addcode, false, "代理商地址（同步）：地址编码已存在");
SetErrorTb("代理商地址（新增）", "地址编码已存在【地址：" + Address + "，地址编码：" + addcode + "】");
continue;
}
Hi.Model.BD_DisAddr addr = new Hi.Model.BD_DisAddr();
addr.DisID = Disid;
addr.Province = "上海市";
addr.City = "市辖区";
addr.Area = "徐汇区";
addr.Code = addcode;
addr.Address = addr.Province + addr.City + addr.Area + Address;
addr.Phone = Phone;
addr.Principal = Principal;
addr.Tel = Tel;
addr.IsDefault = isdefault;
addr.CreateDate = DateTime.Now;
addr.CreateUserID = UserID;
addr.ts = DateTime.Now;
addr.modifyuser = UserID;
if (new Hi.BLL.BD_DisAddr().Add(addr, TranSaction) > 0)
{
CreateReturnXML(addcode, true);
SumAddressAdd++;
}
}
}
#endregion
}
else if (Method == "InsertCus")
{
#region 代理商新增/同步
XmlElement elment = Doc.DocumentElement;
XmlNodeList nodeList = Doc.DocumentElement.SelectNodes("bill");
foreach (XmlNode nodel in nodeList)
{
XmlNode nodel1 = nodel.SelectSingleNode("header");
string DisCode = nodel1.SelectSingleNode("customercode").InnerText.Trim();
string DisName = nodel1.SelectSingleNode("customername").InnerText.Trim();
string TypeCode = IsSelectNode(nodel1, "customerclasscode") ? nodel1.SelectSingleNode("customerclasscode").InnerText.Trim() : "";
string Address = IsSelectNode(nodel1, "address") ? nodel1.SelectSingleNode("address").InnerText.Trim() : "";
string Principal = IsSelectNode(nodel1, "person") ? nodel1.SelectSingleNode("person").InnerText.Trim() : "";
string Phone = IsSelectNode(nodel1, "handphone") ? nodel1.SelectSingleNode("handphone").InnerText.Trim() : "";
string Leading = IsSelectNode(nodel1, "lperson") ? nodel1.SelectSingleNode("lperson").InnerText.Trim() : "";
string Tel = IsSelectNode(nodel1, "phone") ? nodel1.SelectSingleNode("phone").InnerText.Trim() : "";
string Zip = IsSelectNode(nodel1, "postcode") ? nodel1.SelectSingleNode("postcode").InnerText.Trim() : "";
string Fax = IsSelectNode(nodel1, "fax") ? nodel1.SelectSingleNode("fax").InnerText.Trim() : "";
dt = ImportDisProD.GetDataSource("*", "BD_Distributor", " and isnull(dr,0)=0 and DisCode='" + DisCode + "' and CompID=" + CompID + " and AuditState=2", "", TranSaction);
if (dt.Rows.Count > 0)
{
rgx = new Regex(@"^0?1[0-9]{10}$");
if (string.IsNullOrWhiteSpace(DisName))
{
CreateReturnXML(TypeCode, false, "代理商（同步）：代理商名称为空");
SetErrorTb("代理商（同步）", "代理商名称为空【代理商名称：" + DisName + "，代理商编码：" + DisCode + "】");
continue;
}
else if (string.IsNullOrWhiteSpace(DisCode))
{
CreateReturnXML(TypeCode, false, "代理商（同步）：代理商编码为空");
SetErrorTb("代理商（同步）", "代理商编码为空【代理商名称：" + DisName + "，代理商编码：" + DisCode + "】");
continue;
}
else if (!rgx.IsMatch(Phone))
{
//CreateReturnXML(TypeCode, false, "代理商（同步）：手机号码格式错误");
//SetErrorTb("代理商（同步）", "手机号码格式错误【代理商名称：" + DisName + "，代理商编码：" + DisCode + "】");
//continue;
Phone = "";
}
else if ((ImportDisProD.GetDataSource("1 name", "BD_Distributor", " and isnull(dr,0)=0 and (DisName='" + DisName + "' and DisCode<>'" + DisCode + "') and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0)
{
CreateReturnXML(TypeCode, false, "代理商（同步）：代理商名称已存在");
SetErrorTb("代理商（同步）", "代理商名称已存在【代理商名称：" + DisName + "，代理商编码：" + DisCode + "】");
continue;
}
Hi.Model.BD_Distributor Dis = Common.GetEntity <Hi.Model.BD_Distributor>(dt);
Dis.DisName = DisName;
if ((FindTb = ImportDisProD.GetDataSource("ID", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0)
{
Dis.DisTypeID = FindTb.Rows[0]["ID"].ToString().ToInt(0);
}
Dis.Address = Address;
Dis.Principal = Principal;
Dis.Leading = Leading;
Dis.Phone = Phone;
Dis.LeadingPhone = Phone;
Dis.Tel = Tel;
Dis.Zip = Zip;
Dis.Fax = Fax;
if (new Hi.BLL.BD_Distributor().Update(Dis, TranSaction))
{
CreateReturnXML(TypeCode, true);
SumDisTB++;
}
}
else
{
rgx = new Regex(@"^0?1[0-9]{10}$");
if (string.IsNullOrWhiteSpace(DisName))
{
CreateReturnXML(TypeCode, false, "代理商（新增）：代理商名称为空");
SetErrorTb("代理商（新增）", "代理商名称为空【代理商名称：" + DisName + "，代理商编码：" + DisCode + "】");
continue;
}
else if (string.IsNullOrWhiteSpace(DisCode))
{
CreateReturnXML(TypeCode, false, "代理商（新增）：代理商编码为空");
SetErrorTb("代理商（新增）", "代理商编码为空【代理商名称：" + DisName + "，代理商编码：" + DisCode + "】");
continue;
}
else if (!rgx.IsMatch(Phone))
{
//CreateReturnXML(TypeCode, false, "代理商（新增）：手机号码格式错误");
//SetErrorTb("代理商（新增）", "手机号码格式错误【代理商名称：" + DisName + "，代理商编码：" + DisCode + "】");
//continue;
Phone = "";
}
else if ((ImportDisProD.GetDataSource("1 name", "SYS_Users", " and isnull(dr,0)=0 and (Phone='" + Phone + "' and isnull(Phone,'')<>'')", "", TranSaction)).Rows.Count > 0)
{
CreateReturnXML(TypeCode, false, "代理商（新增）：代理商手机号码已存在");
SetErrorTb("代理商（新增）", "代理商手机号码已存在【代理商名称：" + DisName + "，代理商编码：" + DisCode + "，手机号码：" + Phone + "】");
continue;
}
else if ((ImportDisProD.GetDataSource("1 name", "BD_Distributor", " and isnull(dr,0)=0 and (DisName='" + DisName + "') and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0)
{
CreateReturnXML(TypeCode, false, "代理商（新增）：代理商名称/编码已存在");
SetErrorTb("代理商（新增）", "代理商名称/编码已存在【代理商名称：" + DisName + "，代理商编码：" + DisCode + "】");
continue;
}
Hi.Model.BD_Distributor Dis = new Hi.Model.BD_Distributor();
Dis.DisName = DisName;
Dis.DisCode = DisCode;
if ((FindTb = ImportDisProD.GetDataSource("ID", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0)
{
Dis.DisTypeID = FindTb.Rows[0]["ID"].ToString().ToInt(0);
}
Dis.Address = Address;
Dis.Province = "上海市";
Dis.City = "市辖区";
Dis.Area = "徐汇区";
Dis.Principal = Principal;
Dis.Leading = Leading;
Dis.Phone = Phone;
Dis.LeadingPhone = Phone;
Dis.Tel = Tel;
Dis.Zip = Zip;
Dis.Fax = Fax;
Dis.SMID = 0;
Dis.IsCheck = 0;
Dis.CreditType = 0;
Dis.AuditState = 2;
Dis.AuditUser = UserID.ToString();
Dis.CompID = CompID;
Dis.AuditDate = DateTime.Now;
Dis.CreateDate = DateTime.Now;
Dis.CreateUserID = UserID;
Dis.ts = DateTime.Now;
Dis.modifyuser = UserID;
Dis.IsEnabled = 1;
Dis.Paypwd = Util.md5("123456");
Dis.Remark = "";
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
if ((Disid = new Hi.BLL.BD_Distributor().Add(Dis, TranSaction)) > 0)
{
CreateReturnXML(TypeCode, true);
user.UserName = Enum.GetName(typeof(Enums.Erptype), Erptype) + DisCode;
user.UserPwd = Util.md5("123456");
user.IsEnabled = 1;
user.AuditState = 2;
user.IsFirst = 0;
user.Type = 5;
user.CompID = CompID;
user.DisID = Disid;
user.AddType = 0;
user.Phone = Phone;
user.TrueName = Principal;
user.Tel = Tel;
user.RoleID = 0;
user.CreateDate = DateTime.Now;
user.CreateUserID = UserID;
user.ts = DateTime.Now;
user.modifyuser = UserID;
if (new Hi.BLL.SYS_Users().Add(user, TranSaction) > 0)
{
SumDisAdd++;
}
}
}
}
#endregion
}
else
{
ReturnBill = "";
ErrTb.Rows.Clear();
CreateReturnXML("", false, "导入类型异常");
SetErrorTb("", "导入类型异常");
return;
}
TranSaction.Commit();
LogManager.WriteLog2(LogFile.Trace.ToString(), "新增（代理商：" + SumDisAdd + "条；类别：" + SumTypeAdd + "条；地址：" + SumAddressAdd + "条），同步（代理商：" + SumDisTB + "条；类别：" + SumTypeTB + "条；地址：" + SumAddressTB + "条）");
}
catch (Exception ex)
{
ReturnBill = "";
ErrTb.Rows.Clear();
if (ex is XmlException)
{
CreateReturnXML("", false, "读取XML出现错误");
SetErrorTb("", "读取XML出现错误");
}
else if (ex is XPathException)
{
CreateReturnXML("", false, "格式错误");
SetErrorTb("", "XML格式错误");
}
else
{
CreateReturnXML("", false, ex.Message);
SetErrorTb("", "同步失败：" + ex.Message + "");
}
if (TranSaction != null)
{
if (TranSaction.Connection != null)
{
TranSaction.Rollback();
}
}
}
finally
{
if (TranSaction != null)
{
if (TranSaction.Connection != null)
{
TranSaction.Rollback();
}
}
TableWriteLog();
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hi.Model.BD_Distributor model)
{
return(dal.Add(model));
}
protected void Bind()
{
string str = string.Empty;
if (KeyID > 0)
{
//修改时控制账户类型是否可用
ddltype.Disabled = false;
Hi.Model.PAY_PaymentBank bankModel = new Hi.BLL.PAY_PaymentBank().GetModel(KeyID);
this.txtDisUser.Value = bankModel.AccountName;//账户名称
this.txtbankcode.Value = bankModel.bankcode;
this.txtbankAddress.Value = bankModel.bankAddress;
this.txtphone.InnerText = bankModel.vdef4 == "" ? new Hi.BLL.PAY_PrePayment().GetPhoneBYCompID(this.CompID).ToString() : bankModel.vdef4;
this.hid_tel.Value = bankModel.vdef4 == "" ? new Hi.BLL.PAY_PrePayment().GetPhoneBYCompID(this.CompID).ToString() : bankModel.vdef4;
//this.txtbankPrivate.Value = bankModel.bankPrivate;
// this.txtbankCity.Value = bankModel.bankCity;
this.hidProvince.Value = bankModel.bankPrivate;
this.hidCity.Value = bankModel.bankCity;
this.hidArea.Value = bankModel.vdef1;
this.chkIsno.Checked = bankModel.Isno == 1 ? true : false;
if (bankModel.Isno == 1)
{
this.btnDis.Attributes.Add("style", "display:none");
div_grid.Attributes.Add("style", "display:none");
}
this.txtRemark.Value = bankModel.Remark;
//现有银行列表
string bankID_str = "102,103,104,105,301,100,303,305,306,302,310,309,401,403,307,308";
string BankID = Convert.ToString(bankModel.BankID);
bool index = bankID_str.Contains(BankID);
if (index)
{
this.ddlbank.Value = Convert.ToString(bankModel.BankID);
}
else
{
this.ddlbank.Items.Insert(0, new ListItem(new Hi.BLL.PAY_PrePayment().GetBankNameBYbankID(BankID), BankID));
this.ddlbank.SelectedIndex = 0;
}
this.ddltype.Value = Convert.ToString(bankModel.type);
if (bankModel.type == 11)
{
this.tbdis.Visible = true;
this.SltPesontype.Value = bankModel.vdef2;
this.txtpesoncode.Value = bankModel.vdef3;
}
else
{
this.tbdis.Visible = false;
}
//this.ddlbank.InnerText=
DataTable dtdis = new Hi.BLL.PAY_PaymentAccountdtl().GetDisBYpbID(KeyID);
List <Hi.Model.BD_Distributor> dblist = new List <Hi.Model.BD_Distributor>();
foreach (DataRow dr in dtdis.Rows)
{
Hi.Model.BD_Distributor dbmodel = new Hi.Model.BD_Distributor();
dbmodel.ID = Convert.ToInt32(dr["DisID"]);
dbmodel.DisName = dr["DisName"].ToString();
dbmodel.DisCode = dr["DisCode"].ToString();
dbmodel.DisLevel = dr["DisLevel"].ToString();
dbmodel.Address = dr["Address"].ToString();
dbmodel.Principal = dr["Principal"].ToString();
dbmodel.AreaID = Convert.ToInt32(dr["AreaID"]);
dblist.Add(dbmodel);
//if (string.IsNullOrEmpty(str))
//{
// str =dr["DisID"] + ",";
//}
//else
//{
// str += dr["DisID"] + ",";
//}
//this.txtGoodsCodes.Value = new Hi.BLL.PAY_PrePayment().GetDisIDBYCompID(this.CompID) + ",";// str;
}
this.gvDtl.DataSource = dtdis;
this.gvDtl.DataBind();
AddMaterial(dblist);
}
else
{
int compid = CompID;
this.txtphone.InnerText = new Hi.BLL.PAY_PrePayment().GetPhoneBYCompID(compid).ToString();
this.hid_tel.Value = new Hi.BLL.PAY_PrePayment().GetPhoneBYCompID(compid).ToString();
//设置默认值
ddltype.Value = "11";
SltPesontype.Value = "0";
int num = new Hi.BLL.PAY_PrePayment().GetBankBYCompID(compid);
if (num >= 1)
{
this.chkIsno.Checked = false;
//this.btnDis.Attributes.Add("style", "display:block;");
//div_grid.Attributes.Add("style", "display:block;");
this.gvDtl.Visible = true;
this.btnDis.Visible = true;
}
else
{
//this.btnDis.Attributes.Add("style", "display:none;");
//div_grid.Attributes.Add("style", "display:none;");
this.gvDtl.Visible = false;
this.btnDis.Visible = false;
}
}
str = new Hi.BLL.PAY_PrePayment().GetDisIDBYCompID(CompID);
if (str != "")
{
this.txtGoodsCodes.Value = new Hi.BLL.PAY_PrePayment().GetDisIDBYCompID(CompID) + ",";// str;
}
}
/// <summary>
/// 返回选择的代理商
/// </summary>
/// <param name="l"></param>
private void AddMaterial(List <Hi.Model.BD_Distributor> dbutorList)
{
if (dbutorList.Count > 0)
{
DataTable dt = null;
foreach (var item in dbutorList)
{
if (ViewState["Distributor"] == null)
{
dt = new DataTable();
dt.Columns.Add("ID", typeof(string));
dt.Columns.Add("DisName", typeof(string));
dt.Columns.Add("DisCode", typeof(string));
dt.Columns.Add("DisLevel", typeof(string));
dt.Columns.Add("Address", typeof(string));
dt.Columns.Add("Principal", typeof(string));
dt.Columns.Add("AreaID", typeof(int));//区域
DataRow dr1 = dt.NewRow();
dr1["Id"] = item.ID;
Hi.Model.BD_Distributor dbutorModel = BDdbutorbll.GetModel(item.ID);
if (dbutorModel != null)
{
dr1["DisName"] = dbutorModel.DisName;
dr1["DisCode"] = dbutorModel.DisCode;
dr1["DisLevel"] = dbutorModel.DisLevel;
dr1["Address"] = dbutorModel.Address;
dr1["Principal"] = dbutorModel.Principal;
dr1["AreaID"] = dbutorModel.AreaID;
}
dt.Rows.Add(dr1);
}
else
{
dt = ViewState["Distributor"] as DataTable;
DataRow dr2 = dt.NewRow();
dr2["Id"] = item.ID;
Hi.Model.BD_Distributor dbutorModel = BDdbutorbll.GetModel(item.ID);
if (dbutorModel != null)
{
dr2["DisName"] = dbutorModel.DisName;
dr2["DisCode"] = dbutorModel.DisCode;
dr2["DisLevel"] = dbutorModel.DisLevel;
dr2["Address"] = dbutorModel.Address;
dr2["Principal"] = dbutorModel.Principal;
dr2["AreaID"] = dbutorModel.AreaID;
}
dt.Rows.Add(dr2);
}
ViewState["Distributor"] = dt;
}
if (dt != null)
{
if (dt.Rows.Count > 0)
{
dt.DefaultView.Sort = "ID desc"; //dt排序
}
}
this.gvDtl.DataSource = dt;
this.gvDtl.DataBind();
}
}
/// <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);
}
/// <summary>
/// 订单支付
/// </summary>
/// <param name="orderid">订单ID</param>
/// <param name="txtPayOrder">支付金额</param>
/// <param name="price">企业钱包金额</param>
/// <param name="yfk">预付款</param>
/// <param name="payPas"></param>
public Wxpay_Url PayOrder(int orderid, decimal txtPayOrder, decimal price, int yfk, string payPas)
{
//使用企业钱包
OrderModel = new Hi.BLL.DIS_Order().GetModel(orderid);
disModel = new Hi.BLL.BD_Distributor().GetModel(OrderModel.DisID);
#region 界面上显示
this.lblOrderNO.InnerText = OrderModel.ReceiptNo.Trim().ToString();
this.fee.InnerText = this.CompName;//收款方
// this.lblOrderNO.HRef = "../neworder/orderdetail.aspx?KeyID=" + Common.DesEncrypt(orderid.ToString(), Common.EncryptKey);
#endregion 界面上显示
#region 企业钱包支付 begin
if (disModel == null)
{
ErrMessage("数据异常,代理商有误", orderid.ToString());
}
decimal sumPrice = new Hi.BLL.PAY_PrePayment().sums(disModel.ID, disModel.CompID); //剩余企业钱包
int disid = OrderModel.DisID; //代理商ID
string password = disModel.Paypwd;
if (yfk == 1)
{
if (payPas == null || payPas.Trim().ToString() == "")
{
ErrMessage("企业钱包密码不能为空", orderid.ToString());
}
payPas = payPas.Trim().ToString();
if (password == Util.md5("123456"))
{
ErrMessage("请先修改企业钱包支付密码", orderid.ToString());
}
else
{
if (payPas == "")
{
ErrMessage("密码不能为空", orderid.ToString());
}
}
}
decimal payPrice = 0;//支付金额
if (txtPayOrder == 0)
{
ErrMessage("支付金额不能为0", orderid.ToString());
}
if (yfk == 1 && txtPayOrder < price)
{
ErrMessage("使用企业钱包大于支付金额!", orderid.ToString());
}
if (yfk == 1)
{
payPrice = txtPayOrder - price;
}
else
{
payPrice = txtPayOrder;
}
if (txtPayOrder > OrderModel.AuditAmount + OrderModel.OtherAmount - OrderModel.PayedAmount)
{
ErrMessage("支付金额大于未支付金额，不能支付！", orderid.ToString());
}
if (!((
(OrderModel.Otype == (int)Enums.OType.赊销订单 && (OrderModel.OState != (int)Enums.OrderState.退回 && OrderModel.OState != (int)Enums.OrderState.未提交 && OrderModel.OState != (int)Enums.OrderState.待审核) && (OrderModel.PayState == (int)Enums.PayState.未支付 || OrderModel.PayState == (int)Enums.PayState.部分支付)) ||
(OrderModel.Otype != (int)Enums.OType.赊销订单 && OrderModel.Otype != (int)Enums.OType.推送账单 && (OrderModel.OState == (int)Enums.OrderState.已审 || OrderModel.OState == (int)Enums.OrderState.已发货 || OrderModel.OState == (int)Enums.OrderState.已到货) && (OrderModel.PayState == (int)Enums.PayState.未支付 || OrderModel.PayState == (int)Enums.PayState.部分支付)) ||
(OrderModel.Otype == (int)Enums.OType.推送账单 && OrderModel.OState == (int)Enums.OrderState.已审 && (OrderModel.PayState == (int)Enums.PayState.部分支付 || OrderModel.PayState == (int)Enums.PayState.未支付))
) &&
OrderModel.OState != (int)Enums.OrderState.已作废))
{
if (OrderModel.Otype == (int)Enums.OType.推送账单)
{
ErrMessage("账单异常，不能支付", orderid.ToString());
}
else
{
ErrMessage("订单异常，不能支付", orderid.ToString());
}
}
if (yfk == 1 && price > 0)
{
//企业钱包处理
if (sumPrice < price)
{
ErrMessage("企业钱包余额不足", orderid.ToString());
}
if (disModel.Paypwd != Util.md5(payPas))
{
ErrMessage("支付密码不正确", orderid.ToString());
}
Hi.Model.PAY_PrePayment prepayModel = new Hi.Model.PAY_PrePayment();
prepayModel.CompID = disModel.CompID;
prepayModel.DisID = disModel.ID;
prepayModel.OrderID = OrderModel.ID;
prepayModel.Start = 2;
prepayModel.PreType = 5;
prepayModel.price = price * -1;
prepayModel.Paytime = DateTime.Now;
prepayModel.CreatDate = DateTime.Now;
prepayModel.CrateUser = this.UserID;
prepayModel.AuditState = 2;
prepayModel.IsEnabled = 1;
prepayModel.ts = DateTime.Now;
prepayModel.modifyuser = this.UserID;
prepayModel.guid = Common.Number_repeat(Guid.NewGuid().ToString().Replace("-", ""));
// prepayModel.vdef1 = "订单支付";
prepayid = new Hi.BLL.PAY_PrePayment().Add(prepayModel);
int prepay = 0;
int order = 0;
if (prepayid > 0 && payPrice == 0)//payPrice（网银支付金额）= 0 ，只用企业钱包支付，修改状态
{
SqlConnection con = new SqlConnection(LocalSqlServer);
con.Open();
SqlTransaction sqlTrans = con.BeginTransaction();
try
{
prepay = new Hi.BLL.PAY_PrePayment().updatePrepayState(con, prepayid, sqlTrans); //修改企业钱包状态
order = new Hi.BLL.DIS_Order().UpdateOrderPstate(con, OrderModel.ID, price, sqlTrans); //修改订单状态
if (prepay > 0 && order > 0)
{
sqlTrans.Commit();
}
else
{
sqlTrans.Rollback();
}
}
catch
{
prepay = 0;
order = 0;
sqlTrans.Rollback();
}
finally
{
con.Close();
}
if (prepay > 0 && order > 0)
{
try
{
if (OrderModel.Otype == (int)Enums.OType.推送账单)
{
Utils.AddSysBusinessLog(disModel.CompID, "Order", OrderModel.ID.ToString(), "账单支付", "支付：" + price.ToString("0.00") + "元(企业钱包支付)", this.UserID.ToString());
}
else
{
Utils.AddSysBusinessLog(disModel.CompID, "Order", OrderModel.ID.ToString(), "订单支付", "支付：" + price + "元(企业钱包支付)", this.UserID.ToString());
}
if (OrderModel.Otype != 9)
{
OrderInfoType.AddIntegral(this.CompID, this.DisID, "1", 1, OrderModel.ID, price, "订单支付", "", this.UserID);
}
new Common().GetWxService("2", OrderModel.ID.ToString(), "1", price);
}
catch (Exception ex)
{
ErrMessage("支付失败", orderid.ToString());
}
if (OrderModel.Otype == (int)Enums.OType.推送账单)
{
Response.Redirect("PaySuccess.aspx?type=" + Common.DesEncrypt("2", Common.EncryptKey) + "&KeyID=" + Common.DesEncrypt(OrderModel.ID.ToString(), Common.EncryptKey) + "&Pid=" + Common.DesEncrypt("0".ToString(), Common.EncryptKey) + "&PPid=" + Common.DesEncrypt(prepayid.ToString(), Common.EncryptKey) + "&IsRef=Y", false);
}
else
{
Response.Redirect("PaySuccess.aspx?type=" + Common.DesEncrypt("1", Common.EncryptKey) + "&KeyID=" + Common.DesEncrypt(OrderModel.ID.ToString(), Common.EncryptKey) + "&Pid=" + Common.DesEncrypt("0".ToString(), Common.EncryptKey) + "&PPid=" + Common.DesEncrypt(prepayid.ToString(), Common.EncryptKey) + "&IsRef=Y", false);
}
}
}
}
#endregion
#region 插入支付表记录
Hi.Model.PAY_Payment payModel = new Hi.Model.PAY_Payment();
string orderNo = WebConfigurationManager.AppSettings["OrgCode"] + DateTime.Now.ToString("yyyyMMdd");//支付订单号前半部分
string guid = Guid.NewGuid().ToString().Replace("-", "");
payModel.OrderID = OrderModel.ID; // orderid;
payModel.DisID = this.DisID;
payModel.Type = 0; // isDBPay;
payModel.PayUser = disModel.DisName;
payModel.PayPrice = payPrice;
payModel.IsAudit = 2;
payModel.guid = Common.Number_repeat(guid);
payModel.vdef3 = "1"; //1，订单支付，2，预付款充值、汇款
payModel.vdef4 = orderNo;
payModel.CreateDate = DateTime.Now;
payModel.CreateUserID = this.UserID;
payModel.ts = DateTime.Now;
payModel.modifyuser = this.UserID;
payModel.PrintNum = 1; //支付宝支付无需结算
//判断账户类型，判断支付渠道
payModel.Channel = "7"; //1，快捷支付，2，银联支付 ，3，网银支付，4，B2B网银支付，5，线下支付，6，支付宝支付 7，微信支付
payModel.State = 0; //手续费收取方
payModel.vdef5 = "0.00"; //支付手续费
payid = new Hi.BLL.PAY_Payment().Add(payModel);
if (prepayid > 0)
{
Hi.Model.PAY_PrePayment prepayMent = new Hi.BLL.PAY_PrePayment().GetModel(prepayid);
prepayMent.vdef4 = payid.ToString();//与企业钱包关联
new Hi.BLL.PAY_PrePayment().Update(prepayMent);
}
Hi.Model.PAY_RegisterLog regModel = new Hi.Model.PAY_RegisterLog();
regModel.OrderId = OrderModel.ID;// orderid;
regModel.Ordercode = orderNo + payid.ToString();
regModel.number = payModel.guid;
regModel.Price = payPrice;
regModel.Payuse = "订单支付";
regModel.PayName = disModel.DisName;
regModel.DisID = OrderModel.DisID;
regModel.PayTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
regModel.Remark = OrderModel.Remark;// orderModel.Remark;
regModel.DisName = new Hi.BLL.BD_Company().GetModel(disModel.CompID).CompName;
regModel.BankID = "支付宝支付";
regModel.CreateUser = this.UserID;
regModel.CreateDate = DateTime.Now;
regModel.LogType = 1311;
int regid = new Hi.BLL.PAY_RegisterLog().Add(regModel);
if (payid <= 0 || regid <= 0)
{
Response.Redirect("Error.aspx?type=" + Common.DesEncrypt("3", Common.EncryptKey) + "&KeyID=" + Common.DesEncrypt(Convert.ToString(KeyID), Common.EncryptKey) + "&msg=" + Common.DesEncrypt("支付失败！", Common.EncryptKey), false);
}
//订单所有商品明细
DataTable l = new Hi.BLL.DIS_OrderDetail().GetOrderDe("", " IsNUll(o.dr,0)=0 and o.OrderId=" + orderid);
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) + "...";
}
#endregion
int amount = Convert.ToInt32(payPrice * 100);//支付金额（单位：分）
//隐藏域赋值
this.hidguid.Value = payModel.guid;
this.hidprice.Value = payPrice.ToString();
this.hidordid.Value = payModel.OrderID.ToString();
this.hidpid.Value = payid.ToString();
this.hidppid.Value = prepayid.ToString();
// btnWxPay_Click(payModel.guid, orderid.ToString(), amount);
Wxpay_Url wxpaymodel = new Wxpay_Url();
wxpaymodel.Guid = payModel.guid;
wxpaymodel.OrderID = orderid.ToString();
wxpaymodel.Amount = amount;
wxpaymodel.Hidguid = payModel.guid;
wxpaymodel.Hidprice = payModel.PayPrice.ToString();
wxpaymodel.Hidordid = payModel.OrderID.ToString();
wxpaymodel.Hidpid = payid.ToString();
wxpaymodel.Hidppid = prepayid.ToString();
return(wxpaymodel);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!(Session["UserModel"] as LoginModel).IsExistRole)
{
Response.Redirect("~/Distributor/UserEdit.aspx", true);
}
//获取当前时间
DateTime date = DateTime.Now;
//当天0点0分
DateTime day0 = new DateTime(date.Year, date.Month, date.Day, 0, 0, 0);
//获取当前时间加一天
DateTime Sday = day0.AddDays(1);
//当月第一天
DateTime day1 = new DateTime(date.Year, date.Month, 1);
//本月 最后一天 多加一天
DateTime mothday = day1.AddMonths(1);
user = new Hi.BLL.SYS_Users().GetModel(this.UserID);
orderl = new Hi.BLL.DIS_Order().GetList("", " isnull(dr,0)=0 and Otype<>9 and OState<>6 and CompID=" + this.CompID + " and DisID=" + this.DisID, " CreateDate desc");
if (orderl != null)
{
#region
//当天订单数
dayOrderCount = orderl.FindAll(
p => (p.OState == 2 || p.OState == 3 || p.OState == 4 || p.OState == 5 || p.OState == 7) && p.CreateDate >= day0 && p.CreateDate < Sday).Count;
//本月订单数
orderCount = orderl.FindAll(
p => (p.OState == 2 || p.OState == 3 || p.OState == 4 || p.OState == 5 || p.OState == 7) && p.CreateDate >= day1 && p.CreateDate < mothday).Count;
#endregion
orderll = orderl.FindAll(p => (p.PayState == 0 || p.PayState == 1));
}
List <Hi.Model.DIS_Suggest> suggest = new Hi.BLL.DIS_Suggest().GetList("", " isnull(dr,0)=0 and Stype=0 and isanswer=1 and DisUserID=" + this.UserID, "");
message = suggest.Count;
if (message == 0)
{
//imessage.Attributes.Add("style", "display:none");
}
price = Convert.ToDecimal(new Hi.BLL.PAY_PrePayment().sums(this.DisID, this.CompID)).ToString("0.00");
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (dis != null)//add by hgh 出现为null值
{
//if ( dis.CreditType == 0)
//{
//lisalesorder.Attributes.Add("style", "background-color:#fbfbfb");
//}
Hi.Model.BD_DisType distypemodel = new Hi.BLL.BD_DisType().GetModel(dis.DisTypeID);
if (distypemodel != null)
{
disType = distypemodel.TypeName;
}
Hi.Model.BD_DisArea disaddrmodel = new Hi.BLL.BD_DisArea().GetModel(dis.AreaID);
if (disaddrmodel != null)
{
disAreaID = disaddrmodel.AreaName;
}
}
#region 促销商品
string Cx_sql = string.Format(@"SELECT count(1) num from BD_Goods
where ID in (SELECT GoodsID from BD_PromotionDetail where ProID in
(SELECT ID from BD_Promotion where compID={0} and ProStartTime<=getdate()
and ProStartTime<=GETDATE() and DATEADD(D,1,ProEndTime)>= getDate() and IsEnabled=1 ))and ID not in (
select GoodsID from BD_GoodsAreas where compID={0} and DisID={1} and isnull(dr,0)=0)
and compid= {0} and ISNULL(dr,0)=0 and IsEnabled = 1 and IsOffLine=1 ", this.CompID, this.DisID);
DataTable Cx_Dt = SqlHelper.Query(SqlHelper.LocalSqlServer, Cx_sql).Tables[0];
if (Cx_Dt != null)
{
if (Cx_Dt.Rows.Count > 0)
{
decimal sum_CX = Convert.ToDecimal(Cx_Dt.Rows[0]["num"]);
Cx_Sum = sum_CX.ToString();
}
}
#endregion
#region 快过期商品 goods_Sum
//当前时间
DateTime now = DateTime.Now;
//快到期时间
DateTime today = now.AddDays(30);
string goods_sql = string.Format(@"select * from YZT_GoodsStock s where s.validDate<='" + today + "'" + " and DisID=" + DisID + " and dr=0 ");
DataTable goods_Dt = SqlHelper.Query(SqlHelper.LocalSqlServer, goods_sql).Tables[0];
if (goods_Dt != null && goods_Dt.Rows.Count > 0)
{
goods_Sum = goods_Dt.Rows.Count.ToString();
}
#endregion
#region 当天订购额
//add by hgh //包含已退订单金额、退单处理
string daysql = "SELECT SUM(AuditAmount) as AuditAmount FROM [dbo].[DIS_Order] where ostate in (2,3,4,5,7) and DisID=" +
this.DisID + " and CompID=" + this.CompID + " and CreateDate>='" + day0 + "' and CreateDate<'" + Sday + "'";
DataTable dayDt = SqlHelper.Query(SqlHelper.LocalSqlServer, daysql).Tables[0];
if (dayDt != null)
{
if (dayDt.Rows.Count > 0)
{
decimal sumAmount = dayDt.Rows[0]["AuditAmount"].ToString() == ""
? sum.ToString().ToDecimal()
: Convert.ToDecimal(dayDt.Rows[0]["AuditAmount"]);
DaySum = (sumAmount).ToString("N");
}
}
#endregion
#region 本月订购额
string monthsql = "SELECT SUM(AuditAmount) as AuditAmount FROM DIS_Order where OState in (2,3,4,5,7) and isnull(dr,0)=0 and Otype<>9 and DisID=" + this.DisID + " and CompID=" + this.CompID + " and CreateDate>='" + day1 + "' and CreateDate<'" + mothday + "'";
DataTable monthDt = SqlHelper.Query(SqlHelper.LocalSqlServer, monthsql).Tables[0];
if (monthDt != null)
{
if (monthDt.Rows.Count > 0)
{
decimal sumAmount = monthDt.Rows[0]["AuditAmount"].ToString() == "" ? sum.ToString().ToDecimal() : Convert.ToDecimal(monthDt.Rows[0]["AuditAmount"]);
MonthSum = (sumAmount).ToString("N");
}
}
#endregion
#region 当天付款额
//付款额 add by hgh CompCollection_view 状态 and status!=3
string daypaggersql = "SELECT SUM(Price) as Price FROM [dbo].[CompCollection_view] where DisID=" + this.DisID +
"and CompID=" + this.CompID + " and status!=3 and Date>='" + day0 + "' and Date<'" + Sday + "' AND vedf9=1 ";
DataTable daypaggerdt = SqlHelper.Query(SqlHelper.LocalSqlServer, daypaggersql).Tables[0];
if (daypaggerdt != null)
{
if (daypaggerdt.Rows.Count > 0)
{
decimal Price = daypaggerdt.Rows[0]["Price"].ToString() == ""
? sum.ToString().ToDecimal()
: Convert.ToDecimal(daypaggerdt.Rows[0]["Price"]);
DayPaymentSum = (Price).ToString("N");
}
}
#endregion
#region 本月付款额
//本月付款额 add by hgh CompCollection_view 状态 and status!=3
string paggersql = "SELECT SUM(Price) as Price FROM [dbo].[CompCollection_view] where OrderID not in (select ID from Dis_Order where ISNULL(dr,0)=0 and Otype=9) and DisID=" + this.DisID + " and status!=3 and CompID=" + this.CompID + " and Date>='" + day1 + "' and Date<'" + mothday + "' AND vedf9=1 ";
DataTable paggerdt = SqlHelper.Query(SqlHelper.LocalSqlServer, paggersql).Tables[0];
if (paggerdt != null)
{
if (paggerdt.Rows.Count > 0)
{
decimal Price = paggerdt.Rows[0]["Price"].ToString() == "" ? sum.ToString().ToDecimal() : Convert.ToDecimal(paggerdt.Rows[0]["Price"]);
PaymentSum = (Price).ToString("N");
}
}
#endregion
#region 本月应付额
//本月应付额
decimal AuditAmount = 0;
decimal payAmount = 0;
decimal payyzf = 0;
//赊销订单 未支付的
//string ArrearageSql = "SELECT SUM(AuditAmount) as AuditAmount FROM [dbo].[ArrearageRpt_view] where DisID=" + user.DisID + "and CompID=" + user.CompID + " and CreateDate>='" + day1 + "' and CreateDate<='" + Sday + "'";
//DataTable ArrearageDt = SqlHelper.Query(SqlHelper.LocalSqlServer, ArrearageSql).Tables[0];
//if (ArrearageDt != null)
//{
// if (ArrearageDt.Rows.Count > 0)
// {
// AuditAmount = ArrearageDt.Rows[0]["AuditAmount"].ToString() == "" ? sum.ToString().ToDecimal() : Convert.ToDecimal(ArrearageDt.Rows[0]["AuditAmount"]);
// }
//}
//未支付订单金额
//string paysql = " select SUM(AuditAmount) as AuditAmount from DIS_Order where (( Otype=1 and OState not in (-1,0,1) and PayState in (0,1) ) or( Otype<>1 and OState=2 and PayState in (0,1) )) and OState<>6 and ReturnState=0 and isnull(dr,0)=0 and Otype!=9 and CompID=" + this.CompID + " and DisID=" + this.DisID + " and CreateDate>='" + day1 + "' and CreateDate<='" + Sday + "'";
//DataTable payDt = SqlHelper.Query(SqlHelper.LocalSqlServer, paysql).Tables[0];
//if (payDt != null && payDt.Rows.Count > 0)
//{
// payAmount = payDt.Rows[0]["AuditAmount"].ToString() == "" ? 0 : payDt.Rows[0]["AuditAmount"].ToString().ToDecimal(0);
//}
//paysql = " select SUM(PayedAmount) as PayedAmount from DIS_Order where (( Otype=1 and OState not in (-1,0,1) and PayState in (0,1) ) or( Otype<>1 and OState=2 and PayState in (0,1) )) and OState<>6 and ReturnState=0 and isnull(dr,0)=0 and Otype!=9 and CompID=" + this.CompID + " and DisID=" + this.DisID + " and CreateDate>='" + day1 + "' and CreateDate<='" + Sday + "'";
//payDt = SqlHelper.Query(SqlHelper.LocalSqlServer, paysql).Tables[0];
//if (payDt != null && payDt.Rows.Count > 0)
//{
// payyzf = payDt.Rows[0]["PayedAmount"].ToString() == "" ? 0 : payDt.Rows[0]["PayedAmount"].ToString().ToDecimal(0);
//}
//PayableSum = (payAmount - payyzf + AuditAmount).ToString("N");
//edit by hgh 正常合同 总额-已付
string paysql = " select SUM(AuditAmount)-SUM(PayedAmount) as AuditAmount from DIS_Order where OState in(2,3,5) and isnull(dr,0)=0 and Otype!=9 and CompID=" + this.CompID + " and DisID=" + this.DisID + " and CreateDate>='" + day1 + "' and CreateDate<'" + Sday + "'";
DataTable payDt = SqlHelper.Query(SqlHelper.LocalSqlServer, paysql).Tables[0];
if (payDt != null && payDt.Rows.Count > 0)
{
payAmount = payDt.Rows[0]["AuditAmount"].ToString() == "" ? 0 : payDt.Rows[0]["AuditAmount"].ToString().ToDecimal(0);
}
PayableSum = payAmount.ToString("N");
#endregion
#region 商家公告
List <Hi.Model.BD_CompNews> LNew = new Hi.BLL.BD_CompNews().GetList("top 3 *", "isnull(dr,0)=0 and IsEnabled=1 and Compid=" + this.CompID + " ", " istop desc,createdate desc");
string Html = "";
if (LNew.Count > 0)
{
for (int i = 0; i < LNew.Count; i++)
{
if (LNew[i].ShowType == null)
{
LNew[i].ShowType = "";
}
if (i <= 4)
{
string type = LNew[i].ShowType == "1" ? "top" : LNew[i].ShowType == "2" ? "red" : LNew[i].ShowType == "1,2" ? "top red" : "";
Html += "<li class='" + type + "'><a title='" + LNew[i].NewsTitle + "' href=\"CompNewInfo.aspx?KeyID=" + Common.DesEncrypt(LNew[i].ID.ToString(), Common.EncryptKey) + "&Type=3\">【" + Common.GetCPNewStateName(LNew[i].NewsType) + "】" + (LNew[i].NewsTitle.Length > 16 ? LNew[i].NewsTitle.Substring(0, 16) + "..." : LNew[i].NewsTitle) + "</a>" + IsEnd(LNew[i].PmID) + (LNew[i].ShowType.IndexOf("1") >= 0 ? "<i class='newIcon'></i>" : "") + "<i class='date1'>" + LNew[i].CreateDate.ToString("yyyy-MM-dd") + "</i></li>";
}
}
ULNewList.InnerHtml = Html;
}
else
{
//ULNewList.InnerHtml = "<li style='text-align:center'><span>暂无公告</span></li>";
ULNewList.InnerHtml = "<div class='nomh-box'><i class='nomh-i'></i>暂无公告</div>";
}
#endregion
if (!IsPostBack)
{
if (IsDisAdmin(this.UserID))
{
if (user.UserPwd == Util.md5("123456"))
{
DisImport.Attributes.Add("style", "display:block");
zzc.Attributes.Add("style", "display:block");
return;
}
}
}
}
/// <summary>
///核心企业修改经销商信息
/// </summary>
/// <param name="JSon"></param>
/// <returns></returns>
public ReseltResellerEdit EditReseller(string JSon)
{
string UserID = string.Empty;
string CompID = string.Empty;
string DisID = string.Empty;
try
{
#region//JSon取值
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo["UserID"].ToString().Trim() == "" || JInfo["CompID"].ToString().Trim() == "" || JInfo["Reseller"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "参数异常"
}
}
;
UserID = JInfo["UserID"].ToString();
CompID = JInfo["CompID"].ToString();
JsonData Reseller = JInfo["Reseller"];
//判断登录信息是否异常
Hi.Model.SYS_Users one = new Hi.Model.SYS_Users();
if (!new Common().IsLegitUser(int.Parse(UserID), out one, Int32.Parse(CompID)))
{
return(new ReseltResellerEdit()
{
Result = "F", Description = "登录信息异常"
});
}
//判断核心企业信息是否异常
Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(Int32.Parse(CompID));
if (comp == null || comp.dr == 1 || comp.IsEnabled == 0 || comp.AuditState == 0)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "核心企业信息异常"
}
}
;
#endregion
//判断经销商信息是否正常
DisID = Reseller["ResellerID"].ToString();
Hi.BLL.BD_Distributor bll_dis = new Hi.BLL.BD_Distributor();
Hi.Model.BD_Distributor dis = bll_dis.GetModel(Int32.Parse(DisID));
if (dis == null)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商信息异常"
}
}
;
if (dis.dr == 1)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商已被删除"
}
}
;
if (Reseller["ts"].ToString() != dis.ts.ToString())
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商信息已被他人修改，请稍后再试"
}
}
;
string resellername = Common.NoHTML(Reseller["ResellerName"].ToString().Trim());
string resellercode = Common.NoHTML(Reseller["ResellerCode"].ToString().Trim());
string address = Common.NoHTML(Reseller["Address"].ToString().Trim());
//判断经销商修改的必填项
if (resellername == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入经销商名称"
}
}
;
//判断经销商名字是否已存在
//if (Common.DisExistsAttribute("DisName", Reseller["ResellerName"].ToString(), CompID.ToString()))
//List<Hi.Model.BD_Distributor> list_dis = bll_dis.GetList("", "DisName = '" + resellername + "' and ID <> " + dis.ID + "", "");
//if(list_dis!=null&&list_dis.Count>0)
if (Common.DisExistsAttribute("DisName", resellername, CompID.ToString(), dis.ID.ToString()))
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商名称已经存在"
}
}
;
if (Reseller["ResellerProvince"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请选择经销商地址中的省"
}
}
;
if (Reseller["ResellerCity"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请选择经销商地址中的市"
}
}
;
if (Reseller["ResellerArea"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请选择经销商地址中的区"
}
}
;
if (address == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入经销商地址中的详细地址"
}
}
;
//修改经销商信息
dis.ts = DateTime.Now;
dis.modifyuser = one.ID;
dis.DisCode = resellercode;
dis.DisName = resellername;
//Int32 classifyid= Reseller["ResellerClassifyID"].ToString().Trim() == "" ? 0 : Int32.Parse(Reseller["ResellerClassifyID"].ToString().Trim());
//传入分类ID的话，判断分类ID是否正确
if (Reseller["ResellerClassifyID"].ToString().Trim() != "" && Reseller["ResellerClassifyID"].ToString() != "0")
{
Hi.Model.BD_DisType distpye = new Hi.BLL.BD_DisType().GetModel(Int32.Parse(Reseller["ResellerClassifyID"].ToString().Trim()));
if (distpye == null || distpye.CompID != comp.ID)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商分类异常"
}
}
;
if (distpye.dr == 1)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "此经销商分类已被删除"
}
}
;
//if (distpye.IsEnabled !=0)
// return new ReseltResellerEdit() { Result = "F", Description = "此经销商分类已被禁用" };
dis.DisTypeID = distpye.ID;
}
else
{
dis.DisTypeID = 0;
}
//dis.AreaID = Reseller["AreaID"].ToString().Trim() == "" ? 0 : Int32.Parse(Reseller["AreaID"].ToString().Trim());
//传入区域ID的话，判断区域ID是否正确
if (Reseller["AreaID"].ToString().Trim() != "" && Reseller["AreaID"].ToString() != "0")
{
Hi.Model.BD_DisArea disarea = new Hi.BLL.BD_DisArea().GetModel(Int32.Parse(Reseller["AreaID"].ToString().Trim()));
if (disarea == null || disarea.CompanyID != comp.ID)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商区域异常"
}
}
;
if (disarea.dr == 1)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "此经销商区域已被删除"
}
}
;
dis.AreaID = disarea.ID;
}
else
{
dis.AreaID = 0;
}
dis.Province = Reseller["ResellerProvince"].ToString();
dis.City = Reseller["ResellerCity"].ToString();
dis.Area = Reseller["ResellerArea"].ToString();
dis.Address = address;
dis.Zip = Common.NoHTML(Reseller["Zip"].ToString());
dis.Tel = Common.NoHTML(Reseller["Tel"].ToString());
dis.Fax = Common.NoHTML(Reseller["Fax"].ToString());
string principal = Common.NoHTML(Reseller["Principal"].ToString().Trim());
string phone = Common.NoHTML(Reseller["Phone"].ToString().Trim());
//如果联系人或联系人手机没输入，需要将登陆信息的联系人或手机号，赋值给联系人或手机
if (principal == "" || phone == "")
{
//先获取sys_compuser表中disid对应的数据，一对一关系
List <Hi.Model.SYS_CompUser> compuser = new Hi.BLL.SYS_CompUser().GetList("UserID",
"DisID=" + dis.ID + " and UType = 5 and isnull(dr,0)=0 and isnull(IsEnabled,0)=1 and isnull(IsAudit,0)=2", "");
//通过Userid获取sys_users表数据
Hi.Model.SYS_Users user = new Hi.BLL.SYS_Users().GetModel(compuser[0].ID);
if (user != null && user.AuditState == 2 && user.IsEnabled == 1 && user.dr == 0)
{
//需要判断到底是传入的联系人为空，还是手机为空
if (principal == "")
{
dis.Principal = user.TrueName;
}
else
{
dis.Principal = principal;
}
if (phone == "")
{
dis.Phone = user.Phone;
}
else
{
dis.Phone = phone;
}
}
}
else
{
dis.Principal = principal;
dis.Phone = phone;
}
//更新数据库
if (bll_dis.Update(dis))
{
return new ReseltResellerEdit()
{
Result = "T", Description = "修改成功"
}
}
;
else
{
return new ReseltResellerEdit()
{
Result = "F", Description = "修改失败"
}
};
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "EditReseller:" + JSon);
return(new ReseltResellerEdit()
{
Result = "F", Description = "修改失败"
});
}
}
protected void Page_Load(object sender, EventArgs e)
{
//user = LoginModel.IsLogined(this);
if (!IsPostBack)
{
//if (!Common.HasRight(this.UserID, "2010"))
// this.btnAdd.Visible = false;
//if (!string.IsNullOrEmpty(Request["Otype"]) && Request["Otype"].ToString() == "1")
//{
// this.ddlOType.SelectedValue = "1";
//}
string strwhere = string.Empty;
if (Request["t"] != null)
{
//获取当前时间
DateTime date = DateTime.Now;
//当月第一天
DateTime day1 = new DateTime(date.Year, date.Month, 1);
//获取当前时间加一天
DateTime Sday = date.AddDays(1);
//当天0点0分
DateTime day0 = new DateTime(date.Year, date.Month, date.Day, 0, 0, 0);
if (Request["t"] + "" == "1")
{
strwhere += " and ReturnState=0 and OState in (1,2,4,5) and CreateDate>='" + day0 + "'";
this.txtArriveDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
this.txtArriveDate1.Value = DateTime.Now.ToString("yyyy-MM-dd");
}
else if (Request["t"] + "" == "2")
{
this.txtArriveDate.Value = DateTime.Now.AddDays(1 - DateTime.Now.Day).ToString("yyyy-MM-dd");
this.txtArriveDate1.Value = DateTime.Now.ToString("yyyy-MM-dd");
strwhere += " and ReturnState=0 and OState in (1,2,4,5) and CreateDate>='" + day1 + "'";
}
}
Common.ListComps(this.ddrComp, this.UserID.ToString(), this.CompID.ToString());
ViewState["strwhere"] = strwhere;
//user = LoginModel.IsLogined(this);
//AddTypeBind();
}
//if (user != null)
//{
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (!IsPostBack)
{
this.txtPager.Value = "12";
Bind();
}
//}
if (Request.QueryString["type"] != null)
{
if (Request.QueryString["type"].ToString() == "present")
{
present(Request["ReceiptNo"].ToString());
}
if (Request.QueryString["type"].ToString() == "affirm")
{
affirm(Request["ReceiptNo"].ToString());
}
if (Request.QueryString["type"].ToString() == "Del")
{
Del(Request["oid"].ToString());
}
}
if (!Common.HasRight(this.CompID, this.UserID, "2010", this.DisID))
{
this.btnAdd.Visible = false;
}
if (!Common.HasRight(this.CompID, this.UserID, "2011", this.DisID))
{
this.rptOrder.Visible = false;
this.Pager.Visible = false;
}
//this.ddrComp.DataSource =
//this.ddrComp.DataTextField = "CompName";
//this.ddrComp.DataValueField = "id";
//this.ddrComp.DataBind();
}
/// <summary>
/// 确定导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnImport_Click(object sender, EventArgs e)
{
if (HttpContext.Current.Session["DisTable"] != null)
{
SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
try
{
DataTable dt = HttpContext.Current.Session["DisTable"] as DataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["chkstr"].ToString() == "数据正确！")
{
Hi.Model.BD_Distributor Dis = new Hi.Model.BD_Distributor();
//Dis.DisCode = Discode;
Dis.CompID = CompID;
Dis.DisName = dt.Rows[i]["disname"].ToString().Trim();
Dis.Province = dt.Rows[i]["pro"].ToString().Trim();
Dis.City = dt.Rows[i]["city"].ToString().Trim();
Dis.Area = dt.Rows[i]["quxian"].ToString().Trim();
Dis.Address = dt.Rows[i]["address"].ToString().Trim();
Dis.Principal = dt.Rows[i]["principal"].ToString().Trim();
Dis.Phone = dt.Rows[i]["phone"].ToString().Trim();
Dis.DisTypeID = Convert.ToInt32(dt.Rows[i]["distypeid"].ToString().Trim()); //add by 2016.5.9
Dis.AreaID = Convert.ToInt32(dt.Rows[i]["areaid"].ToString().Trim()); //add by 2016.5.10
Dis.Remark = dt.Rows[i]["remark"].ToString().Trim();
Dis.IsCheck = 0;
Dis.CreditType = 0; //不可以赊销
Dis.Paypwd = Util.md5("123456");
Dis.IsEnabled = 1;
Dis.AuditState = 2;
Dis.CreateDate = DateTime.Now;
Dis.CreateUserID = UserID;
Dis.ts = DateTime.Now;
Dis.modifyuser = UserID;
int disid = 0;
if ((disid = new Hi.BLL.BD_Distributor().Add(Dis, Tran)) > 0)
{
List <Hi.Model.SYS_Role> l = new Hi.BLL.SYS_Role().GetList("", "isnull(dr,0)=0 and isenabled=1 and DisID=" + disid + " and RoleName='企业管理员'", "", Tran);
if (l.Count == 0)
{
//新增角色（企业管理员）
Hi.Model.SYS_Role role = new Hi.Model.SYS_Role();
role.CompID = CompID;
role.DisID = disid;
role.RoleName = "企业管理员";
role.IsEnabled = 1;
role.SortIndex = "1";
role.CreateDate = DateTime.Now;
role.CreateUserID = UserID;
role.ts = DateTime.Now;
role.modifyuser = UserID;
role.dr = 0;
int Roid = new Hi.BLL.SYS_Role().Add(role, Tran);
//新增管理员用户和角色
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
user.UserName = dt.Rows[i]["username"].ToString().Trim();
user.Phone = dt.Rows[i]["phone"].ToString().Trim();
user.TrueName = dt.Rows[i]["principal"].ToString().Trim();
user.UserPwd = Util.md5("123456");
user.IsEnabled = 1;
user.AuditState = 2;
user.CreateDate = DateTime.Now;
user.CreateUserID = UserID;
user.ts = DateTime.Now;
user.modifyuser = UserID;
int AddUserid = new Hi.BLL.SYS_Users().Add(user, Tran);
///用户明细表
Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = CompID;
CompUser.DisID = disid;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = UserID;
CompUser.modifyuser = UserID;
CompUser.CType = 2;
CompUser.UType = 5;
CompUser.IsEnabled = 1;
CompUser.IsAudit = 2;
CompUser.RoleID = Roid;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = AddUserid;
new Hi.BLL.SYS_CompUser().Add(CompUser, Tran);
//新增角色权限表 //暂时屏蔽下
Hi.Model.SYS_RoleSysFun rolesys = null;
List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("", " Type=2", "", Tran);
foreach (Hi.Model.SYS_SysFun sys in funList)
{
rolesys = new Hi.Model.SYS_RoleSysFun();
rolesys.CompID = CompID;
rolesys.DisID = disid;
rolesys.RoleID = Roid;
rolesys.FunCode = sys.FunCode;
rolesys.FunName = sys.FunName;
rolesys.IsEnabled = 1;
rolesys.CreateUserID = UserID;
rolesys.CreateDate = DateTime.Now;
rolesys.ts = DateTime.Now;
rolesys.modifyuser = UserID;
new Hi.BLL.SYS_RoleSysFun().Add(rolesys, Tran);
}
}
Hi.Model.BD_DisAddr addr = new Hi.Model.BD_DisAddr();
addr.Province = dt.Rows[i]["pro"].ToString().Trim();
addr.City = dt.Rows[i]["city"].ToString().Trim();
addr.Area = dt.Rows[i]["quxian"].ToString().Trim();
addr.DisID = disid;
addr.Principal = dt.Rows[i]["principal"].ToString().Trim();
addr.Phone = dt.Rows[i]["phone"].ToString().Trim();
addr.Address = dt.Rows[i]["pro"].ToString().Trim() + dt.Rows[i]["city"].ToString().Trim() + dt.Rows[i]["quxian"].ToString().Trim() + dt.Rows[i]["address"].ToString().Trim();
addr.IsDefault = 1;
addr.ts = DateTime.Now;
addr.CreateDate = DateTime.Now;
addr.CreateUserID = UserID;
addr.modifyuser = UserID;
new Hi.BLL.BD_DisAddr().Add(addr, Tran);
}
else
{
throw new ApplicationException("导入失败，服务器异常请重试。");
}
}
}
Tran.Commit();
Response.Redirect("ImportDis3.aspx", false);
//ClientScript.RegisterStartupScript(this.GetType(), "Add", "<script>addlis(" + count + "," + count2 + ",'" + str + "');</script>");
}
catch (Exception ex)
{
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
}
HttpContext.Current.Session["DisTable"] = null;
JScript.AlertMethod(this, ex.Message, JScript.IconOption.错误, "function(){location.href='ImportDis.aspx'}");
}
}
else
{
JScript.AlertMethod(this, "Excel没有数据，请重新导入", JScript.IconOption.错误, "function(){location.href='ImportDis.aspx'}");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.BD_Distributor model)
{
return(dal.Update(model));
}
private bool RegisterDistributor(string distributorName, string phone, string password, SqlTransaction Tran)
{
try
{
int Compid = 0;
int UserID = 0;
Hi.Model.BD_Distributor Distributor = new Hi.Model.BD_Distributor();
Distributor.CompID = Compid;
Distributor.DisName = distributorName;
Distributor.IsEnabled = 1;
Distributor.Paypwd = new GetPhoneCode().md5(password);
Distributor.Phone = phone;
Distributor.AuditState = 2;
Distributor.CreateDate = DateTime.Now;
Distributor.CreateUserID = UserID;
Distributor.ts = DateTime.Now;
Distributor.modifyuser = UserID;
Distributor.IsCheck = 0;
Distributor.CreditType = 0;
int DistributorID = 0;
if ((DistributorID = new Hi.BLL.BD_Distributor().Add(Distributor, Tran)) > 0)
{
int Roid = 0;
//新增角色（企业管理员）
Hi.Model.SYS_Role role = new Hi.Model.SYS_Role();
role.CompID = Compid;
role.DisID = DistributorID;
role.RoleName = "企业管理员";
role.IsEnabled = 1;
role.SortIndex = "1";
role.CreateDate = DateTime.Now;
role.CreateUserID = UserID;
role.ts = DateTime.Now;
role.modifyuser = UserID;
role.dr = 0;
Roid = new Hi.BLL.SYS_Role().Add(role, Tran);
//新增角色权限表
Hi.Model.SYS_RoleSysFun rolesys = null;
List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("FunCode,FunName", " Type=2", "");
foreach (Hi.Model.SYS_SysFun sys in funList)
{
rolesys = new Hi.Model.SYS_RoleSysFun();
rolesys.CompID = Compid;
rolesys.DisID = DistributorID;
rolesys.RoleID = Roid;
rolesys.FunCode = sys.FunCode;
rolesys.FunName = sys.FunName;
rolesys.IsEnabled = 1;
rolesys.CreateUserID = UserID;
rolesys.CreateDate = DateTime.Now;
rolesys.ts = DateTime.Now;
rolesys.modifyuser = UserID;
new Hi.BLL.SYS_RoleSysFun().Add(rolesys, Tran);
}
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
user.UserName = phone;
user.TrueName = phone;
user.DisID = DistributorID;
user.TrueName = "";
user.UserPwd = new GetPhoneCode().md5(password);
user.IsEnabled = 1;
user.Phone = phone;
user.CreateDate = DateTime.Now;
user.CreateUserID = UserID;
user.ts = DateTime.Now;
user.modifyuser = UserID;
user.AuditState = 2;
int userid = 0;
userid = new Hi.BLL.SYS_Users().Add(user, Tran);
///用户明细表
Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = Compid;
CompUser.DisID = DistributorID;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = UserID;
CompUser.modifyuser = UserID;
CompUser.CType = 2;
CompUser.UType = 5;
//CompUser.IsEnabled = 1;
CompUser.IsAudit = 2;
CompUser.RoleID = Roid;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = userid;
CompUser.IsEnabled = 1;
new Hi.BLL.SYS_CompUser().Add(CompUser, Tran);
}
else
{
return(false);
}
Tran.Commit();
return(true);
}
catch (Exception)
{
if (Tran != null && Tran.Connection != null)
{
Tran.Rollback();
}
return(false);
}
finally
{
if (Tran != null && Tran.Connection != null)
{
Tran.Rollback();
}
}
}
