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