/// <summary>
/// 保存，编辑设备
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string connectionString = ConfigurationManager.ConnectionStrings["YZConnString"].ConnectionString;
var dbFactory = new OrmLiteConnectionFactory(connectionString, SqlServerDialect.Provider);
using (var db = dbFactory.Open())
{
if (Request.QueryString["ID"] == null) //添加设备
{
YZ_Device DModel = new YZ_Device();
DModel.DID = Guid.NewGuid().ToString("N");
DModel.DSN = txtDSN.Text;
DModel.DStatus = ddlStatus.SelectedValue;
DModel.HID = ddlHName.SelectedValue;
DModel.DCreated = DateTime.Now;
if (ddlStatus.SelectedValue == "1")
{
DModel.DActivateTime = DateTime.Now;
}
DModel.IsEnable = true;
db.Insert(DModel);
}
else //编辑设备
{
string hid = Request.QueryString["ID"].ToString();
YZ_Device DModel = db.SingleById <YZ_Device>(hid);
if (DModel != null)
{
DModel.DSN = txtDSN.Text;
DModel.DStatus = ddlStatus.SelectedValue;
DModel.HID = ddlHName.SelectedValue;
if (ddlStatus.SelectedValue == "1")
{
DModel.DActivateTime = DateTime.Now;
}
db.Update(DModel);
}
}
}
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>ClosePage(1);</script>");
}
catch (Exception ex)
{
Logger.Log.Error("设备管理：" + ex.Message, ex);
}
}
/// <summary>
/// 根据传递的ID获取设备详细信息
/// </summary>
public void BindModel()
{
try
{
if (Request.QueryString["ID"] != null)
{
string connectionString = ConfigurationManager.ConnectionStrings["YZConnString"].ConnectionString;
var dbFactory = new OrmLiteConnectionFactory(connectionString, SqlServerDialect.Provider);
using (var db = dbFactory.Open())
{
string hid = Request.QueryString["ID"].ToString();
YZ_Device DModel = db.SingleById <YZ_Device>(hid);
txtDSN.Text = DModel.DSN;
ddlStatus.SelectedValue = DModel.DStatus;
ddlHName.SelectedValue = DModel.HID;
}
if (Request.QueryString["IsEdit"] != null && Request.QueryString["IsEdit"] == "2")
{
txtDSN.Enabled = false;
}
if (Request.QueryString["IsEdit"] != null && Request.QueryString["IsEdit"] == "3")
{
txtDSN.Enabled = false;
ddlStatus.Enabled = false;
ddlHName.Enabled = false;
btnSave.Visible = false;
}
}
}
catch (Exception ex)
{
Logger.Log.Error("编辑设备：" + ex.Message, ex);
}
}
protected void lbtnDel_Command(object sender, CommandEventArgs e)
{
try
{
string connectionString = ConfigurationManager.ConnectionStrings["YZConnString"].ConnectionString;
var dbFactory = new OrmLiteConnectionFactory(connectionString, SqlServerDialect.Provider);
using (var db = dbFactory.Open())
{
YZ_Device faq = db.SingleById <YZ_Device>(e.CommandName);
if (faq != null)
{
faq.IsEnable = false;
db.Update(faq);
BindRepeater();
RemoveAllCache("_LoginInit");
}
}
}
catch (Exception ex)
{
Logger.Log.Error(ex.Message, ex);
}
}