public static EditorDto GetOneEditorDto(string table,string strwhere)
{
EditorDto editorDto=new EditorDto();
editorDto = EditorDal.GetOneEditor(table, strwhere);
return editorDto;
}
public ActionResult EditorInsert(EditorAddViewModel model)
{
EditorDto editorDto = new EditorDto();
editorDto.EditorUserName = model.EditorUserName;
editorDto.EditorRealName = model.EditorRealName;
editorDto.EditorPassword = CommonTools.ToMd5(model.EditorPassword);
editorDto.EditorRegTime = System.DateTime.Now;
EditorBll.AddEditor(editorDto);
return RedirectTo("/Editor/EditorIndex", "网站管理员添加成功了");
//return RedirectToAction("EditorIndex");
}
public static void AddEditor(EditorDto editorDto)
{
SqlParameter[] arParames = EditorDal.getParameters(editorDto);
SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString);
try
{
SqlHelper.ExecuteNonQuery(myconn, CommandType.StoredProcedure, "CreateEditor", arParames);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
myconn.Close();
myconn.Dispose();
}
}
public static List<EditorDto> GetEditorList(string strwhere)
{
List<EditorDto> editorlist = new List<EditorDto>();
SqlParameter[] arParames = new SqlParameter[2];
arParames[0] = new SqlParameter("@table ", SqlDbType.VarChar, 200);
arParames[0].Value = "QxsqEditor";
arParames[1] = new SqlParameter("@Where ", SqlDbType.VarChar, 8000);
arParames[1].Value = strwhere;
SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString);
try
{
DataTable dt = null;
DataSet ds = SqlHelper.ExecuteDataset(myconn, CommandType.StoredProcedure, "getModelByWhere", arParames);
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
EditorDto editorDto = new EditorDto();
editorDto = EditorDal.getDataRowToEditorDto(dr);
editorlist.Add(editorDto);
}
return editorlist;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
myconn.Close();
myconn.Dispose();
}
}
private static SqlParameter[] getParameters(EditorDto editorDto)
{
SqlParameter[] arParames = new SqlParameter[5];
arParames[0] = new SqlParameter("@EditorId", SqlDbType.Int);
arParames[0].Value = editorDto.EditorId;
arParames[1] = new SqlParameter("@EditorUserName", SqlDbType.VarChar, 50);
arParames[1].Value = editorDto.EditorUserName;
arParames[2] = new SqlParameter("@EditorPassword", SqlDbType.VarChar, 50);
arParames[2].Value = editorDto.EditorPassword;
arParames[3] = new SqlParameter("@EditorRealName", SqlDbType.VarChar, 50);
arParames[3].Value = editorDto.EditorRealName;
arParames[4] = new SqlParameter("@EditorRegTime", SqlDbType.DateTime);
arParames[4].Value = editorDto.EditorRegTime;
return arParames;
}
private static EditorDto getDataRowToEditorDto(DataRow dr)
{
EditorDto editorDto = new EditorDto();
editorDto.EditorId = int.Parse(dr["EditorId"].ToString());
editorDto.EditorUserName = dr["EditorUserName"].ToString();
editorDto.EditorRealName = dr["EditorRealName"].ToString();
editorDto.EditorPassword = dr["EditorPassword"].ToString();
editorDto.EditorRegTime = DateTime.Parse(dr["EditorRegTime"].ToString());
return editorDto;
}
public static void SetSessions(EditorDto editorDto)
{
HttpContext.Current.Session["EditorId"] = editorDto.EditorId;
}
public static void UpdateEditorDto(EditorDto editorDto)
{
EditorDal.UpdateEditor(editorDto);
}
public static void AddEditor(EditorDto editorDto)
{
EditorDal.AddEditor(editorDto);
}
