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