/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Add(Model.DeUserInfo model) { string strSql = "insert into DeUserInfo( UserName,UserPwd,OrderNumber) values(@UserName,@UserPwd,@OrderNumber)"; SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName; SqlParameter UserPwd = new SqlParameter("UserPwd", SqlDbType.NVarChar); UserPwd.Value = model.UserPwd; SqlParameter OrderNumber = new SqlParameter("OrderNumber", SqlDbType.NVarChar); OrderNumber.Value = model.OrderNumber; return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, UserPwd, OrderNumber }, connectionString) == 1 ? true : false); }
/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.DeUserInfo GetModel(string UserName) { string strSql = "select * from DeUserInfo where UserName = '******'"; Model.DeUserInfo model = new Model.DeUserInfo(); 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.UserName = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]); model.UserPwd = Convert.ToString(ds.Tables[0].Rows[0]["UserPwd"]); model.OrderNumber = Convert.ToString(ds.Tables[0].Rows[0]["OrderNumber"]); return(model); } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserName"] == null || Session["UserType"] == null) { Response.Write("<script>alert(\"请登录\");parent.window.location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>"); Response.End(); } DataSet dsRoamArea = DAL.RoamArea.GetList("1=1"); foreach (DataRow dr in dsRoamArea.Tables[0].Rows) { Select2.Items.Add(dr["AreaName"].ToString()); Select4.Items.Add(dr["AreaName"].ToString()); } } if (Request["action"] == "check") { string username = Request["data"].ToString(); DAL.RegisterUser du = new DAL.RegisterUser(); if (DAL.RTKUserInfo.GetModel(username) == null && DAL.RegisterUser.GetModel(username) == null && DAL.DeUserInfo.GetModel(username) == null) { Response.Clear(); Response.Write("1"); Response.End(); } else { Response.Clear(); Response.Write("0"); Response.End(); } } //Session["UserName"] = "******"; if (Request["action"] == "order") { Model.OrderList orderlist = new Model.OrderList(); orderlist.UserName = Session["UserName"].ToString(); Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName); orderlist.WorkArea = registerUser.BelongArea; orderlist.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff"); //将订单号存储在session里面用于整个订单的操作流程。 Session["OrderNumber"] = orderlist.OrderNumber; orderlist.SubmitTime = DateTime.Now; orderlist.AccountNum = Convert.ToInt32(Request["applynum"]); orderlist.ServiceDuration = Request["time"].ToString(); orderlist.ServerType = Request["servertype"].ToString(); Model.RegisterUser RegisterUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString()); Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(RegisterUser.CertifiationIndex)); orderlist.company = companyInfo.Company; orderlist.OrdeType = 0; orderlist.Price = Request["price"].ToString(); if (Select1.Value == "是") { orderlist.RoamID = this.Select2.Value;//保存的漫游ID } else { orderlist.RoamID = ""; } if (Checkbox1.Checked == true) { orderlist.ElevationEnable = 1; } else { orderlist.ElevationEnable = 0; } string[] otherserver = Request["otherserver"].ToString().Split(','); if (Array.IndexOf(otherserver, "CoorTransEnable") != -1) { orderlist.CoorSystemEnable = 1; } if (Array.IndexOf(otherserver, "HeightTransEnable") != -1) { orderlist.HeightTransEnable = 1; } if (Array.IndexOf(otherserver, "SHPTransEnable") != -1) { orderlist.SHPTransEnable = 1; } if (Array.IndexOf(otherserver, "ObsQualityEnable") != -1) { orderlist.ObsQualityEnable = 1; } if (DAL.OrderList.Add(orderlist)) { Response.Write(orderlist.OrderNumber); //Model.SysLog syslog = new Model.SysLog(); //syslog.LogTime = DateTime.Now; //syslog.LogType = 5; //syslog.Remark = "申请的服务订单待处理"; //syslog.UserName = orderlist.UserName; //DAL.SysLog.Add(syslog); Response.End(); } else { Response.Write("200"); Response.End(); } } if (Request["action"] == "order1") { Model.OrderList orderlist = new Model.OrderList(); orderlist.UserName = Session["UserName"].ToString(); Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName); orderlist.WorkArea = registerUser.BelongArea; orderlist.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff"); //将订单号存储在session里面用于整个订单的操作流程。 Session["OrderNumber"] = orderlist.OrderNumber; orderlist.SubmitTime = DateTime.Now; orderlist.AccountNum = Convert.ToInt32(Request["applynum1"]); orderlist.ServiceDuration = Request["time1"].ToString(); orderlist.ServerType = Request["servertype1"].ToString(); Model.RegisterUser RegisterUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString()); Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(RegisterUser.CertifiationIndex)); orderlist.company = companyInfo.Company; orderlist.OrdeType = 3; orderlist.Price = Request["price1"].ToString(); if (Select3.Value == "是") { orderlist.RoamID = this.Select4.Value;//保存的漫游ID } else { orderlist.RoamID = ""; } if (Checkbox2.Checked == true) { orderlist.ElevationEnable = 1; } else { orderlist.ElevationEnable = 0; } if (Checkbox3.Checked == true) { orderlist.ElevationEnable = 1; } else { orderlist.ElevationEnable = 0; } string[] otherserver = Request["otherserver1"].ToString().Split(','); if (Array.IndexOf(otherserver, "CoorTransEnable") != -1) { orderlist.CoorSystemEnable = 1; } if (Array.IndexOf(otherserver, "HeightTransEnable") != -1) { orderlist.HeightTransEnable = 1; } if (Array.IndexOf(otherserver, "SHPTransEnable") != -1) { orderlist.SHPTransEnable = 1; } if (Array.IndexOf(otherserver, "ObsQualityEnable") != -1) { orderlist.ObsQualityEnable = 1; } string[] sys = Request["username1"].ToString().Split(','); if (DAL.OrderList.Add(orderlist)) { foreach (string s in sys) { if (s != null || s != "") { Model.DeUserInfo deUserInfo = new Model.DeUserInfo(); deUserInfo.UserName = s; deUserInfo.UserPwd = AES_Key.AESEncrypt(s, s.PadLeft(16, '0')); deUserInfo.OrderNumber = orderlist.OrderNumber; DAL.DeUserInfo.Add(deUserInfo); } else { Response.Write("<script >alert('用户名不能为空!');</script>"); } } Response.Write(orderlist.OrderNumber); //Model.SysLog syslog = new Model.SysLog(); //syslog.LogTime = DateTime.Now; //syslog.LogType = 5; //syslog.Remark = "申请的服务订单待处理"; //syslog.UserName = orderlist.UserName; //DAL.SysLog.Add(syslog); Response.End(); } else { Response.Write("200"); Response.End(); } } }