private void AddEquip() { var cont = Request["equip"].ToString(); Content content = CORSV2.cs.JSONHelper.JSONToObject <Content>(cont); if (DAL.DataCenter.Exists(content.SerialNumber, 1)) { Response.Clear(); Response.Write("0"); Response.End(); } else { Model.DataCenter md = new Model.DataCenter(); md.DeviceType = content.DeviceType; md.Type = content.dType; md.SerialNumber = content.SerialNumber; md.IP = content.IP; md.Port = content.Port; md.Business = content.Business; bool r = DAL.DataCenter.Add(md); if (r) { Response.Clear(); Response.Write("1"); Response.End(); } else { Response.Clear(); Response.Write("2"); Response.End(); } } }
private void DeleteEquips() { 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.DataCenter md = DAL.DataCenter.GetModel(ids[m]); bool resultd = DAL.DataCenter.Delete(md.SerialNumber); Model.SysLog mSysLog = new Model.SysLog(); mSysLog.LogTime = DateTime.Now; mSysLog.LogType = 0; mSysLog.UserName = Session["UserName"].ToString(); mSysLog.Remark = "管理员删除了设备:" + md.DeviceType + "序列号为:" + md.SerialNumber; DAL.SysLog.Add(mSysLog); } Response.Clear(); Response.Write("1"); Response.End(); } catch (Exception) { } }
public static Model.DataCenter GetModel(int ID) { string strSql = "select * from DataCenter where ID = '" + ID + "'"; Model.DataCenter model = new Model.DataCenter(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.SerialNumber = Convert.ToString(ds.Tables[0].Rows[0]["SerialNumber"]); model.Business = Convert.ToString(ds.Tables[0].Rows[0]["Business"]); model.DeviceType = Convert.ToString(ds.Tables[0].Rows[0]["DeviceType"]); model.Gateway = Convert.ToString(ds.Tables[0].Rows[0]["Gateway"]); model.FirstUseDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["FirstUseDate"]); model.IP = Convert.ToString(ds.Tables[0].Rows[0]["IP"]); model.LoginName = Convert.ToString(ds.Tables[0].Rows[0]["LoginName"]); model.MaintenanceContent = Convert.ToString(ds.Tables[0].Rows[0]["MaintenanceContent"]); model.MaintenancePerson = Convert.ToString(ds.Tables[0].Rows[0]["MaintenancePerson"]); model.MaintenanceTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["MaintenanceTime"]); model.Password = Convert.ToString(ds.Tables[0].Rows[0]["Password"]); model.Port = Convert.ToString(ds.Tables[0].Rows[0]["Port"]); model.SubnetMask = Convert.ToString(ds.Tables[0].Rows[0]["SubnetMask"]); model.Type = Convert.ToString(ds.Tables[0].Rows[0]["Type"]); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据,根据ID /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Update(Model.DataCenter model) { string strSql = "update DataCenter set DeviceType=@DeviceType,Type=@Type,SerialNumber=@SerialNumber,FirstUseDate=@FirstUseDate,LoginName=@LoginName,Password=@Password,Business=@Business,IP=@IP,SubnetMask=@SubnetMask,Gateway=@Gateway,Port=@Port,MaintenanceTime=@MaintenanceTime,MaintenanceContent=@MaintenanceContent,MaintenancePerson=@MaintenancePerson where ID = " + model.ID.ToString(); SqlParameter DeviceType = new SqlParameter("DeviceType", SqlDbType.NVarChar); DeviceType.Value = model.DeviceType; SqlParameter Type = new SqlParameter("Type", SqlDbType.NVarChar); Type.Value = model.Type; SqlParameter SerialNumber = new SqlParameter("SerialNumber", SqlDbType.NVarChar); SerialNumber.Value = model.SerialNumber; SqlParameter FirstUseDate = new SqlParameter("FirstUseDate", SqlDbType.DateTime); FirstUseDate.Value = model.FirstUseDate; SqlParameter LoginName = new SqlParameter("LoginName", SqlDbType.NVarChar); LoginName.Value = model.LoginName; SqlParameter Password = new SqlParameter("Password", SqlDbType.NVarChar); Password.Value = model.Password; SqlParameter Business = new SqlParameter("Business", SqlDbType.NVarChar); Business.Value = model.Business; SqlParameter IP = new SqlParameter("IP", SqlDbType.NVarChar); IP.Value = model.IP; SqlParameter SubnetMask = new SqlParameter("SubnetMask", SqlDbType.NVarChar); SubnetMask.Value = model.SubnetMask; SqlParameter Gateway = new SqlParameter("Gateway", SqlDbType.NVarChar); Gateway.Value = model.Gateway; SqlParameter Port = new SqlParameter("Port", SqlDbType.NVarChar); Port.Value = model.Port; SqlParameter MaintenanceTime = new SqlParameter("MaintenanceTime", SqlDbType.DateTime); MaintenanceTime.Value = model.MaintenanceTime; SqlParameter MaintenanceContent = new SqlParameter("MaintenanceContent", SqlDbType.NVarChar); MaintenanceContent.Value = model.MaintenanceContent; SqlParameter MaintenancePerson = new SqlParameter("MaintenancePerson", SqlDbType.NVarChar); MaintenancePerson.Value = model.MaintenancePerson; return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { DeviceType, Type, SerialNumber, FirstUseDate, LoginName, Password, Business, IP, SubnetMask, Gateway, Port, MaintenanceTime, MaintenanceContent, MaintenancePerson }, connectionString) == 1 ? true : false); }
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) { string SerialNum = Request["Serial"].ToString(); Model.DataCenter md = DAL.DataCenter.GetModel(SerialNum); IDS.Value = md.ID.ToString();; DeviceType.Value = md.DeviceType; dType.Value = md.Type; SerialNumber.Value = md.SerialNumber; FirstUseDate.Value = md.FirstUseDate.ToString(); LoginName.Value = md.LoginName; if (md.Password != "" && md.Password != null) { Password.Value = AES_Key.AESDecrypt(md.Password, md.LoginName.PadLeft(16, '0')); } IP.Value = md.IP; Port.Value = md.Port; SubnetMask.Value = md.SubnetMask; Gateway.Value = md.Gateway; Business.Value = md.Business; MaintenancePerson.Value = md.MaintenancePerson; MaintenanceTime.Value = md.MaintenanceTime.ToString(); MaintenanceContent.Value = md.MaintenanceContent; } else { if (Request["action"] == "save") { Model.DataCenter MD = DAL.DataCenter.GetModel(int.Parse(Request.Form["IDS"].ToString().Trim())); #region 对修改信息进行对比 Model.EquipReviceRecord MERR = new Model.EquipReviceRecord(); bool IsRevice = false; MERR.Contents = "设备类型为" + MD.DeviceType + "的设备信息发生了修改:"; #endregion if (Request.Form["SerialNumber"].ToString().Trim() == MD.SerialNumber) { if (MD.DeviceType != Request.Form["DeviceType"].ToString().Trim()) { IsRevice = true; MERR.Contents += "设备类型;"; } if (MD.Type != Request.Form["dType"].ToString().Trim()) { IsRevice = true; MERR.Contents += "型号;"; } if (MD.FirstUseDate != DateTime.Parse(Request.Form["FirstUseDate"].ToString())) { IsRevice = true; MERR.Contents += "初次使用日期;"; } if (MD.Business != Request.Form["Business"].ToString().Trim()) { IsRevice = true; MERR.Contents += "业务用途;"; } if (MD.IP != Request.Form["IP"].ToString().Trim()) { IsRevice = true; MERR.Contents += "IP地址;"; } if (MD.Port != Request.Form["Port"].ToString().Trim()) { IsRevice = true; MERR.Contents += "端口;"; } if (MD.SubnetMask != Request.Form["SubnetMask"].ToString().Trim()) { IsRevice = true; MERR.Contents += "子网掩码;"; } if (MD.Gateway != Request.Form["Gateway"].ToString().Trim()) { IsRevice = true; MERR.Contents += "网关;"; } if (MD.LoginName != Request.Form["LoginName"].ToString().Trim()) { IsRevice = true; MERR.Contents += "登陆名;"; } if (MD.Password != AES_Key.AESEncrypt(Request.Form["Password"].ToString().Trim(), MD.LoginName.PadLeft(16, '0'))) { IsRevice = true; MERR.Contents += "登陆密码;"; } if (MD.MaintenancePerson != Request.Form["MaintenancePerson"].ToString().Trim()) { IsRevice = true; MERR.Contents += "设备维护人员;"; } if (MD.MaintenanceTime != DateTime.Parse(Request.Form["MaintenanceTime"].ToString())) { IsRevice = true; MERR.Contents += "设备维护时间;"; } if (MD.MaintenanceContent != Request.Form["MaintenanceContent"].ToString().Trim()) { IsRevice = true; MERR.Contents += "设备维护内容;"; } MD.DeviceType = Request.Form["DeviceType"].ToString().Trim(); MD.Gateway = Request.Form["Gateway"].ToString().Trim(); MD.FirstUseDate = DateTime.Parse(Request.Form["FirstUseDate"].ToString()); MD.IP = Request.Form["IP"].ToString().Trim(); MD.LoginName = Request.Form["LoginName"].ToString().Trim(); MD.MaintenanceContent = Request.Form["MaintenanceContent"].ToString().Trim(); MD.MaintenancePerson = Request.Form["MaintenancePerson"].ToString().Trim(); MD.MaintenanceTime = DateTime.Parse(Request.Form["MaintenanceTime"].ToString()); MD.Password = AES_Key.AESEncrypt(Request.Form["Password"].ToString().Trim(), MD.LoginName.PadLeft(16, '0')); MD.Port = Request.Form["Port"].ToString().Trim(); MD.Business = Request.Form["Business"].ToString().Trim(); MD.SerialNumber = Request.Form["SerialNumber"].ToString().Trim(); MD.SubnetMask = Request.Form["SubnetMask"].ToString().Trim(); bool result = DAL.DataCenter.Update(MD); if (result) { if (IsRevice) { MERR.ReviceID = MD.ID.ToString(); MERR.RevicePerson = Session["UserName"].ToString(); MERR.ReviceTime = DateTime.Now; MERR.Information = "数据中心设备"; DAL.EquipReviceRecord.Add(MERR); } Response.Clear(); Response.Write("1"); Response.End(); } else { Response.Clear(); Response.Write("0"); Response.End(); } } else { if (DAL.DataCenter.Exists(Request.Form["SerialNumber"].ToString().Trim(), 1)) { Response.Clear(); Response.Write("2"); Response.End(); } else { if (MD.DeviceType != Request.Form["DeviceType"].ToString().Trim()) { IsRevice = true; MERR.Contents += "设备类型;"; } if (MD.Type != Request.Form["dType"].ToString().Trim()) { IsRevice = true; MERR.Contents += "型号;"; } if (MD.FirstUseDate != DateTime.Parse(Request.Form["FirstUseDate"].ToString())) { IsRevice = true; MERR.Contents += "初次使用日期;"; } if (MD.Business != Request.Form["Business"].ToString().Trim()) { IsRevice = true; MERR.Contents += "业务用途;"; } if (MD.IP != Request.Form["IP"].ToString().Trim()) { IsRevice = true; MERR.Contents += "IP地址;"; } if (MD.Port != Request.Form["Port"].ToString().Trim()) { IsRevice = true; MERR.Contents += "端口;"; } if (MD.SubnetMask != Request.Form["SubnetMask"].ToString().Trim()) { IsRevice = true; MERR.Contents += "子网掩码;"; } if (MD.Gateway != Request.Form["Gateway"].ToString().Trim()) { IsRevice = true; MERR.Contents += "网关;"; } if (MD.LoginName != Request.Form["LoginName"].ToString().Trim()) { IsRevice = true; MERR.Contents += "登陆名;"; } if (MD.Password != AES_Key.AESEncrypt(Request.Form["Password"].ToString().Trim(), MD.LoginName.PadLeft(16, '0'))) { IsRevice = true; MERR.Contents += "登陆密码;"; } if (MD.MaintenancePerson != Request.Form["MaintenancePerson"].ToString().Trim()) { IsRevice = true; MERR.Contents += "设备维护人员;"; } if (MD.MaintenanceTime != DateTime.Parse(Request.Form["MaintenanceTime"].ToString())) { IsRevice = true; MERR.Contents += "设备维护时间;"; } if (MD.MaintenanceContent != Request.Form["MaintenanceContent"].ToString().Trim()) { IsRevice = true; MERR.Contents += "设备维护内容;"; } MD.DeviceType = Request.Form["DeviceType"].ToString().Trim(); MD.Gateway = Request.Form["Gateway"].ToString().Trim(); MD.FirstUseDate = DateTime.Parse(Request.Form["FirstUseDate"].ToString()); MD.IP = Request.Form["IP"].ToString().Trim(); MD.LoginName = Request.Form["LoginName"].ToString().Trim(); MD.MaintenanceContent = Request.Form["MaintenanceContent"].ToString().Trim(); MD.MaintenancePerson = Request.Form["MaintenancePerson"].ToString().Trim(); MD.MaintenanceTime = DateTime.Parse(Request.Form["MaintenanceTime"].ToString()); MD.Password = AES_Key.AESEncrypt(Request.Form["Password"].ToString().Trim(), MD.LoginName.PadLeft(16, '0')); MD.Port = Request.Form["Port"].ToString().Trim(); MD.Business = Request.Form["Business"].ToString().Trim(); MD.SerialNumber = Request.Form["SerialNumber"].ToString().Trim(); MD.SubnetMask = Request.Form["SubnetMask"].ToString().Trim(); bool result = DAL.DataCenter.Update(MD); if (result) { if (IsRevice) { MERR.ReviceID = MD.ID.ToString(); MERR.RevicePerson = Session["UserName"].ToString(); MERR.ReviceTime = DateTime.Now; MERR.Information = "数据中心设备"; DAL.EquipReviceRecord.Add(MERR); } Response.Clear(); Response.Write("1"); Response.End(); } else { Response.Clear(); Response.Write("0"); Response.End(); } } } } } }