//public string result = ""; //public string usbelong = ""; protected void Page_Load(object sender, EventArgs e) { //if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 0 || Convert.ToInt32(Session["UserType"]) > 10) //{ // Response.Write("<script>alert(\"请登录\");location.href = \"https://oauth.zjzwfw.gov.cn/login.jsp\";</script>"); // //Response.Redirect("http://www.zjzwfw.gov.cn/"); // Response.End(); //} //if (!IsPostBack) //{ // DAL.UserInfoWeb du = new DAL.UserInfoWeb(); // usbelong = du.GetModelu(Session["UserName"].ToString()).BelongArea; // if (usbelong == "全省" || usbelong == "") // { // dataType1.SelectedIndex = 1; // } // else // { // dataType1.Items.Clear(); // dataType1.Items.Add(usbelong); // dataType1.SelectedIndex = 0; // } //} if (Request["action"] != null && Request["action"] == "GetData") { if (!GetCors()) { Response.Write("0"); } } if (Request["action"] != null && Request["action"] == "DeleteCors") { DeleteCors(); } if (Request["id"] != null) { Model.OrderList orderlist = DAL.OrderList.GetModel(Convert.ToInt32(Request["id"])); string img_path = orderlist.TransferCertificate; Response.Write("<img src='" + img_path + "' />"); Response.End(); } }
public static Model.OrderList GetModel(int ID) { string strSql = "select * from OrderList where ID = '" + ID + "'"; Model.OrderList model = new Model.OrderList(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.OrderNumber = Convert.ToString(ds.Tables[0].Rows[0]["OrderNumber"]); model.UserName = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]); model.SubmitTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["SubmitTime"]); model.OrderStatus = Convert.ToInt32(ds.Tables[0].Rows[0]["OrderStatus"]); model.WorkArea = Convert.ToString(ds.Tables[0].Rows[0]["WorkArea"]); model.ServerType = Convert.ToString(ds.Tables[0].Rows[0]["ServerType"]); model.CoorTransEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["CoorTransEnable"]); model.HeightTransEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["HeightTransEnable"]); model.SHPTransEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["SHPTransEnable"]); model.DXFTransEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["DXFTransEnable"]); model.PPPserverEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["PPPserverEnable"]); model.ObsQualityEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["ObsQualityEnable"]); model.BaseLineEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["BaseLineEnable"]); model.MultiBaseLineEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["MultiBaseLineEnable"]); model.CoorSystemEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["CoorSystemEnable"]); model.RoamingServiceEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["RoamingServiceEnable"]); model.RoamingServiceArea = Convert.ToString(ds.Tables[0].Rows[0]["RoamingServiceArea"]); model.AccountNum = Convert.ToInt32(ds.Tables[0].Rows[0]["AccountNum"]); model.ServiceDuration = Convert.ToString(ds.Tables[0].Rows[0]["ServiceDuration"]); model.Price = Convert.ToString(ds.Tables[0].Rows[0]["Price"]); model.Dealer = Convert.ToString(ds.Tables[0].Rows[0]["Dealer"]); model.DealTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["DealTime"]); model.PayMethod = Convert.ToInt32(ds.Tables[0].Rows[0]["PayMethod"]); model.TransferCertificate = Convert.ToString(ds.Tables[0].Rows[0]["TransferCertificate"]); model.PayTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["PayTime"]); return(model); } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { //Session["UserName"] = "******"; if (Request["action"] == "order") { Model.OrderList orderlist = new Model.OrderList(); orderlist.UserName = Session["UserName"].ToString(); orderlist.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff"); orderlist.SubmitTime = DateTime.Now; orderlist.AccountNum = Convert.ToInt32(Request["applynum"]); orderlist.ServiceDuration = Request["time"].ToString(); orderlist.ServerType = Request["servertype"].ToString(); string[] otherserver = Request["otherserver"].ToString().Split(','); if (Array.IndexOf(otherserver, "CoorTransEnable") != -1) { orderlist.CoorSystemEnable = 1; } if (Array.IndexOf(otherserver, "HeightTransEnable") != -1) { orderlist.HeightTransEnable = 1; } if (Array.IndexOf(otherserver, "SHPTransEnable") != -1) { orderlist.SHPTransEnable = 1; } if (Array.IndexOf(otherserver, "ObsQualityEnable") != -1) { orderlist.ObsQualityEnable = 1; } if (DAL.OrderList.Add(orderlist)) { Response.Write(orderlist.OrderNumber); Response.End(); } else { Response.Write("200"); Response.End(); } } }
private int AddData(string order_number) { string filename = Request.Files[0].FileName; string[] extname = filename.Split('.'); Model.OrderList orderlist = DAL.OrderList.GetModel(order_number); string savepath = Server.MapPath("~/upload/TransferCertificate/"); orderlist.TransferCertificate = "/upload/TransferCertificate/" + order_number + "." + extname[extname.Length - 1]; DAL.OrderList.Update(orderlist); try { Request.Files[0].SaveAs(savepath + order_number + "." + extname[extname.Length - 1]); return(1); } catch { return(-1); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 2 || Convert.ToInt32(Session["UserType"]) > 3) { Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>"); Response.End(); } if (Session["UserType"] != null && Session["UserType"].ToString() == "2") { Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString()); cityType.Items.Clear(); cityType.Items.Add(registerUser.BelongArea); cityType.Value = registerUser.BelongArea; belongArea = registerUser.BelongArea; } if (Request["action"] != null && Request["action"] == "GetData") { GetCors(); } if (Request["action"] != null && Request["action"] == "DeleteCors") { DeleteCors(); } if (Request["id"] != null) { Model.OrderList orderlist = DAL.OrderList.GetModel(Convert.ToInt32(Request["id"])); string img_path = orderlist.TransferCertificate; Response.Write("<img src='" + img_path + "' />"); Response.End(); } if (Request["verify"] != null) { AddData(); } if (Request["action"] != null && Request["action"] == "DownloadAll") { DownloadAll(); } }
protected void Page_Load(object sender, EventArgs e) { if (Request["order_number"] != null) { order_number = Request["order_number"]; Model.OrderList orderlist = DAL.OrderList.GetModel(order_number); price = orderlist.Price; } if (Request["action"] != null) { switch (Request["action"]) { case "AddData": //Response.ContentType = "text/plain"; AddData(order_number); //Response.End(); break; } } }
protected void Page_Load(object sender, EventArgs e) { //if (Request["action"] == "confirm") //{ // string ff = Request["ordernumber"]; // Response.Write(order_number); // Response.End(); // return; //} if (Request["action"] != null && Request["action"] == "back") { try { string orderNumber = Session["OrderNumber"].ToString(); DAL.OrderList.Delete(orderNumber); Response.End(); } catch (Exception ex) { cs.WebLogger.WriteErroLog(ex.ToString() + "用户撤回订单出错"); //输出到文件中 //Response.Write("<script>alert(\"1\")</script>"); return; } } else { if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 0 || Convert.ToInt32(Session["UserType"]) > 5) { Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>"); Response.End(); } string UserName = Session["UserName"].ToString(); Model.OrderList orderlist = new Model.OrderList(); order_number = Request["order_number"]; orderlist = DAL.OrderList.GetModel(order_number); price = orderlist.Price; company = orderlist.company; } }
protected void Page_Load(object sender, EventArgs e) { //if (Request["action"] == "confirm") //{ // string ff = Request["ordernumber"]; // Response.Write(order_number); // Response.End(); // return; //} if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 0 || Convert.ToInt32(Session["UserType"]) > 5) { Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>"); Response.End(); } string UserName = Session["UserName"].ToString(); Model.OrderList orderlist = new Model.OrderList(); order_number = Request["order_number"]; orderlist = DAL.OrderList.GetModel(order_number); //order_number.Value = Request["order_number"]; switch (orderlist.ServerType) { case "dm": servertype = "亚米级服务"; break; case "cm": servertype = "亚米级服务"; break; case "mm": servertype = "亚米级服务"; break; default: break; } servertime = orderlist.ServiceDuration + "个月"; }
/// <summary> /// 增加一个用户信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Add(Model.OrderList model) { string strSql = "insert into OrderList( UserName, OrderNumber, SubmitTime, OrderStatus, WorkArea, ServerType, CoorTransEnable, HeightTransEnable, SHPTransEnable, DXFTransEnable, PPPserverEnable, ObsQualityEnable, BaseLineEnable, MultiBaseLineEnable, CoorSystemEnable, RoamingServiceArea, RoamingServiceEnable, AccountNum, ServiceDuration, Price, Dealer, DealTime, PayMethod, TransferCertificate, PayTime,RoamID,company,OrderContent,OrdeType,ElevationEnable,IsRenew) values( @UserName, @OrderNumber, @SubmitTime, @OrderStatus, @WorkArea, @ServerType, @CoorTransEnable, @HeightTransEnable, @SHPTransEnable, @DXFTransEnable, @PPPserverEnable, @ObsQualityEnable, @BaseLineEnable, @MultiBaseLineEnable, @CoorSystemEnable, @RoamingServiceArea, @RoamingServiceEnable, @AccountNum, @ServiceDuration, @Price, @Dealer, @DealTime, @PayMethod, @TransferCertificate, @PayTime,@RoamID,@company,@OrderContent,@OrdeType,@ElevationEnable,@IsRenew)"; SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName; SqlParameter OrderNumber = new SqlParameter("OrderNumber", SqlDbType.NVarChar); OrderNumber.Value = model.OrderNumber; SqlParameter SubmitTime = new SqlParameter("SubmitTime", SqlDbType.DateTime); SubmitTime.Value = model.SubmitTime; SqlParameter OrderStatus = new SqlParameter("OrderStatus", SqlDbType.Int); OrderStatus.Value = model.OrderStatus; SqlParameter WorkArea = new SqlParameter("WorkArea", SqlDbType.NVarChar); WorkArea.Value = model.WorkArea; SqlParameter ServerType = new SqlParameter("ServerType", SqlDbType.NVarChar); ServerType.Value = model.ServerType; SqlParameter CoorTransEnable = new SqlParameter("CoorTransEnable", SqlDbType.Int); CoorTransEnable.Value = model.CoorTransEnable; SqlParameter HeightTransEnable = new SqlParameter("HeightTransEnable", SqlDbType.Int); HeightTransEnable.Value = model.HeightTransEnable; SqlParameter SHPTransEnable = new SqlParameter("SHPTransEnable", SqlDbType.Int); SHPTransEnable.Value = model.SHPTransEnable; SqlParameter DXFTransEnable = new SqlParameter("DXFTransEnable", SqlDbType.Int); DXFTransEnable.Value = model.DXFTransEnable; SqlParameter PPPserverEnable = new SqlParameter("PPPserverEnable", SqlDbType.Int); PPPserverEnable.Value = model.PPPserverEnable; SqlParameter ObsQualityEnable = new SqlParameter("ObsQualityEnable", SqlDbType.Int); ObsQualityEnable.Value = model.ObsQualityEnable; SqlParameter BaseLineEnable = new SqlParameter("BaseLineEnable", SqlDbType.Int); BaseLineEnable.Value = model.BaseLineEnable; SqlParameter MultiBaseLineEnable = new SqlParameter("MultiBaseLineEnable", SqlDbType.Int); MultiBaseLineEnable.Value = model.MultiBaseLineEnable; SqlParameter CoorSystemEnable = new SqlParameter("CoorSystemEnable", SqlDbType.Int); CoorSystemEnable.Value = model.CoorSystemEnable; SqlParameter RoamingServiceEnable = new SqlParameter("RoamingServiceEnable", SqlDbType.Int); RoamingServiceEnable.Value = model.RoamingServiceEnable; SqlParameter RoamingServiceArea = new SqlParameter("RoamingServiceArea", SqlDbType.NVarChar); RoamingServiceArea.Value = model.RoamingServiceArea; SqlParameter AccountNum = new SqlParameter("AccountNum", SqlDbType.Int); AccountNum.Value = model.AccountNum; SqlParameter ServiceDuration = new SqlParameter("ServiceDuration", SqlDbType.NVarChar); ServiceDuration.Value = model.ServiceDuration; SqlParameter Price = new SqlParameter("Price", SqlDbType.NVarChar); Price.Value = model.Price; SqlParameter Dealer = new SqlParameter("Dealer", SqlDbType.NVarChar); Dealer.Value = model.Dealer; SqlParameter DealTime = new SqlParameter("DealTime", SqlDbType.DateTime); DealTime.Value = model.DealTime; SqlParameter PayTime = new SqlParameter("PayTime", SqlDbType.DateTime); PayTime.Value = model.PayTime; SqlParameter TransferCertificate = new SqlParameter("TransferCertificate", SqlDbType.NVarChar); TransferCertificate.Value = model.TransferCertificate; SqlParameter PayMethod = new SqlParameter("PayMethod", SqlDbType.NVarChar); PayMethod.Value = model.PayMethod; SqlParameter RoamID = new SqlParameter("RoamID", SqlDbType.NVarChar); RoamID.Value = model.RoamID; SqlParameter company = new SqlParameter("company", SqlDbType.NVarChar); company.Value = model.company; SqlParameter OrderContent = new SqlParameter("OrderContent", SqlDbType.NVarChar); OrderContent.Value = model.OrderContent; SqlParameter OrdeType = new SqlParameter("OrdeType", SqlDbType.NVarChar); OrdeType.Value = model.OrdeType; SqlParameter ElevationEnable = new SqlParameter("ElevationEnable", SqlDbType.NVarChar); ElevationEnable.Value = model.ElevationEnable; SqlParameter IsRenew = new SqlParameter("IsRenew", SqlDbType.NVarChar); IsRenew.Value = model.IsRenew; return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, OrderNumber, SubmitTime, OrderStatus, WorkArea, ServerType, CoorTransEnable, HeightTransEnable, SHPTransEnable, DXFTransEnable, PPPserverEnable, ObsQualityEnable, BaseLineEnable, MultiBaseLineEnable, CoorSystemEnable, RoamingServiceArea, RoamingServiceEnable, AccountNum, ServiceDuration, Price, Dealer, DealTime, PayMethod, TransferCertificate, PayTime, RoamID, company, OrderContent, OrdeType, ElevationEnable, IsRenew }, 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); } }
public void AddOrderList(Domain.Model.OrderList orderList) { Model.OrderList entity = Mapper.MapOrderLists(orderList); _dbContext.Add(entity); }
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(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserName"] == null || Session["UserType"] == null) { Response.Write("<script>alert(\"请登录\");parent.window.location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>"); Response.End(); } DataSet dsRoamArea = DAL.RoamArea.GetList("1=1"); foreach (DataRow dr in dsRoamArea.Tables[0].Rows) { Select2.Items.Add(dr["AreaName"].ToString()); Select4.Items.Add(dr["AreaName"].ToString()); } } if (Request["action"] == "check") { string username = Request["data"].ToString(); DAL.RegisterUser du = new DAL.RegisterUser(); if (DAL.RTKUserInfo.GetModel(username) == null && DAL.RegisterUser.GetModel(username) == null && DAL.DeUserInfo.GetModel(username) == null) { Response.Clear(); Response.Write("1"); Response.End(); } else { Response.Clear(); Response.Write("0"); Response.End(); } } //Session["UserName"] = "******"; if (Request["action"] == "order") { Model.OrderList orderlist = new Model.OrderList(); orderlist.UserName = Session["UserName"].ToString(); Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName); orderlist.WorkArea = registerUser.BelongArea; orderlist.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff"); //将订单号存储在session里面用于整个订单的操作流程。 Session["OrderNumber"] = orderlist.OrderNumber; orderlist.SubmitTime = DateTime.Now; orderlist.AccountNum = Convert.ToInt32(Request["applynum"]); orderlist.ServiceDuration = Request["time"].ToString(); orderlist.ServerType = Request["servertype"].ToString(); Model.RegisterUser RegisterUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString()); Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(RegisterUser.CertifiationIndex)); orderlist.company = companyInfo.Company; orderlist.OrdeType = 0; orderlist.Price = Request["price"].ToString(); if (Select1.Value == "是") { orderlist.RoamID = this.Select2.Value;//保存的漫游ID } else { orderlist.RoamID = ""; } if (Checkbox1.Checked == true) { orderlist.ElevationEnable = 1; } else { orderlist.ElevationEnable = 0; } string[] otherserver = Request["otherserver"].ToString().Split(','); if (Array.IndexOf(otherserver, "CoorTransEnable") != -1) { orderlist.CoorSystemEnable = 1; } if (Array.IndexOf(otherserver, "HeightTransEnable") != -1) { orderlist.HeightTransEnable = 1; } if (Array.IndexOf(otherserver, "SHPTransEnable") != -1) { orderlist.SHPTransEnable = 1; } if (Array.IndexOf(otherserver, "ObsQualityEnable") != -1) { orderlist.ObsQualityEnable = 1; } if (DAL.OrderList.Add(orderlist)) { Response.Write(orderlist.OrderNumber); //Model.SysLog syslog = new Model.SysLog(); //syslog.LogTime = DateTime.Now; //syslog.LogType = 5; //syslog.Remark = "申请的服务订单待处理"; //syslog.UserName = orderlist.UserName; //DAL.SysLog.Add(syslog); Response.End(); } else { Response.Write("200"); Response.End(); } } if (Request["action"] == "order1") { Model.OrderList orderlist = new Model.OrderList(); orderlist.UserName = Session["UserName"].ToString(); Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName); orderlist.WorkArea = registerUser.BelongArea; orderlist.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff"); //将订单号存储在session里面用于整个订单的操作流程。 Session["OrderNumber"] = orderlist.OrderNumber; orderlist.SubmitTime = DateTime.Now; orderlist.AccountNum = Convert.ToInt32(Request["applynum1"]); orderlist.ServiceDuration = Request["time1"].ToString(); orderlist.ServerType = Request["servertype1"].ToString(); Model.RegisterUser RegisterUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString()); Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(RegisterUser.CertifiationIndex)); orderlist.company = companyInfo.Company; orderlist.OrdeType = 3; orderlist.Price = Request["price1"].ToString(); if (Select3.Value == "是") { orderlist.RoamID = this.Select4.Value;//保存的漫游ID } else { orderlist.RoamID = ""; } if (Checkbox2.Checked == true) { orderlist.ElevationEnable = 1; } else { orderlist.ElevationEnable = 0; } if (Checkbox3.Checked == true) { orderlist.ElevationEnable = 1; } else { orderlist.ElevationEnable = 0; } string[] otherserver = Request["otherserver1"].ToString().Split(','); if (Array.IndexOf(otherserver, "CoorTransEnable") != -1) { orderlist.CoorSystemEnable = 1; } if (Array.IndexOf(otherserver, "HeightTransEnable") != -1) { orderlist.HeightTransEnable = 1; } if (Array.IndexOf(otherserver, "SHPTransEnable") != -1) { orderlist.SHPTransEnable = 1; } if (Array.IndexOf(otherserver, "ObsQualityEnable") != -1) { orderlist.ObsQualityEnable = 1; } string[] sys = Request["username1"].ToString().Split(','); if (DAL.OrderList.Add(orderlist)) { foreach (string s in sys) { if (s != null || s != "") { Model.DeUserInfo deUserInfo = new Model.DeUserInfo(); deUserInfo.UserName = s; deUserInfo.UserPwd = AES_Key.AESEncrypt(s, s.PadLeft(16, '0')); deUserInfo.OrderNumber = orderlist.OrderNumber; DAL.DeUserInfo.Add(deUserInfo); } else { Response.Write("<script >alert('用户名不能为空!');</script>"); } } Response.Write(orderlist.OrderNumber); //Model.SysLog syslog = new Model.SysLog(); //syslog.LogTime = DateTime.Now; //syslog.LogType = 5; //syslog.Remark = "申请的服务订单待处理"; //syslog.UserName = orderlist.UserName; //DAL.SysLog.Add(syslog); Response.End(); } else { Response.Write("200"); Response.End(); } } }