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();
}
}
