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