/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.SMT_SUPER_PWD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SMT_SUPER_PWD set "); strSql.Append("SUPER_PWD=@SUPER_PWD,"); strSql.Append("DOOR_ID=@DOOR_ID"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@SUPER_PWD", SqlDbType.NVarChar, 10), new SqlParameter("@DOOR_ID", SqlDbType.Decimal, 9), new SqlParameter("@ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.SUPER_PWD; parameters[1].Value = model.DOOR_ID; parameters[2].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Maticsoft.Model.SMT_SUPER_PWD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SMT_SUPER_PWD("); strSql.Append("SUPER_PWD,DOOR_ID)"); strSql.Append(" values ("); strSql.Append("@SUPER_PWD,@DOOR_ID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SUPER_PWD", SqlDbType.NVarChar, 10), new SqlParameter("@DOOR_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.SUPER_PWD; parameters[1].Value = model.DOOR_ID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
private void btnAdd_Click(object sender, EventArgs e) { string pwd = this.tbPassword.Text.Trim(); if (pwd == "") { WinInfoHelper.ShowInfoWindow(this, "密码为空!"); return; } var doors = doorTree.Tree.GetNodeList(true, typeof(Maticsoft.Model.SMT_DOOR_INFO)); if (doors.Count == 0) { WinInfoHelper.ShowInfoWindow(this, "未选择任何门禁!"); return; } List <decimal> doorIds = new List <decimal>(); foreach (var item in doors) { doorIds.Add(((Maticsoft.Model.SMT_DOOR_INFO)item.Tag).ID); } CtrlWaiting ctrlWaiting = new CtrlWaiting(() => { try { Maticsoft.BLL.SMT_SUPER_PWD pwdBll = new Maticsoft.BLL.SMT_SUPER_PWD(); List <Maticsoft.Model.SMT_SUPER_PWD> models = pwdBll.GetModelList("SUPER_PWD='" + pwd + "'"); List <Maticsoft.Model.SMT_SUPER_PWD> addmodels = new List <Maticsoft.Model.SMT_SUPER_PWD>(); foreach (var item in doorIds) { if (!models.Exists(m => m.DOOR_ID == item)) { Maticsoft.Model.SMT_SUPER_PWD model = new Maticsoft.Model.SMT_SUPER_PWD() { DOOR_ID = item, SUPER_PWD = pwd }; model.ID = pwdBll.Add(model); addmodels.Add(model); SmtLog.InfoFormat("配置", "添加超级通行密码:门禁Id={0}", item); } } if (addmodels.Count > 0) { RefreshDatas(); } } catch (Exception ex) { WinInfoHelper.ShowInfoWindow(this, "添加超级通行密码异常!" + ex.Message); log.Error("添加超级通行密码异常:", ex); } }); ctrlWaiting.Show(this); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.SMT_SUPER_PWD DataRowToModel(DataRow row) { Maticsoft.Model.SMT_SUPER_PWD model = new Maticsoft.Model.SMT_SUPER_PWD(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = decimal.Parse(row["ID"].ToString()); } if (row["SUPER_PWD"] != null) { model.SUPER_PWD = row["SUPER_PWD"].ToString(); } if (row["DOOR_ID"] != null && row["DOOR_ID"].ToString() != "") { model.DOOR_ID = decimal.Parse(row["DOOR_ID"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.SMT_SUPER_PWD GetModel(decimal ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,SUPER_PWD,DOOR_ID from SMT_SUPER_PWD "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Decimal) }; parameters[0].Value = ID; Maticsoft.Model.SMT_SUPER_PWD model = new Maticsoft.Model.SMT_SUPER_PWD(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }