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