public static Model.RTKPostPurview GetModel(int ID) { string strSql = "select * from RTKPostPurview where ID = '" + ID + "'"; Model.RTKPostPurview model = new Model.RTKPostPurview(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.UserName = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]); 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.StartTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["StartTime"]); model.EndTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["EndTime"]); return model; } else { return null; } }
/// <summary> /// 增加一个用户信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Add(Model.RTKPostPurview model) { string strSql = "insert into RTKPostPurview( UserName, CoorTransEnable, HeightTransEnable, SHPTransEnable, DXFTransEnable, PPPserverEnable, ObsQualityEnable, BaseLineEnable, MultiBaseLineEnable, StartTime, EndTime) values( @UserName, @CoorTransEnable, @HeightTransEnable, @SHPTransEnable, @DXFTransEnable, @PPPserverEnable, @ObsQualityEnable, @BaseLineEnable, @MultiBaseLineEnable, @StartTime, @EndTime)"; SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName; 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 StartTime = new SqlParameter("StartTime", SqlDbType.DateTime); StartTime.Value = model.StartTime; SqlParameter EndTime = new SqlParameter("EndTime", SqlDbType.DateTime); EndTime.Value = model.EndTime; return DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, CoorTransEnable, HeightTransEnable, SHPTransEnable, DXFTransEnable, PPPserverEnable, ObsQualityEnable, BaseLineEnable, MultiBaseLineEnable, StartTime, EndTime }, connectionString) == 1 ? true : false; }
/// <summary> /// 更新一条数据,根据ID /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Update(Model.RTKPostPurview model) { string strSql = "update RTKPostPurview set UserName=@UserName, CoorTransEnable=@CoorTransEnable, HeightTransEnable=@HeightTransEnable, SHPTransEnable=@SHPTransEnable, DXFTransEnable=@DXFTransEnable, PPPserverEnable=@PPPserverEnable, ObsQualityEnable=@ObsQualityEnable, BaseLineEnable=@BaseLineEnable, MultiBaseLineEnable=@MultiBaseLineEnable, StartTime=@StartTime, EndTime=@EndTime where ID = " + model.ID.ToString(); SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName; 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 StartTime = new SqlParameter("StartTime", SqlDbType.DateTime); StartTime.Value = model.StartTime; SqlParameter EndTime = new SqlParameter("EndTime", SqlDbType.DateTime); EndTime.Value = model.EndTime; return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, CoorTransEnable, HeightTransEnable, SHPTransEnable, DXFTransEnable, PPPserverEnable, ObsQualityEnable, BaseLineEnable, MultiBaseLineEnable, StartTime, EndTime }, 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); } }
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 (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 1 || Convert.ToInt32(Session["UserType"]) > 3) { Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/login/login.aspx\";</script>"); Response.End(); } if (!IsPostBack) { rtkUserInfoId = Convert.ToInt32(Request["id"]); if (rtkUserInfoId == null) { Response.Redirect("/forms/administrator/users/RtkUserManage.aspx"); Response.End(); } #region 加载初始数据 //作业区域 DataSet dswork = DAL.WorkingArea.GetList("1=1"); foreach (DataRow dr in dswork.Tables[0].Rows) { sszyqu.Items.Add(dr["AreaName"].ToString()); } //源列表 DataSet dssource = DAL.SourceTable.GetList("1=1"); foreach (DataRow dr in dssource.Tables[0].Rows) { ssylbpz.Items.Add(dr["Source"].ToString()); } // 坐标系 DataSet dsCoor = DAL.CoorSysPars.GetList("YSZBXM ='WGS84'"); foreach (DataRow dr in dsCoor.Tables[0].Rows) { ssdfzbx.Items.Add(dr["MDZBXM"].ToString()); shzbzhlb.Items.Add(dr["YSZBXM"].ToString() + "_" + dr["MDZBXM"].ToString()); } #endregion #region 用户信息 Model.RTKUserInfo mrtk = DAL.RTKUserInfo.GetModel(rtkUserInfoId); if (mrtk.UserType == 1) { cominfo1.Visible = false; cominfo12.Visible = false; cominfo3.Visible = false; cominfo4.Visible = false; } else { user1.Visible = false; user2.Visible = false; } UserName.Value = mrtk.UserName; PassWord.Value = AES_Key.AESDecrypt(mrtk.PassWord, mrtk.UserName.PadLeft(16, '0')); if (mrtk.UserType == -1) { corszhky.SelectedIndex = 1; } else { corszhky.SelectedIndex = 0; } Contacts.Value = mrtk.Contact; Phone.Value = mrtk.ContactPhone; contactEmail.Value = mrtk.ContactEmail; regtime.Value = mrtk.RegTime.ToString(); #endregion if (mrtk.UserType == 1) { //IDCardNumber.Value = mrtk.IDCardNumber; //IDCard.Value = mrtk.IDCard; } else { try { Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(mrtk.Company); company.Value = companyInfo.Company; BelongArea.Value = companyInfo.BelongArea; dwType.Value = companyInfo.Industry; Industry.Value = companyInfo.Industry; } catch { } } corsbelongarea.Value = mrtk.BelongArea; #region 用户权限 Model.RTKUserPurview rTKUserPurview = DAL.RTKUserPurview.GetModel(mrtk.UserName); Model.RTKPostPurview rTKPostPurview = DAL.RTKPostPurview.GetModel(mrtk.UserName); if (rTKUserPurview.ServerType == "cm") { corstype.Value = "厘米级"; } else { corstype.Value = "亚米级"; } if (rTKUserPurview.VRSEnable == 1) { ssfwky.SelectedIndex = 1; } else { ssfwky.SelectedIndex = 0; } ssbsks.Value = rTKUserPurview.StartTime.ToString(); ssbsjs.Value = rTKUserPurview.EndTime.ToString(); if (rTKPostPurview.CoorTransEnable == 1) { ssdfzbxhq.SelectedIndex = 0; } else { ssdfzbxhq.SelectedIndex = 1; } sskyzbx.Value = rTKUserPurview.CoorSystem; if (rTKUserPurview.CoorSystem == "") { ssdfzbxky.SelectedIndex = 0; } else { ssdfzbxky.SelectedIndex = 1; ssdfzbx.Value = rTKUserPurview.CoorSystem.Split(';')[0]; } if (rTKUserPurview.SourceTable == "") { ssylbky.SelectedIndex = 0; } else { ssylbky.SelectedIndex = 1; ssylbpz.Value = rTKUserPurview.SourceTable.Split(';')[0]; } sskyylb.Value = rTKUserPurview.SourceTable; if (rTKUserPurview.AreaID == "") { sskyqu.Value = "全部区域"; sszyqu.SelectedIndex = 0; sszyqyky.SelectedIndex = 1; } else { string[] workareas = rTKUserPurview.AreaID.Split(';'); string workarea = ""; foreach (var wo in workareas) { try { workarea += (DAL.WorkingArea.GetModel(int.Parse(wo)).AreaName + ";"); } catch (Exception) { } } sskyqu.Value = workarea; //mrtkpur.AreaID;// sszyqyky.SelectedIndex = 1; sszyqu.Value = DAL.WorkingArea.GetModel(int.Parse(workareas[0])).AreaName; //workareas[0];// } if (rTKUserPurview.ElevationEnable == 1) { sszcghq.SelectedIndex = 1; } else { sszcghq.SelectedIndex = 0; } if (rTKUserPurview.ElevationMode.Contains("85")) { ssgcjz.SelectedIndex = 0; } else { ssgcjz.SelectedIndex = 1; } if (rTKUserPurview.ServerType == "cm") { WorkType.Value = "厘米级"; } else { if (rTKUserPurview.ServerType == "dm") { WorkType.Value = "亚米级"; } else { if (rTKUserPurview.ServerType == "m") { WorkType.Value = "米级"; } else { WorkType.Value = "厘米级"; } } } #endregion } if (Request["action"] == "save") { #region 用户个人信息 Model.RTKUserInfo rTKUserInfo = DAL.RTKUserInfo.GetModel(rtkUserInfoId); rTKUserInfo.UserName = Request.Form["UserName"].ToString(); try { rTKUserInfo.Company = Request.Form["Company"].ToString(); } catch { rTKUserInfo.Company = "个人"; } rTKUserInfo.PassWord = AES_Key.AESEncrypt(Request.Form["PassWord"].ToString().Trim(), Request.Form["UserName"].ToString().Trim().PadLeft(16, '0')); rTKUserInfo.ContactPhone = Request.Form["Phone"].ToString(); rTKUserInfo.ContactEmail = Request.Form["contactEmail"].ToString(); rTKUserInfo.RegTime = DateTime.Parse(Request.Form["regtime"].ToString()); if (Request.Form["corszhky"].ToString().Trim() == "可用") { rTKUserInfo.UserType = -1; } try { if (Request.Form["BelongArea"].ToString() == "") { rTKUserInfo.BelongArea = "全部"; } else { rTKUserInfo.BelongArea = Request.Form["BelongArea"].ToString(); } } catch { rTKUserInfo.BelongArea = "全部"; } if (rTKUserInfo.UserType == 1) { //rTKUserInfo.IDCard = Request.Form["IDCard"].ToString(); //rTKUserInfo.IDCardNumber = Request.Form["IDCardNumber"].ToString(); } else { rTKUserInfo.UserType = 0; Model.CompanyInfo mci = DAL.CompanyInfo.GetModel(rTKUserInfo.Company); } rTKUserInfo.BelongArea = Request.Form["corsbelongarea"].ToString(); DAL.RTKUserInfo.Update(rTKUserInfo); #endregion #region 权限 Model.RTKUserPurview rTKUserPurview = DAL.RTKUserPurview.GetModel(rTKUserInfo.UserName); Model.RTKPostPurview rTKPostPurview = DAL.RTKPostPurview.GetModel(rTKUserInfo.UserName); rTKUserPurview.AreaID = Request.Form["sskyqu"].ToString(); if (Request.Form["ssbsjs"] == null || Request.Form["ssbsjs"] == "") { rTKUserPurview.EndTime = DateTime.Now; rTKPostPurview.EndTime = DateTime.Now; } else { rTKUserPurview.EndTime = DateTime.Parse(Request.Form["ssbsjs"].ToString()); rTKPostPurview.EndTime = DateTime.Parse(Request.Form["ssbsjs"].ToString()); } if (Request.Form["WorkType"].ToString() == "厘米级") { rTKUserPurview.ServerType = "cm"; } if (Request.Form["WorkType"].ToString() == "亚米级") { rTKUserPurview.ServerType = "dm"; } if (Request.Form["WorkType"].ToString() == "米级") { rTKUserPurview.ServerType = "m"; } if (Request.Form["sskyqu"].ToString().Trim() == "全部区域") { rTKUserPurview.AreaID = ""; } else { string[] areanames = Request.Form["sskyqu"].ToString().Split(';'); rTKUserPurview.AreaID = ""; foreach (var aname in areanames) { try { rTKUserPurview.AreaID += (DAL.WorkingArea.GetModel(aname).ID + ";"); } catch (Exception) { } } } if (Request.Form["ssgcjz"].ToString().Trim() == "56国家高程") { rTKUserPurview.ElevationMode = "56GC"; } else { rTKUserPurview.ElevationMode = "85GC"; } if (Request.Form["sszcghq"] == null) { if (sszcghq.SelectedIndex == 1) { rTKUserPurview.ElevationEnable = 1; } else { rTKUserPurview.ElevationEnable = 0; } } else { if (Request.Form["sszcghq"].ToString().Trim() == "可用") { rTKUserPurview.ElevationEnable = 1; } else { rTKUserPurview.ElevationEnable = 0; } } if (Request.Form["ssdfzbxhq"].ToString().Trim() == "可用") { rTKPostPurview.CoorTransEnable = 1; } else { rTKPostPurview.CoorTransEnable = 0; } rTKUserPurview.CoorSystem = Request.Form["sskyzbx"].ToString(); rTKUserPurview.SourceTable = Request.Form["sskyylb"].ToString(); rTKUserPurview.UserName = Request.Form["username"].ToString(); if (Request.Form["ssfwky"].ToString().Trim() == "否") { rTKUserPurview.VRSEnable = 0; } else { rTKUserPurview.VRSEnable = 1; } //DAL.RTKUserPurview.Update(rTKUserPurview); //DAL.RTKPostPurview.Update(rTKPostPurview); #endregion Model.SysLog msyslog = new Model.SysLog(); msyslog.UserName = Session["UserName"].ToString(); msyslog.LogTime = DateTime.Now; msyslog.LogType = 0; msyslog.Remark = "管理员修改了CORS用户:" + rTKUserInfo.UserName; DAL.SysLog.Add(msyslog); Response.Clear(); Response.Write("1"); Response.End(); } }