public static Model.StationEquip GetModel(int ID)
{
string strSql = "select * from StationEquip where ID = '" + ID + "'";
Model.StationEquip model = new Model.StationEquip();
DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString);
model.ID = ID;
if (ds.Tables[0].Rows.Count > 0)
{
//model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);
model.MachineName = Convert.ToString(ds.Tables[0].Rows[0]["MachineName"]);
model.SerialNumber = Convert.ToString(ds.Tables[0].Rows[0]["SerialNumber"]);
model.InstallationDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["InstallationDate"]);
model.Models = Convert.ToString(ds.Tables[0].Rows[0]["Models"]);
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据,根据ID
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(Model.StationEquip model)
{
string strSql = "update StationEquip set MachineName=@MachineName, Models=@Models, InstallationDate=@InstallationDate, SerialNumber=@SerialNumber where ID = " + model.ID.ToString();
SqlParameter Models = new SqlParameter("Models", SqlDbType.NVarChar); Models.Value = model.Models;
SqlParameter MachineName = new SqlParameter("MachineName", SqlDbType.NVarChar); MachineName.Value = model.MachineName;
SqlParameter InstallationDate = new SqlParameter("InstallationDate", SqlDbType.DateTime); InstallationDate.Value = model.InstallationDate;
SqlParameter SerialNumber = new SqlParameter("SerialNumber", SqlDbType.NVarChar); SerialNumber.Value = model.SerialNumber;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { MachineName, Models, InstallationDate, SerialNumber }, connectionString) == 1 ? true : false);
}
/// <summary>
/// 增加一个设备
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Add(Model.StationEquip model)
{
string strSql = "insert into StationEquip(MachineName,Models,InstallationDate,SerialNumber) values(@MachineName,@Models,@InstallationDate,@SerialNumber)";
SqlParameter Models = new SqlParameter("Models", SqlDbType.NVarChar); Models.Value = model.Models;
SqlParameter MachineName = new SqlParameter("MachineName", SqlDbType.NVarChar); MachineName.Value = model.MachineName;
SqlParameter InstallationDate = new SqlParameter("InstallationDate", SqlDbType.DateTime); InstallationDate.Value = model.InstallationDate;
SqlParameter SerialNumber = new SqlParameter("SerialNumber", SqlDbType.NVarChar); SerialNumber.Value = model.SerialNumber;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { MachineName, Models, InstallationDate, SerialNumber }, connectionString) == 1 ? true : false);
}
private void DeleteEquip()
{
int[] ids;
string a = Request["id[]"];
string[] temp = a.Split(',');
ids = new int[temp.Length];
try
{
for (int m = 0; m < temp.Length; m++)
{
ids[m] = Convert.ToInt32(temp[m]);
Model.StationEquip mi = DAL.StationEquip.GetModel(ids[m]);
DataSet ds = DAL.EquipmentInfo.GetList("EquipID like '%" + ids[m] + ";%'");
string name = mi.MachineName;
bool result = DAL.StationEquip.Delete(ids[m]);
if (result)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
Model.EquipmentInfo MII = DAL.EquipmentInfo.GetModel(int.Parse(dr["ID"].ToString()));
if (MII != null)
{
string eid = MII.EquipID.Replace(ids[m] + ";", "").Trim();
MII.EquipID = eid;
DAL.EquipmentInfo.Update(MII);
}
}
Model.SysLog mSysLog = new Model.SysLog();
mSysLog.LogTime = DateTime.Now;
mSysLog.LogType = 0;
mSysLog.UserName = Session["UserName"].ToString();
mSysLog.Remark = "管理员删除了基站设备：" + name;
DAL.SysLog.Add(mSysLog);
}
}
Response.Clear();
Response.Write("1");
Response.End();
}
catch (Exception)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] == null)
{
Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/Index.aspx\";</script>");
Response.End();
}
if (Session["UserType"] == null || (Convert.ToInt32(Session["UserType"]) != 2 && Convert.ToInt32(Session["UserType"]) != 3))
{
Response.Write("<script>alert(\"登录账户类型有误\");location.href = location.origin+\"/forms/Index.aspx\";</script>");
Response.End();
}
if (!IsPostBack)
{
if (Request["ID"] != null)
{
IDD = int.Parse(Request["ID"].ToString());
}
}
else
{
if (Request["action"] == "save")
{
Model.StationEquip se = new Model.StationEquip();
string time = Request.Form["InstallationDate"].ToString();
string dtime = DateTime.Now.ToString();
se.InstallationDate = DateTime.Parse(dtime);
se.MachineName = Request.Form["MachineName"].ToString();
se.Models = Request.Form["Models"].ToString();
se.SerialNumber = Request.Form["SerialNumber"].ToString();
bool result = DAL.StationEquip.Add(se);
if (result)
{
Model.EquipmentInfo MII = DAL.EquipmentInfo.GetModel(IDD);
DataSet ds = DAL.StationEquip.GetList("InstallationDate='" + dtime + "'");
MII.EquipID += ds.Tables[0].Rows[0]["ID"].ToString() + ";";
se.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
DAL.EquipmentInfo.Update(MII);
try
{
se.InstallationDate = DateTime.Parse(time);
}
catch (Exception)
{
}
DAL.StationEquip.Update(se);
Response.Clear();
Response.Write("1");
Response.End();
return;
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
}
}
}
}
