private List <ITC_SysEvent_M> DsToList(DataSet ds)
{
List <ITC_SysEvent_M> list = new List <ITC_SysEvent_M>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ITC_SysEvent_M model = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new ITC_SysEvent_M();
if (ds.Tables[0].Rows[i]["E_ID"].ToString() != "")
{
model.E_ID = int.Parse(ds.Tables[0].Rows[i]["E_ID"].ToString());
}
model.User_ID = ds.Tables[0].Rows[i]["User_ID"].ToString();
model.E_IP = ds.Tables[0].Rows[i]["E_IP"].ToString();
model.E_Form = ds.Tables[0].Rows[i]["E_Form"].ToString();
model.E_Appname = ds.Tables[0].Rows[i]["E_Appname"].ToString();
model.E_Record = ds.Tables[0].Rows[i]["E_Record"].ToString();
if (ds.Tables[0].Rows[i]["E_Datetime"].ToString() != "")
{
model.E_Datetime = DateTime.Parse(ds.Tables[0].Rows[i]["E_Datetime"].ToString());
}
//view
model.User_Name = ds.Tables[0].Rows[i]["User_Name"].ToString();
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="form">菜单ID</param>
/// <param name="record">操作内容</param>
public static void Add(string form, string record)
{
ITC_SysEvent_M model = new ITC_SysEvent_M();
ITC_SysEvent bEvent = new ITC_SysEvent();
model.E_Form = form;
model.E_Appname = MenuContext.GetNameByCache(form);
model.User_ID = UserContext.UserID;
model.E_IP = System.Web.HttpContext.Current.Request.UserHostAddress;
model.E_Record = record;
model.E_Datetime = DateTime.Now;
bEvent.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ITC_SysEvent_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ITC_SysEvent set ");
strSql.Append(" User_ID = @User_ID , ");
strSql.Append(" E_IP = @E_IP , ");
strSql.Append(" E_Form = @E_Form , ");
strSql.Append(" E_Appname = @E_Appname , ");
strSql.Append(" E_Record = @E_Record , ");
strSql.Append(" E_Datetime = @E_Datetime ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@E_ID", SqlDbType.Int, 4),
new SqlParameter("@User_ID", SqlDbType.VarChar, 10),
new SqlParameter("@E_IP", SqlDbType.VarChar, 20),
new SqlParameter("@E_Form", SqlDbType.VarChar, 10),
new SqlParameter("@E_Appname", SqlDbType.VarChar, 20),
new SqlParameter("@E_Record", SqlDbType.Text),
new SqlParameter("@E_Datetime", SqlDbType.DateTime)
};
parameters[0].Value = model.E_ID;
parameters[1].Value = model.User_ID;
parameters[2].Value = model.E_IP;
parameters[3].Value = model.E_Form;
parameters[4].Value = model.E_Appname;
parameters[5].Value = model.E_Record;
parameters[6].Value = model.E_Datetime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ITC_SysEvent_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ITC_SysEvent(");
strSql.Append("User_ID,E_IP,E_Form,E_Appname,E_Record,E_Datetime");
strSql.Append(") values (");
strSql.Append("@User_ID,@E_IP,@E_Form,@E_Appname,@E_Record,@E_Datetime");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@User_ID", SqlDbType.VarChar, 8),
new SqlParameter("@E_IP", SqlDbType.VarChar, 20),
new SqlParameter("@E_Form", SqlDbType.VarChar, 10),
new SqlParameter("@E_Appname", SqlDbType.VarChar, 20),
new SqlParameter("@E_Record", SqlDbType.Text),
new SqlParameter("@E_Datetime", SqlDbType.DateTime)
};
parameters[0].Value = model.User_ID;
parameters[1].Value = model.E_IP;
parameters[2].Value = model.E_Form;
parameters[3].Value = model.E_Appname;
parameters[4].Value = model.E_Record;
parameters[5].Value = model.E_Datetime;
int result = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
//获取模型
public ActionResult GetModel(int id)
{
ITC_SysEvent_M mo = uifo.GetModel(id);
return(Json(mo, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(ITC_SysEvent_M model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(ITC_SysEvent_M model)
{
return(dal.Add(model));
}
