/// <summary>
/// 得到一个实体对象
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public static Model.RTKUserInfo GetModel(string UserName)
{
string strSql = "select * from RTKUserInfo where UserName = '******'";
Model.RTKUserInfo model = new Model.RTKUserInfo();
DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString);
model.UserName = UserName;
if (ds.Tables[0].Rows.Count > 0)
{
model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);
model.PassWord = Convert.ToString(ds.Tables[0].Rows[0]["PassWord"]);
model.Contact = Convert.ToString(ds.Tables[0].Rows[0]["Contact"]);
model.ContactPhone = Convert.ToString(ds.Tables[0].Rows[0]["ContactPhone"]);
model.ContactEmail = Convert.ToString(ds.Tables[0].Rows[0]["ContactEmail"]);
model.ContactQQ = Convert.ToString(ds.Tables[0].Rows[0]["ContactQQ"]);
model.CORSCardNum = Convert.ToString(ds.Tables[0].Rows[0]["CORSCardNum"]);
model.ReceiverNum = Convert.ToString(ds.Tables[0].Rows[0]["ReceiverNum"]);
model.Company = Convert.ToString(ds.Tables[0].Rows[0]["Company"]);
model.RegTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["RegTime"]);
model.UserType = Convert.ToInt32(ds.Tables[0].Rows[0]["UserType"]);
model.OrderNumber = Convert.ToString(ds.Tables[0].Rows[0]["OrderNumber"]);
model.BelongArea = Convert.ToString(ds.Tables[0].Rows[0]["BelongArea"]);
model.RegisterUserName = Convert.ToString(ds.Tables[0].Rows[0]["RegisterUserName"]);
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据,根据ID
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(Model.RTKUserInfo model)
{
string strSql = "update RTKUserInfo set UserName=@UserName, PassWord=@PassWord, Contact=@Contact, ContactPhone=@ContactPhone, ContactEmail=@ContactEmail, ContactQQ=@ContactQQ, CORSCardNum=@CORSCardNum, ReceiverNum=@ReceiverNum, Company=@Company, RegTime=@RegTime, UserType=@UserType where ID = " + model.ID.ToString();
SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName;
SqlParameter PassWord = new SqlParameter("PassWord", SqlDbType.NVarChar); PassWord.Value = model.PassWord;
SqlParameter Contact = new SqlParameter("Contact", SqlDbType.NVarChar); Contact.Value = model.Contact;
SqlParameter ContactPhone = new SqlParameter("ContactPhone", SqlDbType.NVarChar); ContactPhone.Value = model.ContactPhone;
SqlParameter ContactEmail = new SqlParameter("ContactEmail", SqlDbType.NVarChar); ContactEmail.Value = model.ContactEmail;
SqlParameter ContactQQ = new SqlParameter("ContactQQ", SqlDbType.NVarChar); ContactQQ.Value = model.ContactQQ;
SqlParameter CORSCardNum = new SqlParameter("CORSCardNum", SqlDbType.NVarChar); CORSCardNum.Value = model.CORSCardNum;
SqlParameter ReceiverNum = new SqlParameter("ReceiverNum", SqlDbType.NVarChar); ReceiverNum.Value = model.ReceiverNum;
SqlParameter Company = new SqlParameter("Company", SqlDbType.NVarChar); Company.Value = model.Company;
SqlParameter RegTime = new SqlParameter("RegTime", SqlDbType.DateTime); RegTime.Value = model.RegTime;
SqlParameter UserType = new SqlParameter("UserType", SqlDbType.Int); UserType.Value = model.UserType;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, PassWord, Contact, ContactPhone, ContactEmail, ContactQQ, CORSCardNum, ReceiverNum, Company, RegTime, UserType }, connectionString) == 1 ? true : false);
}
/// <summary>
/// 增加一个用户信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Add(Model.RTKUserInfo model)
{
string strSql = "insert into RTKUserInfo( UserName, PassWord, Contact, ContactPhone, ContactEmail, ContactQQ, CORSCardNum, ReceiverNum, Company, RegTime, UserType,OrderNumber,BelongArea,RegisterUserName ) values( @UserName, @PassWord, @Contact, @ContactPhone, @ContactEmail, @ContactQQ, @CORSCardNum, @ReceiverNum, @Company, @RegTime, @UserType,@OrderNumber,@BelongArea,@RegisterUserName )";
SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName;
SqlParameter PassWord = new SqlParameter("PassWord", SqlDbType.NVarChar); PassWord.Value = model.PassWord;
SqlParameter Contact = new SqlParameter("Contact", SqlDbType.NVarChar); Contact.Value = model.Contact;
SqlParameter ContactPhone = new SqlParameter("ContactPhone", SqlDbType.NVarChar); ContactPhone.Value = model.ContactPhone;
SqlParameter ContactEmail = new SqlParameter("ContactEmail", SqlDbType.NVarChar); ContactEmail.Value = model.ContactEmail;
SqlParameter ContactQQ = new SqlParameter("ContactQQ", SqlDbType.NVarChar); ContactQQ.Value = model.ContactQQ;
SqlParameter CORSCardNum = new SqlParameter("CORSCardNum", SqlDbType.NVarChar); CORSCardNum.Value = model.CORSCardNum;
SqlParameter ReceiverNum = new SqlParameter("ReceiverNum", SqlDbType.NVarChar); ReceiverNum.Value = model.ReceiverNum;
SqlParameter Company = new SqlParameter("Company", SqlDbType.NVarChar); Company.Value = model.Company;
SqlParameter RegTime = new SqlParameter("RegTime", SqlDbType.DateTime); RegTime.Value = model.RegTime;
SqlParameter UserType = new SqlParameter("UserType", SqlDbType.Int); UserType.Value = model.UserType;
SqlParameter OrderNumber = new SqlParameter("OrderNumber", SqlDbType.NVarChar); OrderNumber.Value = model.OrderNumber;
SqlParameter BelongArea = new SqlParameter("BelongArea", SqlDbType.NVarChar); BelongArea.Value = model.BelongArea;
SqlParameter RegisterUserName = new SqlParameter("RegisterUserName", SqlDbType.NVarChar); RegisterUserName.Value = model.RegisterUserName;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, PassWord, Contact, ContactPhone, ContactEmail, ContactQQ, CORSCardNum, ReceiverNum, Company, RegTime, UserType, OrderNumber, BelongArea, RegisterUserName }, 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["action"] == "getcode")
{
//string code;
Bitmap bmp = cs.VerifyCodeHelper.CreateVerifyCodeBmp(out code);
Bitmap newbmp = new Bitmap(bmp, 108, 36);
//GetMD5Hash32(code);
// Session["VerifyCode"] = code;
Response.Clear();
Response.ContentType = "image/bmp";
newbmp.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Bmp);
}
if (Request["action"] == "login")
{
string VerifyCode = Request["VerifyCode"];
string username = Request["UserName"];
string password = Request["PassWord"];
//string code = Session["VerifyCode"].ToString();
//验证输入的验证码是否正确
if (VerifyCode.ToLower() != code.ToLower())
{
Response.Write("-1");
Response.End();
}
//Response.Write("<script>alert(\"1\")</script>");
//return;
Model.RegisterUser registeruser = new Model.RegisterUser();
Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo();
string sessionUserName = "";
string tempUserName = "";
string tempPassWord = "";
int tempUserType = 0;
string symbol = "";
try
{
if (DAL.RegisterUser.Exists(username))
{
tempUserName = username;
registeruser = DAL.RegisterUser.GetModel(username);
sessionUserName = registeruser.UserName;
// 求时间差
TimeSpan ts = DateTime.Now - registeruser.LastLoginTime;
//如果登录时间在300分钟外并且为超级管理员 则检索数据库 向过期RTK用户发短信
if (Math.Abs(ts.TotalMinutes) > 300 && registeruser.UserType == 3)
{
DataSet ds = DAL.RTKUserPurview.GetList("1=1");
foreach (DataRow dr in ds.Tables[0].Rows)
{
DateTime dt1 = Convert.ToDateTime(dr["EndTime"].ToString());
DateTime dt2 = DateTime.Now;
TimeSpan deta = DateTime.Now - dt1;
if (Math.Abs(deta.TotalDays) < 30)
{
string SMS = "http://39.108.107.73:8090/sysmonitor/services/monitor/sendmessage.json?key=is8ji3&phone=@phone&message=@message";
string message = "用户您好：RTK账号即将到期，请及时登录CORS管理系统查看!";
SMS = SMS.Replace("@message", message);
SMS = SMS.Replace("@phone", DAL.RTKUserInfo.GetModel(dr["UserName"].ToString()).ContactPhone);
if (cs.HttpHelper.SendSMS(SMS))
{
}
else
{
cs.WebLogger.WriteErroLog("续费提醒短信发送错误"); //输出到文件中
}
}
}
}
//如果登录在半小时内超过三次则无效
if (Math.Abs(ts.TotalMinutes) < 30 && registeruser.TryLoginTimes > 3)
{
//登录频繁则返回
symbol = "-3";
}
else
{
registeruser.TryLoginTimes += 1;
registeruser.LastLoginTime = DateTime.Now;
tempPassWord = AES_Key.AESDecrypt(registeruser.PassWord, registeruser.UserName.PadLeft(16, '0'));
tempUserType = registeruser.UserType;
DAL.RegisterUser.Update(registeruser);
}
}
else if (DAL.RegisterUser.ExistsPhone(username))
{
registeruser = DAL.RegisterUser.GetModelByPhone(username);
tempUserName = registeruser.Phone;
sessionUserName = registeruser.UserName;
// 求时间差
TimeSpan ts = DateTime.Now - registeruser.LastLoginTime;
//如果登录时间在300分钟外并且为超级管理员 则检索数据库 向过期RTK用户发短信
if (Math.Abs(ts.TotalMinutes) > 300 && registeruser.UserType == 3)
{
DataSet ds = DAL.RTKUserPurview.GetList("1=1");
foreach (DataRow dr in ds.Tables[0].Rows)
{
DateTime dt1 = Convert.ToDateTime(dr["EndTime"].ToString());
DateTime dt2 = DateTime.Now;
TimeSpan deta = DateTime.Now - dt1;
if (Math.Abs(deta.TotalDays) < 30)
{
string SMS = "http://39.108.107.73:8090/sysmonitor/services/monitor/sendmessage.json?key=is8ji3&phone=@phone&message=@message";
string message = "用户您好：RTK账号" + dr["UserName"].ToString() + "即将到期，请及时登录CORS管理系统查看!";
SMS = SMS.Replace("@message", message);
SMS = SMS.Replace("@phone", DAL.RTKUserInfo.GetModel(dr["UserName"].ToString()).ContactPhone);
if (cs.HttpHelper.SendSMS(SMS))
{
}
else
{
cs.WebLogger.WriteErroLog("续费提醒短信发送错误"); //输出到文件中
}
}
}
}
//如果登录在半小时内超过三次则无效
if (Math.Abs(ts.TotalMinutes) < 30 && registeruser.TryLoginTimes > 3)
{
//登录频繁则返回
symbol = "-3";
Session["UserType"] = tempUserType;
Session["UserName"] = sessionUserName;
Model.SysLog mSysLog = new Model.SysLog();
mSysLog.LogTime = DateTime.Now;
mSysLog.LogType = 0;
mSysLog.UserName = sessionUserName;
mSysLog.Remark = "登录次数超出限制:";
DAL.SysLog.Add(mSysLog);
Response.End();
}
else
{
registeruser.TryLoginTimes += 1;
registeruser.LastLoginTime = DateTime.Now;
tempPassWord = AES_Key.AESDecrypt(registeruser.PassWord, registeruser.UserName.PadLeft(16, '0'));
tempUserType = registeruser.UserType;
DAL.RegisterUser.Update(registeruser);
}
}
else if (DAL.RTKUserInfo.Exists(username))
{
tempUserName = username;
sessionUserName = username;
rtkUserInfo = DAL.RTKUserInfo.GetModel(username);
tempPassWord = AES_Key.AESDecrypt(rtkUserInfo.PassWord, rtkUserInfo.UserName.PadLeft(16, '0'));
tempUserType = 0;
}
else
{
//用户名不存在则返回
symbol = "-2";
}
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
cs.WebLogger.WriteErroLog(ex.ToString()); //输出到文件中
//Response.Write("<script>alert(\"1\")</script>");
return;
}
if (symbol == "-2")
{
Response.Write("-2");
Response.End();
return;
}
if (symbol == "-3")
{//111
Response.Write("-3");
Response.End();
return;
}
if (getEncryption(tempPassWord, tempUserName, code, true) == password)
{
//StreamReader sr = new StreamReader("D:\\jizhan.txt");
//sr.ReadLine();
//while (!sr.EndOfStream)
//{
// string line = sr.ReadLine();
// string[] mm = Regex.Split(line.Trim(), "\\s+", RegexOptions.IgnoreCase);
// Model.CORSStationInfo cORSStationInfo = new Model.CORSStationInfo();
// cORSStationInfo.StationName = mm[1];
// cORSStationInfo.StationOName = mm[0];
// cORSStationInfo.Lat = Convert.ToDouble(mm[2]);
// cORSStationInfo.Lon = Convert.ToDouble(mm[3]);
// cORSStationInfo.H = Convert.ToDouble(mm[4]);
// cORSStationInfo.Remark = "";
// cORSStationInfo.IP = mm[5];
// cORSStationInfo.Port = "9902";
// cORSStationInfo.TransferType = "TCP/IP";
// cORSStationInfo.IsOK = 1;
// DAL.CORSStationInfo.Add(cORSStationInfo);
// Model.EquipmentInfo eq = new Model.EquipmentInfo();
// eq.StationOName = cORSStationInfo.StationOName;
// eq.StationName = cORSStationInfo.StationName;
// eq.IP = cORSStationInfo.IP;
// eq.Port = cORSStationInfo.Port;
// DAL.EquipmentInfo.Add(eq);
// Model.SiteMonitoring ms = new Model.SiteMonitoring();
// ms.StationOName = cORSStationInfo.StationOName;
// DAL.SiteMonitoring.Add(ms);
//}
//sr.Close();
Session["UserType"] = tempUserType;
Session["UserName"] = sessionUserName;
Model.SysLog mSysLog = new Model.SysLog();
switch (tempUserType)
{
case 0:
Response.Write("<script>location.href = \"/forms/cors_user.aspx\";</script>");
mSysLog.LogTime = DateTime.Now;
mSysLog.LogType = 0;
mSysLog.UserName = sessionUserName;
mSysLog.Remark = "登录成功:";
DAL.SysLog.Add(mSysLog);
Response.End();
break;
case 1:
//registeruser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
registeruser.TryLoginTimes = 0;
DAL.RegisterUser.Update(registeruser);
Response.Write("<script>location.href = \"/forms/cors_user.aspx\";</script>");
mSysLog.LogTime = DateTime.Now;
mSysLog.LogType = 0;
mSysLog.UserName = sessionUserName;
mSysLog.Remark = "登录成功:";
DAL.SysLog.Add(mSysLog);
Response.End();
break;
case 2:
//registeruser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
registeruser.TryLoginTimes = 0;
DAL.RegisterUser.Update(registeruser);
Response.Write("<script>location.href = \"/forms/cors_admin.aspx\";</script>");
mSysLog.LogTime = DateTime.Now;
mSysLog.LogType = 0;
mSysLog.UserName = sessionUserName;
mSysLog.Remark = "登录成功:";
DAL.SysLog.Add(mSysLog);
Response.End();
break;
case 3:
//registeruser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
registeruser.TryLoginTimes = 0;
DAL.RegisterUser.Update(registeruser);
Response.Write("<script>location.href = \"/forms/cors_admin.aspx\";</script>");
mSysLog.LogTime = DateTime.Now;
mSysLog.LogType = 0;
mSysLog.UserName = sessionUserName;
mSysLog.Remark = "管理员登录成功:";
DAL.SysLog.Add(mSysLog);
Response.End();
break;
default:
break;
}
if (Session["UserType"].ToString() == "1")
{
Response.Write("1");
Response.End();
}
if (Session["UserType"].ToString() == "3")
{
Response.Write("3");
Response.End();
}
}
else
{
Model.SysLog mSysLog = new Model.SysLog();
mSysLog.LogTime = DateTime.Now;
mSysLog.LogType = 0;
mSysLog.UserName = sessionUserName;
mSysLog.Remark = "登录密码错误";
DAL.SysLog.Add(mSysLog);
//密码错误则返回
Response.Write("0");
Response.End();
return;
}
//Model.RegisterUser registeruser = new Model.RegisterUser();
// if (DAL.RegisterUser.Exists(username))
// {
// registeruser = DAL.RegisterUser.GetModel(username);
// }
// else
// {
// Response.Write("-2");
// Response.End();
// }
// Response.Write("<script>alert(\"1\")</script>");
// return;
//string ff=GetMD5Hash32(registeruser.PassWord);
//string rff=GetMD5Hash16(registeruser.PassWord);
//string frf = getEncryption(registeruser.PassWord, username, code, true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["action"] != null && Request["key"] != null)
{
//给微信小程序传数据
if (Request["action"] == "GetData" && Request["key"] == "kZJdqQGFq1SntAI/SE9IMQ==")
{
#region 基站信息
DataSet DSStationInfo = DAL.CORSStationInfo.GetList("1=1");
string StationInfo = cs.JSONHelper.DataTableToJSON(DSStationInfo.Tables[0]);
#endregion
#region 务平台信息
//基站状态
int StationCount = DSStationInfo.Tables[0].Rows.Count;
int StationFineCount = DAL.CORSStationInfo.GetList("IsOK=1").Tables[0].Rows.Count;
//获取用户数和固定率
double Rtk = 0;
string strGD = "";
double rtkNum = DAL.RTKUserStatus.GetList("IsOnline =1").Tables[0].Rows.Count;
double rtkGd = DAL.RTKUserStatus.GetList("IsOnline=1 and Remark like '%RTK固定%'").Tables[0].Rows.Count;
if (rtkNum != 0 && rtkGd != 0)
{
double GD = Math.Round(rtkGd / rtkNum * 100, 2);
strGD = GD + "%";
}
//对流层实时值
string pwvValue = "";
string pwvfilepath = Server.MapPath("~\\Product\\PWV_AVERAGE_REALTIME.rtpwv");
if (System.IO.File.Exists(pwvfilepath))
{
StreamReader readrtpwv = new StreamReader(pwvfilepath);
string pwvline = readrtpwv.ReadLine();
string[] pwv = getnewstr(pwvline).Split(' ');
pwvValue = pwv[pwv.Length - 1];
readrtpwv.Close();
readrtpwv.Dispose();
}
//电离层实时值
string tecValue = "";
string ionopath = Server.MapPath("~\\Product\\SLM_AVERAGE_REALTIME.rttec");
if (System.IO.File.Exists(ionopath))
{
StreamReader readrttec = new StreamReader(ionopath);
string tecline = readrttec.ReadLine();
string[] tec = getnewstr(tecline).Split(' ');
tecValue = tec[tec.Length - 2] + ' ' + tec[tec.Length - 1];
readrttec.Close();
}
//电离层预报值
string retecValue = "";
string strpath = Server.MapPath("~/Product/SLM_THREEDY.forecast");
if (File.Exists(strpath))
{
try
{
StreamReader readeriono = new StreamReader(strpath);
List <List <string> > Dataiono = new List <List <string> >();
for (string line = readeriono.ReadLine(); line != null; line = readeriono.ReadLine())
{
string[] ll = getnewstr(line).Split(' ');
List <string> l = new List <string>();
l.Add(ll[0]);
l.Add(ll[1]);
Dataiono.Add(l);
}
readeriono.Close();
for (int i = 0; i < Dataiono.Count; i++)
{
if (int.Parse(Dataiono[i][0]) == DateTime.Now.AddHours(2).Hour)
{
retecValue = Dataiono[i][1] + "TECU";
}
}
}
catch (Exception)
{
}
}
DataSet DSPlatInfo = new DataSet();
DataTable DTPlatInfo = new DataTable();
DTPlatInfo.Columns.Add("Item", typeof(string));
DTPlatInfo.Columns.Add("Value", typeof(string));
DataRow DRPlatInfo1 = DTPlatInfo.NewRow();
DRPlatInfo1["Item"] = "CORS当前服务状态";
DRPlatInfo1["Value"] = "正常";
DTPlatInfo.Rows.Add(DRPlatInfo1);
DataRow DRPlatInfo2 = DTPlatInfo.NewRow();
DRPlatInfo2["Item"] = "CORS基准站运行状态(正常站点/总站点)";
DRPlatInfo2["Value"] = StationFineCount.ToString() + "/" + StationCount.ToString();
DTPlatInfo.Rows.Add(DRPlatInfo2);
DataRow DRPlatInfo3 = DTPlatInfo.NewRow();
DRPlatInfo3["Item"] = "作业用户数";
DRPlatInfo3["Value"] = rtkNum;
DTPlatInfo.Rows.Add(DRPlatInfo3);
DataRow DRPlatInfo4 = DTPlatInfo.NewRow();
DRPlatInfo4["Item"] = "固定率";
DRPlatInfo4["Value"] = strGD;
DTPlatInfo.Rows.Add(DRPlatInfo4);
DataRow DRPlatInfo5 = DTPlatInfo.NewRow();
DRPlatInfo5["Item"] = "对流层实时数值";
DRPlatInfo5["Value"] = pwvValue;
DTPlatInfo.Rows.Add(DRPlatInfo5);
DataRow DRPlatInfo6 = DTPlatInfo.NewRow();
DRPlatInfo6["Item"] = "电离层实时数值";
DRPlatInfo6["Value"] = tecValue;
DTPlatInfo.Rows.Add(DRPlatInfo6);
DataRow DRPlatInfo7 = DTPlatInfo.NewRow();
DRPlatInfo7["Item"] = "电离层预报数值(未来两个小时)";
DRPlatInfo7["Value"] = retecValue;
DTPlatInfo.Rows.Add(DRPlatInfo7);
string PlatInfo = cs.JSONHelper.DataTableToJSON(DTPlatInfo);
#endregion
#region 空间环境产品
#endregion
string result = "{\"StationInfo\":" + StationInfo + ",\"PlatInfo\":" + PlatInfo + "}";
Response.Clear();
Response.Write(result);
Response.End();
}
//给微信小程序登录
if (Request["action"] == "Login" && Request["key"] == "kZJdqQGFq1SntAI/SE9IMQ==")
{
#region 验证用户名和密码
if (Request["UserName"] != null && Request["PassWord"] != null)
{
string UserName = Request["UserName"].ToString();
string PassWord = Request["PassWord"].ToString();
//userinfo-->RTKuser
// DAL.UserInfoWeb duserinfo = new DAL.UserInfoWeb();
Model.RegisterUser muinfo = DAL.RegisterUser.GetModel(UserName);
if (muinfo != null)
{
if (PassWord == AES_Key.AESDecrypt(muinfo.PassWord, muinfo.UserName.PadLeft(16, '0')))
{
Response.Clear();
Response.Write("1");
Response.End();
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
}
}
else
{
Model.RTKUserInfo mrtk = DAL.RTKUserInfo.GetModel2(UserName);
if (mrtk != null)
{
if (PassWord == AES_Key.AESDecrypt(mrtk.PassWord, mrtk.UserName.PadLeft(16, '0')))
{
Response.Clear();
Response.Write("2");
Response.End();
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
}
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
}
}
}
#endregion
}
//微信小程序修改密码
if (Request["action"] == "ChangePass" && Request["key"] == "kZJdqQGFq1SntAI/SE9IMQ==")
{
if (Request["UserName"] != null && Request["PassWord"] != null && Request["NewPassWord"] != null)
{
string UserName = Request["UserName"].ToString();
string PassWord = Request["PassWord"].ToString();
string NewPassWord = Request["NewPassWord"].ToString();
//userinfo-->RTKuser
Model.RegisterUser muinfo = DAL.RegisterUser.GetModel(UserName);
if (muinfo != null)
{
if (PassWord == AES_Key.AESDecrypt(muinfo.PassWord, muinfo.UserName.PadLeft(16, '0')))
{
muinfo.PassWord = AES_Key.AESEncrypt(NewPassWord, UserName.PadLeft(16, '0'));
if (DAL.RegisterUser.Update(muinfo))
{
Response.Clear();
Response.Write("1");
Response.End();
}
else
{
Response.Clear();
Response.Write("-1");
Response.End();
}
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
}
}
else
{
Model.RTKUserInfo mrtk = DAL.RTKUserInfo.GetModel2(UserName);
if (mrtk != null)
{
if (PassWord == AES_Key.AESDecrypt(mrtk.PassWord, mrtk.UserName.PadLeft(16, '0')))
{
mrtk.PassWord = AES_Key.AESEncrypt(NewPassWord, UserName.PadLeft(16, '0'));
if (DAL.RTKUserInfo.Update(mrtk))
{
Response.Clear();
Response.Write("1");
Response.End();
}
else
{
Response.Clear();
Response.Write("-1");
Response.End();
}
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
}
}
else
{
Response.Clear();
Response.Write("-1");
Response.End();
}
}
}
}
}
}
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();
}
}
protected void Page_Load(object sender, EventArgs e)
{
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();
}
#region 加载页面数据
if (Session["UserType"].ToString() != "0")
{
string tempUserName = Session["UserName"].ToString();
Model.RegisterUser registerUser = new Model.RegisterUser();
registerUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
userName.InnerText = registerUser.UserName;
try
{
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(registerUser.CertifiationIndex));
company.InnerText = companyInfo.Company;
Balance.InnerText = companyInfo.Balance.ToString();
}
catch
{
company.InnerText = "未绑定";
}
switch (registerUser.UserType)
{
case 1:
userType.InnerText = "普通用户";
break;
case 2:
userType.InnerText = "协管员用户";
break;
case 3:
userType.InnerText = "超级管理员用户";
break;
default:
break;
}
registerTime.InnerText = registerUser.RegTime.ToString("yyyy-MM-dd HH:mm:ss");
email.InnerText = cs.HideCharShow.StrReplaceByStar(registerUser.Email, 3, 5, "*");
phone.InnerText = cs.HideCharShow.StrReplaceByStar(registerUser.Phone, 4, 7, "*");
switch (registerUser.CertifiationStatus)
{
case 0:
qualificationStatus.InnerText = "尚未认证资质";
qualificationStatus.Style.Add("color", "red");
RechargeBtn.Visible = false;
break;
case 1:
case 3:
qualificationStatus.InnerText = "资质认证中";
qualificationStatus.Style.Add("color", "blue");
RechargeBtn.Visible = false;
break;
case 2:
case 4:
qualificationStatus.InnerText = "资质认证通过";
qualificationStatus.Style.Add("color", "green");
RechargeBtn.Visible = true;
break;
case 5:
qualificationStatus.InnerText = "资质认证失败";
qualificationStatus.Style.Add("color", "red");
RechargeBtn.Visible = false;
break;
case 6:
qualificationStatus.InnerText = "资质变更中";
qualificationStatus.Style.Add("color", "blue");
RechargeBtn.Visible = false;
break;
default:
break;
}
}
else
{
string rr = Session["UserName"].ToString();
Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo();
rtkUserInfo = DAL.RTKUserInfo.GetModel(Session["UserName"].ToString());
userType.InnerText = "RTK作业用户";
registerTime.InnerText = rtkUserInfo.RegTime.ToString("yyyy-MM-dd HH:mm:ss");
email.InnerText = cs.HideCharShow.StrReplaceByStar(rtkUserInfo.ContactEmail, 3, 5, "*");
phone.InnerText = cs.HideCharShow.StrReplaceByStar(rtkUserInfo.ContactPhone, 4, 7, "*");
qualificationStatus.InnerText = "资质认证通过";
company_update.Visible = false;
Model.RegisterUser registerUser = new Model.RegisterUser();
registerUser = DAL.RegisterUser.GetModel(rtkUserInfo.RegisterUserName);
try
{
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(registerUser.CertifiationIndex));
company.InnerText = companyInfo.Company;
}
catch
{
company.InnerText = "未绑定";
}
}
#endregion
}
