/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.RoamingAreaManagement GetModel(string GroupName) { string strSql = "select * from RoamingAreaManagement where GroupName = '" + GroupName + "'"; Model.RoamingAreaManagement model = new Model.RoamingAreaManagement(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.GroupName = GroupName; if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); model.GroupName = Convert.ToString(ds.Tables[0].Rows[0]["GroupName"]); model.Remark = Convert.ToString(ds.Tables[0].Rows[0]["Remark"]); model.GroupRange = Convert.ToString(ds.Tables[0].Rows[0]["GroupRange"]); model.InsertTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["InsertTime"]); return(model); } else { return(null); } }
/// <summary> /// 增加一个分组信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Add(Model.RoamingAreaManagement model) { string strSql = "insert into RoamingAreaManagement(GroupName, Remark, GroupRange, InsertTime) values(@GroupName, @Remark, @GroupRange, @InsertTime)"; SqlParameter GroupName = new SqlParameter("GroupName", SqlDbType.NVarChar); GroupName.Value = model.GroupName; SqlParameter Remark = new SqlParameter("Remark", SqlDbType.NVarChar); Remark.Value = model.Remark; SqlParameter GroupRange = new SqlParameter("GroupRange", SqlDbType.NVarChar); GroupRange.Value = model.GroupRange; SqlParameter InsertTime = new SqlParameter("InsertTime", SqlDbType.NVarChar); InsertTime.Value = model.InsertTime; return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { GroupName, Remark, GroupRange, InsertTime }, connectionString) == 1 ? true : false); }
/// <summary> /// 更新一条数据,根据ID /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Update(Model.RoamingAreaManagement model) { string strSql = "update RoamingAreaManagement set GroupName=@GroupName, Remark=@Remark, GroupRange=@GroupRange, InsertTime=@InsertTime where ID = " + model.ID.ToString(); SqlParameter GroupName = new SqlParameter("GroupName", SqlDbType.NVarChar); GroupName.Value = model.GroupName; SqlParameter Remark = new SqlParameter("Remark", SqlDbType.NVarChar); Remark.Value = model.Remark; SqlParameter GroupRange = new SqlParameter("GroupRange", SqlDbType.NVarChar); GroupRange.Value = model.GroupRange; SqlParameter InsertTime = new SqlParameter("InsertTime", SqlDbType.NVarChar); InsertTime.Value = model.InsertTime; //WebLogger.WriteErroLog(strSql); return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { GroupName, Remark, GroupRange, InsertTime }, connectionString) == 1 ? true : false); }
public void save() { Model.RoamingAreaManagement management = DAL.RoamingAreaManagement.GetModel(Session["GroupName"].ToString()); management.GroupName = GroupName.Value; management.Remark = Remark.Value; management.GroupRange = GroupRange.Value; DAL.RoamingAreaManagement.Update(management); Response.Clear(); Response.Write("1"); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["GroupName"] != null) { Session["GroupName"] = Request["GroupName"].ToString(); Model.RoamingAreaManagement RoamingArea = DAL.RoamingAreaManagement.GetModel(Session["GroupName"].ToString()); GroupName.Value = RoamingArea.GroupName; Remark.Value = RoamingArea.Remark.ToString(); GroupRange.Value = RoamingArea.GroupRange.ToString(); } } if (Request["action"] != null && Request["action"] == "save") { save(); } }
private void AddStas() { Model.RoamingAreaManagement roamingArea = new Model.RoamingAreaManagement(); roamingArea.GroupName = Request.Form["GroupName"].ToString(); roamingArea.Remark = Request.Form["Remark"].ToString(); roamingArea.GroupRange = Request.Form["GroupRange"].ToString(); roamingArea.InsertTime = DateTime.Now; if (DAL.RoamingAreaManagement.Exists(roamingArea.GroupName)) { Response.Clear(); Response.Write("0"); Response.End(); } else { try { DAL.RoamingAreaManagement.Add(roamingArea); Response.Clear(); Response.Write("1"); Response.End(); } catch (Exception) { } Model.SysLog mSysLog = new Model.SysLog(); mSysLog.LogTime = DateTime.Now; mSysLog.LogType = 0; mSysLog.UserName = Session["UserName"].ToString(); mSysLog.Remark = "管理员添加分组信息:" + roamingArea.GroupName + "的信息"; DAL.SysLog.Add(mSysLog); } }