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