///<summary>
///添加方法，返回Boolean类型，为true表示操作成功，否则操作失败
///生成时间：2010-8-27 22:00:49
///</summary>
public Boolean AddSystem_module_operate(System_module_operate system_module_operate)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Operate_text", system_module_operate.Operate_text),
new MySqlParameter("?status", system_module_operate.Status)
};
return(MySqlHelper.ExecuteNonQuery(SQL_INSERT, param) > 0);
}
public int InsertSystem_module_operate(System_module_operate system_module_operate)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Operate_text", system_module_operate.Operate_text),
new MySqlParameter("?status", system_module_operate.Status)
};
return(Convert.ToInt32(MySqlHelper.ExecuteScalar(SQL_INSERTRETURNID, param)));
}
///<summary>
///修改方法，返回Boolean类型，为true表示操作成功，否则操作失败
///生成时间：2010-8-27 22:00:49
///</summary>
public Boolean UpdateSystem_module_operate(System_module_operate system_module_operate)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Operate_text", system_module_operate.Operate_text),
new MySqlParameter("?status", system_module_operate.Status),
new MySqlParameter("?OperateID", system_module_operate.OperateID)
};
return(MySqlHelper.ExecuteNonQuery(SQL_UPDATE, param) > 0);
}
///<sumary>
///修改信息
///时间：2010-8-27 22:01:15
///</sumary>
public static Boolean UpdateSystem_module_operate(System_module_operate system_module_operate)
{
try
{
return(system_module_operateService.UpdateSystem_module_operate(system_module_operate));
}
catch (Exception ex)
{
//可以记录到异常日志
return(false);
}
}
public bool Updatestatus(int OperateID)
{
IList <System_module_operate> smos = GetModuleOperateById(OperateID);
bool reval = false;
if (smos.Count > 0)
{
System_module_operate smo = smos[0];
if (smo.Status.ToString() == "1")
{
reval = UpdateModuleOperateStatus("0", OperateID);
}
else
{
reval = UpdateModuleOperateStatus("1", OperateID);
}
}
return(reval);
}
public IList <System_module_operate> GetModuleOperateBySql(string sql, params MySqlParameter[] param)
{
IList <System_module_operate> list = new List <System_module_operate>();
using (MySqlDataReader reader = MySqlHelper.ExecuteReader(sql, param))
{
while (reader.Read())
{
//System_module_operate systemmoduleOperate = new System_module_operate(reader.GetInt32("OperateID"), reader.GetString("Operate_text"), reader.GetChar("Status"));
System_module_operate systemmoduleOperate = new System_module_operate();
systemmoduleOperate.OperateID = reader.GetInt32("OperateID");
systemmoduleOperate.Operate_text = reader.GetString("Operate_text");
systemmoduleOperate.Status = reader.GetString("status");
list.Add(systemmoduleOperate);
}
reader.Close();
}
return(list);
}
public static int InsertSystem_module_operate(System_module_operate operate)
{
return(system_module_operateService.InsertSystem_module_operate(operate));
}
