/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool ModifyPower(PowerInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Update powerinfo "); sql.Append(" Set powername = '" + info.PowerName + "',"); sql.Append(" powervalue = '" + info.PowerValue.ToString() + "' "); sql.Append(" Where powerid = '" + info.PowerId.ToString() + "'"); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool CreatePower(PowerInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Insert Into powerinfo "); sql.Append(" ( powername, powervalue, moudleid) "); sql.Append(" Values( "); sql.Append(" '" + info.PowerName + "',"); sql.Append(" '" + info.PowerValue.ToString() + "',"); sql.Append(" '" + info.MoudleId.ToString() + "'"); sql.Append(" ) "); return DataBaseManage.ExecuteSql(sql.ToString()) > 0; }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool CreatePower(PowerInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Insert Into powerinfo "); sql.Append(" ( powername, powervalue, moudleid) "); sql.Append(" Values( "); sql.Append(" '" + info.PowerName + "',"); sql.Append(" '" + info.PowerValue.ToString() + "',"); sql.Append(" '" + info.MoudleId.ToString() + "'"); sql.Append(" ) "); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// /// </summary> /// <param name="PowerId"></param> /// <returns></returns> public PowerInfo GetPowerInfo(string PowerId) { string Sql = "Select powerid, powername, powervalue, moudleid From powerinfo where powerid='" + PowerId + "'"; PowerInfo info = new PowerInfo(); using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql)) { if (reader.Read()) { info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? "" : reader["moudleid"].ToString(); info.PowerId = (reader.IsDBNull(reader.GetOrdinal("powerid"))) ? "" : reader["powerid"].ToString(); info.PowerName = (reader.IsDBNull(reader.GetOrdinal("powername"))) ? "" : reader["powername"].ToString(); info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString()); } } return info; }
/// <summary> /// /// </summary> /// <param name="PowerId"></param> /// <returns></returns> public PowerInfo GetPowerInfo(string PowerId) { string Sql = "Select powerid, powername, powervalue, moudleid From powerinfo where powerid='" + PowerId + "'"; PowerInfo info = new PowerInfo(); using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql)) { if (reader.Read()) { info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? "" : reader["moudleid"].ToString(); info.PowerId = (reader.IsDBNull(reader.GetOrdinal("powerid"))) ? "" : reader["powerid"].ToString(); info.PowerName = (reader.IsDBNull(reader.GetOrdinal("powername"))) ? "" : reader["powername"].ToString(); info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString()); } } return(info); }
protected void BTN_ADD_Click(object sender, EventArgs e) { PowerInfo info = new PowerInfo(); info.MoudleId = this.ViewState["ID"].ToString(); info.PowerName = this.TXT_POWERNAME.Text; info.PowerValue = int.Parse(this.TXT_POWERVALUE.Text.Trim()); if (this._Power.CreatePower(info)) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('模块功能保存成功!');</script>"); BuildGrid(this.ViewState["ID"].ToString()); ClearPage(); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('模块功能保存失败!');</script>"); } }
/// <summary> /// /// </summary> /// <returns></returns> public List<PowerInfo> GetPowerByMoudleId(string MoudleId) { string Sql = "Select powerid, powername, powervalue, moudleid From powerinfo where moudleid='" + MoudleId + "'"; List<PowerInfo> ListInfo = new List<PowerInfo>(); PowerInfo info = null; using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql)) { if (reader!=null) { while (reader.Read()) { info = new PowerInfo(); info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? "" : reader["moudleid"].ToString(); info.PowerId = (reader.IsDBNull(reader.GetOrdinal("powerid"))) ? "" : reader["powerid"].ToString(); info.PowerName = (reader.IsDBNull(reader.GetOrdinal("powername"))) ? "" : reader["powername"].ToString(); info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString()); ListInfo.Add(info); } } } return ListInfo; }
/// <summary> /// /// </summary> /// <returns></returns> public List <PowerInfo> GetPowerByMoudleId(string MoudleId) { string Sql = "Select powerid, powername, powervalue, moudleid From powerinfo where moudleid='" + MoudleId + "'"; List <PowerInfo> ListInfo = new List <PowerInfo>(); PowerInfo info = null; using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql)) { if (reader != null) { while (reader.Read()) { info = new PowerInfo(); info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? "" : reader["moudleid"].ToString(); info.PowerId = (reader.IsDBNull(reader.GetOrdinal("powerid"))) ? "" : reader["powerid"].ToString(); info.PowerName = (reader.IsDBNull(reader.GetOrdinal("powername"))) ? "" : reader["powername"].ToString(); info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString()); ListInfo.Add(info); } } } return(ListInfo); }
public bool ModifyPower(PowerInfo info) { return _Dao.ModifyPower(info); }
public bool CreatePower(PowerInfo info) { return _Dao.CreatePower(info); }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool ModifyPower(PowerInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Update powerinfo "); sql.Append(" Set powername = '" + info.PowerName + "',"); sql.Append(" powervalue = '" + info.PowerValue.ToString() + "' "); sql.Append(" Where powerid = '" + info.PowerId.ToString() + "'"); return DataBaseManage.ExecuteSql(sql.ToString()) > 0; }
public bool ModifyPower(PowerInfo info) { return(_Dao.ModifyPower(info)); }
public bool CreatePower(PowerInfo info) { return(_Dao.CreatePower(info)); }