/// <summary> /// 添加信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Add(Model.PaymentRecord model) { string strSql = "insert into PaymentRecord( UserName,ProductName, Company, Type, Money, RechargeTime) values(@UserName, @ProductName, @Company, @Type, @Money, @RechargeTime) "; SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName; SqlParameter ProductName = new SqlParameter("ProductName", SqlDbType.NVarChar); ProductName.Value = model.ProductName; SqlParameter Company = new SqlParameter("Company", SqlDbType.NVarChar); Company.Value = model.Company; SqlParameter Type = new SqlParameter("Type", SqlDbType.NVarChar); Type.Value = model.Type; SqlParameter Money = new SqlParameter("Money", SqlDbType.NVarChar); Money.Value = model.Money; SqlParameter RechargeTime = new SqlParameter("RechargeTime", SqlDbType.DateTime); RechargeTime.Value = model.RechargeTime; return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, ProductName, Company, Type, Money, RechargeTime }, connectionString) == 1 ? true : false); }
private bool AddData() { try { Model.OrderList orderlist = DAL.OrderList.GetModel(Convert.ToInt32(Request["verify"])); if (Request["status"] == "OK") { orderlist.OrderStatus = 2; if (orderlist.OrdeType == 0)//账号申请 { //订单审核通过后添加发票信息 Model.InvoiceList invoicelist = new Model.InvoiceList(); invoicelist.OrderDetail = orderlist.ID.ToString(); invoicelist.OrderNumber = orderlist.OrderNumber; invoicelist.BelongArea = orderlist.WorkArea; invoicelist.PayTime = orderlist.PayTime; invoicelist.Price = orderlist.Price; invoicelist.Status = 1; invoicelist.ContractStatus = 1; invoicelist.UserName = orderlist.UserName; invoicelist.Type = 0; DAL.InvoiceList.Add(invoicelist); Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo(); for (int i = 0; i < orderlist.AccountNum; i++) { Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName); System.Random a = new Random(DateTime.Now.Millisecond); // use System.DateTime.Now.Millisecond as seed int RandKey = a.Next(100, 999); Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(registerUser.CertifiationIndex)); rtkUserInfo.RegisterUserName = orderlist.UserName; rtkUserInfo.UserName = orderlist.UserName + RandKey.ToString(); rtkUserInfo.Company = companyInfo.Company; rtkUserInfo.PassWord = AES_Key.AESEncrypt(rtkUserInfo.UserName, rtkUserInfo.UserName.PadLeft(16, '0')); rtkUserInfo.UserType = 0; rtkUserInfo.OrderNumber = orderlist.OrderNumber; rtkUserInfo.CORSCardNum = ""; rtkUserInfo.BelongArea = registerUser.BelongArea; rtkUserInfo.Contact = companyInfo.Contact; rtkUserInfo.ContactPhone = registerUser.Phone; rtkUserInfo.ContactEmail = registerUser.Email; rtkUserInfo.RegTime = DateTime.Now; if (!DAL.RTKUserInfo.Exists(rtkUserInfo.UserName)) { DAL.RTKUserInfo.Add(rtkUserInfo); } else { //如何已经存在则重新循环一次 i = i - 1; continue; } #region 权限信息部分 Model.RTKUserPurview rtkUserPurview = new Model.RTKUserPurview(); Model.RTKPostPurview rTKPostPurview = new Model.RTKPostPurview(); string startTime = DateTime.Now.ToString(); rtkUserPurview.UserName = rtkUserInfo.UserName; rtkUserPurview.StartTime = DateTime.Now; rtkUserPurview.EndTime = DateTime.Now.AddMonths(Convert.ToInt32(orderlist.ServiceDuration)); rtkUserPurview.ServerType = orderlist.ServerType; string CoorSystem = ""; string SourceTable = ""; rtkUserPurview.VRSEnable = 1; rtkUserPurview.SourceTable = SourceTable; rtkUserPurview.CoorSystem = CoorSystem; if (orderlist.RoamID == "" || orderlist.RoamID == null) { rtkUserPurview.RoamID = ""; } else { rtkUserPurview.RoamID = orderlist.RoamID; } if (orderlist.ElevationEnable == 1) { rtkUserPurview.ElevationEnable = 1; } else { rtkUserPurview.ElevationEnable = 0; } rTKPostPurview.UserName = rtkUserInfo.UserName; rTKPostPurview.StartTime = DateTime.Now; rTKPostPurview.EndTime = DateTime.Now.AddMonths(Convert.ToInt32(orderlist.ServiceDuration)); DAL.RTKPostPurview.Add(rTKPostPurview); DAL.RTKUserPurview.Add(rtkUserPurview); companyInfo.Balance = companyInfo.Balance - Convert.ToSingle(orderlist.Price); DAL.CompanyInfo.Update2(companyInfo); #endregion } } if (orderlist.OrdeType == 3)//账号申请(自定义账号) { //订单审核通过后添加发票信息 Model.InvoiceList invoicelist = new Model.InvoiceList(); invoicelist.OrderDetail = orderlist.ID.ToString(); invoicelist.OrderNumber = orderlist.OrderNumber; invoicelist.BelongArea = orderlist.WorkArea; invoicelist.PayTime = orderlist.PayTime; invoicelist.Price = orderlist.Price; invoicelist.Status = 1; invoicelist.ContractStatus = 1; invoicelist.UserName = orderlist.UserName; invoicelist.Type = 0; DAL.InvoiceList.Add(invoicelist); Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo(); Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName); Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(registerUser.CertifiationIndex)); DataSet ds = DAL.DeUserInfo.GetList(orderlist.OrderNumber); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { rtkUserInfo.RegisterUserName = orderlist.UserName; rtkUserInfo.UserName = ds.Tables[0].Rows[i]["UserName"].ToString(); rtkUserInfo.Company = companyInfo.Company; rtkUserInfo.PassWord = AES_Key.AESEncrypt(rtkUserInfo.UserName, rtkUserInfo.UserName.PadLeft(16, '0')); rtkUserInfo.UserType = 0; rtkUserInfo.OrderNumber = orderlist.OrderNumber; rtkUserInfo.BelongArea = registerUser.BelongArea; rtkUserInfo.Contact = companyInfo.Contact; rtkUserInfo.ContactPhone = registerUser.Phone; rtkUserInfo.ContactEmail = registerUser.Email; rtkUserInfo.CORSCardNum = ""; rtkUserInfo.RegTime = DateTime.Now; if (!DAL.RTKUserInfo.Exists(rtkUserInfo.UserName)) { DAL.RTKUserInfo.Add(rtkUserInfo); } else { //如何已经存在则重新循环一次 i = i - 1; continue; } #region 权限信息部分 Model.RTKUserPurview rtkUserPurview = new Model.RTKUserPurview(); Model.RTKPostPurview rTKPostPurview = new Model.RTKPostPurview(); string startTime = DateTime.Now.ToString(); rtkUserPurview.UserName = rtkUserInfo.UserName; rtkUserPurview.StartTime = DateTime.Now; rtkUserPurview.EndTime = DateTime.Now.AddMonths(Convert.ToInt32(orderlist.ServiceDuration)); rtkUserPurview.ServerType = orderlist.ServerType; string CoorSystem = ""; string SourceTable = ""; rtkUserPurview.VRSEnable = 1; rtkUserPurview.SourceTable = SourceTable; rtkUserPurview.CoorSystem = CoorSystem; if (orderlist.RoamID == "" || orderlist.RoamID == null) { rtkUserPurview.RoamID = ""; } else { rtkUserPurview.RoamID = orderlist.RoamID; } if (orderlist.ElevationEnable == 1) { rtkUserPurview.ElevationEnable = 1; } else { rtkUserPurview.ElevationEnable = 0; } rTKPostPurview.UserName = rtkUserInfo.UserName; rTKPostPurview.StartTime = DateTime.Now; rTKPostPurview.EndTime = DateTime.Now.AddMonths(Convert.ToInt32(orderlist.ServiceDuration)); DAL.RTKPostPurview.Add(rTKPostPurview); DAL.RTKUserPurview.Add(rtkUserPurview); #endregion } companyInfo.Balance = companyInfo.Balance - Convert.ToSingle(orderlist.Price); DAL.CompanyInfo.Update2(companyInfo); Model.PaymentRecord paymentRecord = new Model.PaymentRecord(); paymentRecord.ProductName = "账号申请"; paymentRecord.Company = orderlist.company; paymentRecord.Type = orderlist.OrdeType; paymentRecord.Money = "-" + orderlist.Price; paymentRecord.RechargeTime = DateTime.Now; paymentRecord.UserName = orderlist.UserName; DAL.PaymentRecord.Add(paymentRecord); } if (orderlist.OrdeType == 1)//账号续费 { Model.InvoiceList invoicelist = new Model.InvoiceList(); invoicelist.OrderDetail = orderlist.ID.ToString(); invoicelist.OrderNumber = orderlist.OrderNumber; invoicelist.BelongArea = orderlist.WorkArea; invoicelist.PayTime = orderlist.PayTime; invoicelist.Price = orderlist.Price; invoicelist.Status = 1; invoicelist.ContractStatus = 1; invoicelist.UserName = orderlist.UserName; invoicelist.Type = 1; DAL.InvoiceList.Add(invoicelist); string a = orderlist.OrderContent; string name = orderlist.OrderContent.Substring(4); Regex regex = new Regex(";");//以 [##] 分割 string[] result = regex.Split(name); for (int i = 0; i < result.Length; i++) { if (result[i] != "") { Model.RTKUserPurview rtkUserPurview = DAL.RTKUserPurview.GetModel(result[i]); Model.RTKPostPurview rTKPostPurview = DAL.RTKPostPurview.GetModel(result[i]); rtkUserPurview.UserName = result[i]; rtkUserPurview.EndTime = rtkUserPurview.EndTime.AddMonths(Convert.ToInt32(orderlist.ServiceDuration)); rTKPostPurview.UserName = result[i]; rTKPostPurview.EndTime = rTKPostPurview.EndTime.AddMonths(Convert.ToInt32(orderlist.ServiceDuration)); DAL.RTKPostPurview.Update1(rTKPostPurview); DAL.RTKUserPurview.Update1(rtkUserPurview); } } Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(orderlist.company); companyInfo.Balance = companyInfo.Balance - Convert.ToSingle(orderlist.Price); DAL.CompanyInfo.Update2(companyInfo); Model.PaymentRecord paymentRecord = new Model.PaymentRecord(); paymentRecord.ProductName = "账号续费"; paymentRecord.Company = orderlist.company; paymentRecord.Type = orderlist.OrdeType; paymentRecord.Money = "-" + orderlist.Price; paymentRecord.RechargeTime = DateTime.Now; paymentRecord.UserName = orderlist.UserName; DAL.PaymentRecord.Add(paymentRecord); } if (orderlist.OrdeType == 2)//账号充值 { Model.InvoiceList invoicelist = new Model.InvoiceList(); invoicelist.OrderDetail = orderlist.ID.ToString(); invoicelist.OrderNumber = orderlist.OrderNumber; invoicelist.BelongArea = orderlist.WorkArea; invoicelist.PayTime = orderlist.PayTime; invoicelist.Price = orderlist.Price; invoicelist.Status = 1; invoicelist.ContractStatus = 1; invoicelist.UserName = orderlist.UserName; invoicelist.Type = 2; DAL.InvoiceList.Add(invoicelist); Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(orderlist.company); companyInfo.Balance += Convert.ToSingle(orderlist.Price); DAL.CompanyInfo.Update2(companyInfo); Model.PaymentRecord paymentRecord = new Model.PaymentRecord(); paymentRecord.ProductName = "账号充值"; paymentRecord.Company = orderlist.company; paymentRecord.Type = orderlist.OrdeType; paymentRecord.Money = orderlist.Price; paymentRecord.RechargeTime = DateTime.Now; paymentRecord.UserName = orderlist.UserName; DAL.PaymentRecord.Add(paymentRecord); } } else { orderlist.OrderStatus = 3; } DAL.OrderList.Update(orderlist); return(true); } catch (System.Threading.ThreadAbortException) { return(true); } catch (Exception ex) { cs.WebLogger.WriteErroLog(ex.ToString()); //输出到文件中 //Response.Write("<script>alert(\"1\")</script>"); return(true); } }
/// <summary> /// 点击领取按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnGetRedPackage_Click(object sender, EventArgs e) { //请在0到8点之外的时间领取 int hour = DateTime.Now.Hour; if (hour >= 0 && hour <= 8) { this.lblMsg.Text = "很抱歉,请在0:00-8:00之外的时间领红包。"; log.WriteLog("很抱歉,请在0:00-8:00之外的时间领红包。"); return; } //获取到用户标识 bool isSucess = false; string re_openid = ""; if (ViewState["isSucess"] != null && ViewState["re_openid"] != null) { isSucess = (bool)ViewState["isSucess"]; re_openid = ViewState["re_openid"].ToString(); if (!isSucess || string.IsNullOrEmpty(re_openid)) { this.lblMsg.Text = "很抱歉,获取用户信息失败,请联系客服!"; log.WriteLog("很抱歉,获取用户信息失败,请联系客服!"); return; } } else { this.lblMsg.Text = "很抱歉,获取用户信息失败,请联系客服!"; log.WriteLog("很抱歉,获取用户信息失败,请联系客服!"); return; } //判断手机号是否合法 string phoneNo = this.txtPhoneNo.Text; //手机号 string msg = ""; if (!CheckIsLegal(phoneNo,out msg)) //验证输入是否合法 { this.lblMsg.Text = msg; return; } string nonce_str = weixin.randString(32); //随机字符串 string appid = ConfigurationManager.AppSettings["AppID"]; //公众账号 string mch_id = ConfigurationManager.AppSettings["mch_id"]; //商户号 string mch_billno = mch_id + DateTime.Now.ToString("yyyyMMdd") + DateTime.Now.Ticks.ToString().PadLeft(18).Substring(8, 10); //商户订单号 string send_name = "Luxlead洛诗琳"; //商户名称 string act_name = "双11红包疯狂送"; //活动名称 string wishing = "恭喜发财,大吉大利!"; //祝福语 string client_ip = "180.76.132.217"; //IP地址 string remark = "红包备注"; //备注 int total_amount = weixin.randInt(); //总金额(单位为分) int total_num = 1; //总数量(单位为个) //参数字符串 string parm = string.Format("nonce_str={0}&mch_billno={1}&mch_id={2}&wxappid={3}&send_name={4}&re_openid={5}&total_amount={6}&total_num={7}&wishing={8}&client_ip={9}&act_name={10}&remark={11}", nonce_str, mch_billno, mch_id, appid, send_name, re_openid, total_amount,total_num,wishing,client_ip, act_name,remark); //生成参数签名 string[] parmarr = parm.Split('&'); Dictionary<string, string> di = new Dictionary<string, string>(); foreach (string item in parmarr) { string[] dd = item.Split('='); di.Add(dd[0], dd[1]); } string sign = Sign.GetSign(di); parm = parm + "&sign=" + sign; string body = string.Format(@"<xml> <sign><![CDATA[{0}]]></sign> <mch_billno><![CDATA[{1}]]></mch_billno> <mch_id><![CDATA[{2}]]></mch_id> <wxappid><![CDATA[{3}]]></wxappid> <send_name><![CDATA[{4}]]></send_name> <re_openid><![CDATA[{5}]]></re_openid> <total_amount><![CDATA[{6}]]></total_amount> <total_num><![CDATA[{7}]]></total_num> <wishing><![CDATA[{8}]]></wishing> <client_ip><![CDATA[{9}]]></client_ip> <act_name><![CDATA[{10}]]></act_name> <remark><![CDATA[{11}]]></remark> <nonce_str><![CDATA[{12}]]></nonce_str> </xml>", sign, di["mch_billno"], di["mch_id"], di["wxappid"], di["send_name"], di["re_openid"], di["total_amount"], di["total_num"], di["wishing"], di["client_ip"], di["act_name"], di["remark"], di["nonce_str"]); log.WriteLog("微信红包接口Post的body数据是:" + body); try { string returnXml = weixin.PostHttp("https://api.mch.weixin.qq.com/mmpaymkttransfers/sendredpack", body); log.WriteLog("微信红包接口返回字符串:" + returnXml); //解析返回数据,跳转到领取页面 string returnMsg = "",showMsg=""; XmlSerialize xmlS = new XmlSerialize(); BaseReturn baseReturn = xmlS.XmlToModel<BaseReturn>(returnXml, "BaseReturn"); if (baseReturn.return_code.ToUpper() == "SUCCESS") { SuccessReturn successReturn = xmlS.XmlToModel<SuccessReturn>(returnXml, "SuccessReturn"); if (successReturn.result_code.ToUpper() == "SUCCESS") { //将红包领取汇总记录写入数据库 Model.WxOrder modelOrder = new WxOrder() { PhoneNo = phoneNo, TotalAmount = total_amount, Remark = mch_billno, }; if (bllPR.Update(modelOrder) <= 0) { log.WriteLog("微信红包领取汇总记录保存到数据库失败!"); this.lblMsg.Text = "很抱歉,领取失败,系统错误请联系客服!"; return; } else { log.WriteLog("微信红包领取汇总记录保存到数据库成功!"); } //将红包领取明细记录写入数据库 Model.PaymentRecord modlePR = new Model.PaymentRecord() { PhoneNo = phoneNo, WxOrderId = bllPR.GetOrderId(mch_billno), nonce_str = nonce_str, sign = sign, mch_billno = mch_billno, mch_id = mch_id, wxappid = appid, send_name = send_name, re_openid = re_openid, total_amount = total_amount, total_num = total_num, wishing = wishing, client_ip = client_ip, act_name = act_name, remark = remark, return_code = successReturn.result_code, return_msg = successReturn.return_msg, err_code = successReturn.err_code, err_code_des = successReturn.err_code_des, send_time = DateTime.ParseExact(successReturn.send_time, "yyyyMMddHHmmss", CultureInfo.CurrentCulture), send_listid = successReturn.send_listid, }; if (bllPR.Add(modlePR) <= 0) { log.WriteLog("微信红包领取明细记录保存到数据库失败!"); this.lblMsg.Text = "很抱歉,领取失败,请稍候再试!"; return; } else { log.WriteLog("微信红包领取明细记录保存到数据库成功!"); } returnMsg = string.Format("微信红包接口发送红包成功,发送时间是{0},微信订单号是{1}", successReturn.send_time, successReturn.send_listid); log.WriteLog(returnMsg); showMsg = "恭喜你,领取成功!"; this.lblMsg.Text = showMsg; this.btnGetRedPackage.Text = "领取成功!"; Response.Redirect("GetSuccess.aspx",false); return; } else { ErrorReturn errorReturn = xmlS.XmlToModel<ErrorReturn>(returnXml, "ErrorReturn"); returnMsg = string.Format("微信红包接口发送红包失败,错误代号:{0},错误消息:{1}。", errorReturn.err_code, errorReturn.err_code_des); switch (errorReturn.err_code.ToUpper()) { case "NO_AUTH": showMsg = string.Format("很抱歉,该微信账号异常,请使用活跃的微信号。"); break; case "TIME_LIMITED": showMsg = string.Format("很抱歉,请在0:00-8:00之外的时间领红包。"); break; case "NOTENOUGH": showMsg = string.Format("很抱歉,账户余额不足,请联系客服处理。"); break; default: showMsg = "很抱歉,领取失败,请联系客服处理。"; break; } } } else { ErrorReturn errorReturn = xmlS.XmlToModel<ErrorReturn>(returnXml,"ErrorReturn"); returnMsg = string.Format("微信红包接口发送红包失败,错误代号:{0},错误消息:{1}。", errorReturn.err_code, errorReturn.err_code_des); switch (errorReturn.err_code.ToUpper()) { case "NO_AUTH": showMsg = string.Format("很抱歉,该微信账号异常,请使用活跃的微信号。"); break; case "TIME_LIMITED": showMsg = string.Format("很抱歉,请在0:00-8:00之外的时间领红包。"); break; case "NOTENOUGH": showMsg = string.Format("很抱歉,账户余额不足,请联系客服处理。"); break; default: showMsg = "很抱歉,领取失败,请联系客服处理。"; break; } } if (!string.IsNullOrEmpty(showMsg)) { this.btnGetRedPackage.Text = "领红包"; } log.WriteLog(returnMsg); this.lblMsg.Text = showMsg; } catch (Exception ex) { log.WriteLog("微信红包接口调用错误,错误信息:" + ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (Request["name"] != null) { Session["RegisterUserName"] = Request["name"].ToString(); } DataSet ds = DAL.CoorSysPars.GetList("YSZBXM ='WGS84'"); foreach (DataRow dr in ds.Tables[0].Rows) { ssdfzbx.Items.Add(dr["MDZBXM"].ToString()); ssdfzbx1.Items.Add(dr["MDZBXM"].ToString()); } DataSet ds1 = DAL.SourceTable.GetList("1=1"); foreach (DataRow dr in ds1.Tables[0].Rows) { ssylbpz.Items.Add(dr["Source"].ToString()); ssylbpz1.Items.Add(dr["Source"].ToString()); } int companyCertifiationIndex = Convert.ToInt32(DAL.RegisterUser.GetModel(Session["RegisterUserName"].ToString()).CertifiationIndex); Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(companyCertifiationIndex); Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(Session["RegisterUserName"].ToString()); Company.Value = companyInfo.Company; Contacts.Value = companyInfo.Contact; phone.Value = registerUser.Phone; email.Value = registerUser.Email; Company1.Value = companyInfo.Company; Contacts1.Value = companyInfo.Contact; phone1.Value = registerUser.Phone; email1.Value = registerUser.Email; if (Request["action"] != null) { if (Request["action"].ToString() == "check") { string username = Request["data"].ToString(); DAL.RegisterUser du = new DAL.RegisterUser(); if (DAL.RTKUserInfo.GetModel(username) == null && DAL.RegisterUser.GetModel(username) == null) { Response.Clear(); Response.Write("1"); Response.End(); } else { Response.Clear(); Response.Write("0"); Response.End(); } } if (Request["action"].ToString() == "AddUser") { bool dele = true; string UserName = Request.Form["username"].ToString(); try { // 个人信息部分 DAL.RegisterUser du1 = new DAL.RegisterUser(); if (DAL.RTKUserInfo.GetModel(UserName) == null && DAL.RegisterUser.GetModel(UserName) == null) { } else { dele = false; Response.Clear(); Response.Write("-1"); Response.End(); return; } string PassWord = Request.Form["password"].ToString(); string WorkType = Request.Form["WorkType"].ToString(); string Contacts = Request.Form["Contacts"].ToString(); string Phone = Request.Form["phone"].ToString(); string Email = Request.Form["email"].ToString(); string Company = Request.Form["Company"].ToString(); int Enable = int.Parse(Request.Form["status"].ToString()); Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo(); rtkUserInfo.RegisterUserName = Session["RegisterUserName"].ToString(); rtkUserInfo.UserName = UserName; rtkUserInfo.Company = Company; rtkUserInfo.PassWord = AES_Key.AESEncrypt(PassWord, UserName.PadLeft(16, '0')); rtkUserInfo.UserType = 0; //rtkUserInfo.OrderNumber = ; // rtkUserInfo.BelongArea = registerUser.BelongArea; rtkUserInfo.Contact = Contacts; rtkUserInfo.ContactPhone = Phone; rtkUserInfo.ContactEmail = Email; rtkUserInfo.RegTime = DateTime.Now; rtkUserInfo.CORSCardNum = ""; if (DAL.RTKUserInfo.Add(rtkUserInfo)) { } else { Response.Clear(); Response.Write("0"); Response.End(); return; } // 权限信息部分 Model.RTKUserPurview mrtkp = new Model.RTKUserPurview(); int PostEnable = int.Parse(Request.Form["ssfwky"].ToString()); string StartTime = Request.Form["ssbsks"].ToString(); string EndTime = Request.Form["ssbsjs"].ToString(); string CoorSystem = Request.Form["sskyzbx"].ToString(); string SourceTable = Request.Form["sskyylb"].ToString(); int ElevationEnable = int.Parse(Request.Form["sszcghq"].ToString()); string ElevationMode = Request.Form["ssgcjz"].ToString(); mrtkp.AreaID = ""; mrtkp.ElevationEnable = ElevationEnable; mrtkp.ElevationMode = ElevationMode; mrtkp.SourceTable = SourceTable; mrtkp.UserName = UserName; mrtkp.VRSEnable = PostEnable; mrtkp.ServerType = WorkType; mrtkp.CoorSystem = CoorSystem; mrtkp.RoamID = ""; mrtkp.StartTime = Convert.ToDateTime(StartTime); mrtkp.EndTime = Convert.ToDateTime(EndTime); if (!DAL.RTKUserPurview.Exists(mrtkp.UserName)) { if (!DAL.RTKUserPurview.Add(mrtkp)) { DAL.RTKUserInfo.Delete(UserName); Response.Clear(); Response.Write("0"); Response.End(); return; } } Model.RTKPostPurview rTKPostPurview = new Model.RTKPostPurview(); rTKPostPurview.UserName = UserName; rTKPostPurview.CoorTransEnable = 0; rTKPostPurview.HeightTransEnable = 0; rTKPostPurview.SHPTransEnable = 0; rTKPostPurview.DXFTransEnable = 0; rTKPostPurview.PPPserverEnable = 0; rTKPostPurview.ObsQualityEnable = 0; rTKPostPurview.BaseLineEnable = 0; rTKPostPurview.StartTime = Convert.ToDateTime(StartTime); rTKPostPurview.EndTime = Convert.ToDateTime(EndTime); DAL.RTKPostPurview.Add(rTKPostPurview); //添加用户状态信息 Model.RTKUserStatus mrtks = new Model.RTKUserStatus(); mrtks.UserName = UserName; mrtks.Company = Company; mrtks.IsOnline = 0; mrtks.Lat = 0; mrtks.Lon = 0; mrtks.StartTime = Convert.ToDateTime(StartTime); mrtks.Remark = ""; DAL.RTKUserStatus bllrtkus = new DAL.RTKUserStatus(); if (!bllrtkus.Exists(UserName)) { if (DAL.RTKUserStatus.Add(mrtks)) { } } Model.OrderList orderList = new Model.OrderList(); orderList.UserName = Session["RegisterUserName"].ToString(); orderList.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff"); orderList.company = Company; orderList.Price = "1000"; orderList.DealTime = DateTime.Now; orderList.OrderContent = "账号申请"; orderList.OrderStatus = 2; orderList.OrdeType = 0; orderList.RoamID = ""; DAL.OrderList.Add(orderList); //修改单位余额 Model.CompanyInfo UpdatecompanyInfo = DAL.CompanyInfo.GetModel(Company); UpdatecompanyInfo.Balance = UpdatecompanyInfo.Balance - 1000; DAL.CompanyInfo.Update(UpdatecompanyInfo); //添加发票信息 Model.InvoiceList invoicelist = new Model.InvoiceList(); invoicelist.OrderDetail = orderList.ID.ToString(); invoicelist.OrderNumber = orderList.OrderNumber; invoicelist.BelongArea = orderList.WorkArea; invoicelist.PayTime = orderList.PayTime; invoicelist.Price = orderList.Price; invoicelist.Status = 1; invoicelist.ContractStatus = 1; invoicelist.UserName = orderList.UserName; DAL.InvoiceList.Add(invoicelist); //添加缴费记录 Model.PaymentRecord paymentRecord = new Model.PaymentRecord(); paymentRecord.ProductName = "账号申请"; paymentRecord.Company = Company; paymentRecord.Type = orderList.OrdeType; paymentRecord.Money = "-" + orderList.Price; paymentRecord.RechargeTime = DateTime.Now; paymentRecord.UserName = orderList.UserName; DAL.PaymentRecord.Add(paymentRecord); } catch { DAL.RTKUserInfo.Delete(UserName); DAL.RTKUserPurview.Delete(UserName); DAL.RTKUserStatus.Delete(UserName); DAL.RTKPostPurview.Delete(UserName); DAL.InvoiceList.Delete(UserName); Response.Clear(); Response.Write("0"); Response.End(); return; } Response.Clear(); Response.Write("1"); Response.End(); } if (Request["action"].ToString() == "AddUser1") { bool dele = true; for (int i = 0; i < Convert.ToInt32(AccountNumber.Value); i++) { int[] RandKey = cs.RandomNumber.UseHashTableToNonRepeatedRandom(4, 0, 9); string UserName = Session["RegisterUserName"].ToString() + string.Join("", RandKey); try { // 个人信息部分 DAL.RegisterUser du1 = new DAL.RegisterUser(); if (DAL.RTKUserInfo.GetModel(UserName) == null && DAL.RegisterUser.GetModel(UserName) == null) { } else { dele = false; Response.Clear(); Response.Write("-1"); Response.End(); return; } string PassWord = UserName; string WorkType = Request.Form["WorkType1"].ToString(); string Contacts = Request.Form["Contacts1"].ToString(); string Phone = Request.Form["phone1"].ToString(); string Email = Request.Form["email1"].ToString(); string Company = Request.Form["Company1"].ToString(); int Enable = int.Parse(Request.Form["status1"].ToString()); Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo(); rtkUserInfo.RegisterUserName = Session["RegisterUserName"].ToString(); rtkUserInfo.UserName = UserName; rtkUserInfo.Company = Company; rtkUserInfo.PassWord = AES_Key.AESEncrypt(PassWord, UserName.PadLeft(16, '0')); rtkUserInfo.UserType = 0; //rtkUserInfo.OrderNumber = ; // rtkUserInfo.BelongArea = registerUser.BelongArea; rtkUserInfo.Contact = Contacts; rtkUserInfo.ContactPhone = Phone; rtkUserInfo.ContactEmail = Email; rtkUserInfo.RegTime = DateTime.Now; rtkUserInfo.CORSCardNum = ""; if (DAL.RTKUserInfo.Add(rtkUserInfo)) { } else { Response.Clear(); Response.Write("0"); Response.End(); return; } // 权限信息部分 Model.RTKUserPurview mrtkp = new Model.RTKUserPurview(); int PostEnable = int.Parse(Request.Form["ssfwky1"].ToString()); string StartTime = Request.Form["ssbsks1"].ToString(); string EndTime = Request.Form["ssbsjs1"].ToString(); string CoorSystem = Request.Form["sskyzbx1"].ToString(); string SourceTable = Request.Form["sskyylb1"].ToString(); int ElevationEnable = int.Parse(Request.Form["sszcghq1"].ToString()); string ElevationMode = Request.Form["ssgcjz1"].ToString(); mrtkp.AreaID = ""; mrtkp.ElevationEnable = ElevationEnable; mrtkp.ElevationMode = ElevationMode; mrtkp.SourceTable = SourceTable; mrtkp.UserName = UserName; mrtkp.VRSEnable = PostEnable; mrtkp.ServerType = WorkType; mrtkp.CoorSystem = CoorSystem; mrtkp.RoamID = ""; mrtkp.StartTime = Convert.ToDateTime(StartTime); mrtkp.EndTime = Convert.ToDateTime(EndTime); mrtkp.RoamID = ""; if (!DAL.RTKUserPurview.Exists(mrtkp.UserName)) { if (!DAL.RTKUserPurview.Add(mrtkp)) { DAL.RTKUserInfo.Delete(UserName); Response.Clear(); Response.Write("0"); Response.End(); return; } } Model.RTKPostPurview rTKPostPurview = new Model.RTKPostPurview(); rTKPostPurview.UserName = UserName; rTKPostPurview.CoorTransEnable = 0; rTKPostPurview.HeightTransEnable = 0; rTKPostPurview.SHPTransEnable = 0; rTKPostPurview.DXFTransEnable = 0; rTKPostPurview.PPPserverEnable = 0; rTKPostPurview.ObsQualityEnable = 0; rTKPostPurview.BaseLineEnable = 0; rTKPostPurview.StartTime = Convert.ToDateTime(StartTime); rTKPostPurview.EndTime = Convert.ToDateTime(EndTime); DAL.RTKPostPurview.Add(rTKPostPurview); //添加用户状态信息 Model.RTKUserStatus mrtks = new Model.RTKUserStatus(); mrtks.UserName = UserName; mrtks.Company = Company; mrtks.IsOnline = 0; mrtks.Lat = 0; mrtks.Lon = 0; mrtks.StartTime = Convert.ToDateTime(StartTime); mrtks.Remark = ""; DAL.RTKUserStatus bllrtkus = new DAL.RTKUserStatus(); if (!bllrtkus.Exists(UserName)) { if (DAL.RTKUserStatus.Add(mrtks)) { } } Model.OrderList orderList = new Model.OrderList(); orderList.UserName = Session["RegisterUserName"].ToString(); orderList.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff"); orderList.company = Company; orderList.Price = "1000"; orderList.DealTime = DateTime.Now; orderList.OrderContent = "账号申请"; orderList.OrderStatus = 2; orderList.OrdeType = 0; orderList.RoamID = ""; DAL.OrderList.Add(orderList); //修改单位余额 Model.CompanyInfo UpdatecompanyInfo = DAL.CompanyInfo.GetModel(Company); UpdatecompanyInfo.Balance = UpdatecompanyInfo.Balance - 1000; DAL.CompanyInfo.Update(UpdatecompanyInfo); //添加发票信息 Model.InvoiceList invoicelist = new Model.InvoiceList(); invoicelist.OrderDetail = orderList.ID.ToString(); invoicelist.OrderNumber = orderList.OrderNumber; invoicelist.BelongArea = orderList.WorkArea; invoicelist.PayTime = orderList.PayTime; invoicelist.Price = orderList.Price; invoicelist.Status = 1; invoicelist.ContractStatus = 1; invoicelist.UserName = orderList.UserName; DAL.InvoiceList.Add(invoicelist); //添加缴费记录 Model.PaymentRecord paymentRecord = new Model.PaymentRecord(); paymentRecord.ProductName = "账号申请"; paymentRecord.Company = Company; paymentRecord.Type = orderList.OrdeType; paymentRecord.Money = "-" + orderList.Price; paymentRecord.RechargeTime = DateTime.Now; paymentRecord.UserName = orderList.UserName; DAL.PaymentRecord.Add(paymentRecord); } catch { DAL.RTKUserInfo.Delete(UserName); DAL.RTKUserPurview.Delete(UserName); DAL.RTKUserStatus.Delete(UserName); DAL.RTKPostPurview.Delete(UserName); DAL.InvoiceList.Delete(UserName); Response.Clear(); Response.Write("0"); Response.End(); return; } } Response.Clear(); Response.Write("1"); Response.End(); } } }