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