/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Add(ParameterName entity)
{
try
{
if (dr == null)
{
dr = new CallDatabase();
}
entity.Status = "1";
dr.InitiCommand("insert into Sys_ParameterName([ConfigName],[No],[Memo])values(@ConfigName,@No,@Memo);select @@identity");
dr.AddParameters("ConfigName", DbType.String, 50, entity.ConfigName);
dr.AddParameters("No", DbType.Int32, entity.No);
dr.AddParameters("Memo", DbType.String, 250, entity.Memo);
int value = Convert.ToInt32(dr.ExecuteScalar());
entity.Id = value;
dr.Close();
return(0);
}
catch (Exception ex)
{
using (ILog_Error log = new Log_Error_Generate())
{
log.Title = ex.Message;
log.Content = ex.StackTrace;
log.Generatelog();
}
return(-1);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Add(System_User entity)
{
try
{
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("insert into Sys_User([LoginName],[Pwd],[UserName],[Remarks])values(@LoginName,@Pwd,@UserName,@Remarks);select @@identity");
dr.AddParameters("LoginName", DbType.String, 30, entity.LoginName);
dr.AddParameters("Pwd", DbType.String, 20, entity.Pwd);
dr.AddParameters("UserName", DbType.String, 8, entity.UserName);
dr.AddParameters("Remarks", DbType.String, 200, entity.Remarks);
int value = Convert.ToInt32(dr.ExecuteScalar());
entity.Id = value;
dr.Close();
return(0);
}
catch (Exception ex)
{
using (ILog_Error log = new Log_Error_Generate())
{
log.Title = ex.Message;
log.Content = ex.StackTrace;
log.Generatelog();
}
return(-1);
}
}
/// <summary>
/// 根据日期获取数据
/// </summary>
/// <param name="date">日期</param>
/// <param name="loginName">登录用户</param>
/// <returns></returns>
public DataSet GetData(DateTime date, string loginName)
{
ICallDatabase dr = new CallDatabase();
dr.InitiCommand();
dr.CommandText = "select Login_Name,Result,ResultsDescribed,Creation_Date from [Log_Login] where DateDiff(day,Creation_Date,@Creation_Date)=0 And [Login_Name] like @Login_Name order by [Creation_Date] desc";
dr.AddParameters("Creation_Date", DbType.String, 20, date.ToString());
dr.AddParameters("Login_Name", DbType.String, 50, "%" + loginName + "%");
DataSet data = dr.DataList();
dr.Close();
dr.Dispose();
return(data);
}
/// <summary>
/// 根据主键来获取数据集
/// </summary>
/// <param name="id">主键</param>
/// <returns></returns>
public DataSet GetData(int id, out DataTable log_Contents_Data)
{
log_Contents_Data = new DataTable();
ICallDatabase dr = new CallDatabase();
dr.InitiCommand();
dr.CommandText = "select Login_Name,ModuleName,OperationType,Result,ResultsDescribed,Creation_Date from [Log_Operating] where Id=@Id ";
dr.AddParameters("Id", DbType.Int32, id);
DataSet data = dr.DataList();
dr.CommandText = "select Contents from [Log_Operating_Contents] where L_Id=@Id order by [No]";
log_Contents_Data = dr.DataList().Tables[0];
dr.Close();
dr.Dispose();
return(data);
}