public ActionResult Edit(ModelCategory model, FormCollection fc)
{
var resultMsg = string.Empty;
ViewBag.Categorys = base.QueryCategoryAll(model.Parentcateg);
var result = new ResultBase();
//图片上传
var fileName = CommonMethod.ImageUpload(out result, this.HttpContext);
if (result.result == -2)
{
ViewBag.CustomScript = UtilityScript.ShowMessage(result.resultMsg, isCreate: true);
return View(model);
}
model.Parentcateg = string.IsNullOrWhiteSpace(model.Parentcateg) ? "0" : model.Parentcateg;
model.Thumbnails = string.IsNullOrWhiteSpace(fileName) ? model.Thumbnails : fileName;
model.Introduction = fc["editorValue"];
//数据保存
LogicCategory logic = new LogicCategory();
var res = logic.CategoryInsertUpdate(out resultMsg,base.AuthorizeInfo, model);
if (res > 0)
{
resultMsg = "操作成功!";
ViewBag.CustomScript = UtilityScript.ShowMessage(resultMsg, isCreate: true, isSuccess: true, funName: "Goto");
}
else
{
resultMsg = "操作失败,请检查数据是否正确后重新操作!";
ViewBag.CustomScript = UtilityScript.ShowMessage(resultMsg, isCreate: true, isSuccess: true, funName: "BtnShow");
}
return View(model);
}
public ActionResult Edit(string id = null, string Category=null)
{
ModelCategory model = new ModelCategory();
if (string.IsNullOrWhiteSpace(id))
{
model.Parentcateg = Category;
model.Createdate = DateTime.Now;
ViewBag.Categorys = base.QueryCategoryAll(string.IsNullOrWhiteSpace(Category) ? null : Category);
return View(model);
}
else
{
var idx = 0;
int.TryParse(id, out idx);
var resultMsg = string.Empty;
LogicCategory logic = new LogicCategory();
model = logic.CategoryDetail(out resultMsg,base.AuthorizeInfo, idx);
if (model != null && string.IsNullOrWhiteSpace(model.Parentcateg)==false)
{
ViewBag.Categorys = base.QueryCategoryAll(model.Parentcateg.ToString());
}
else
{
ViewBag.Categorys = base.QueryCategoryAll();
}
if (resultMsg.Contains(BaseDict.ErrorPrefix))
{
ViewBag.CustomScript = UtilityScript.ShowMessage(resultMsg, isCreate: true, isSuccess: true);
}
return View(model);
}
}
private IList<ModelCategory> GetModelThree(IDataReader dr)
{
var modelList = new List<ModelCategory>();
while (dr.Read())
{
var model = new ModelCategory();
model.Id = dr["Id"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Id"]);
model.Name = dr["Name"] == DBNull.Value ? string.Empty : dr["Name"].ToString();
model.Parentcateg = dr["ParentCateg"] == DBNull.Value ? string.Empty : Convert.ToString(dr["ParentCateg"]);
model.Level = dr["LEVEL"] == DBNull.Value ? 0 : Convert.ToInt32(dr["LEVEL"]);
modelList.Add(model);
}
return modelList;
}
/// <summary>
/// Model ��ֵ IDataReader
/// </summary>
private IList<ModelCategory> GetModel(IDataReader dr)
{
var modelList = new List<ModelCategory>();
while (dr.Read())
{
var model = new ModelCategory();
model.Id = dr["Id"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Id"]);
model.Name = dr["Name"] == DBNull.Value ? string.Empty : dr["Name"].ToString();
model.Nameen = dr["NameEn"] == DBNull.Value ? string.Empty : dr["NameEn"].ToString();
model.Thumbnails = dr["Thumbnails"] == DBNull.Value ? string.Empty : dr["Thumbnails"].ToString();
model.Introduction = dr["Introduction"] == DBNull.Value ? string.Empty : dr["Introduction"].ToString();
model.Parentcateg = dr["ParentCateg"] == DBNull.Value ? string.Empty : Convert.ToString(dr["ParentCateg"]);
model.Sort = dr["Sort"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Sort"]);
model.Isnav = dr["IsNav"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsNav"]);
model.Isindex = dr["IsIndex"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsIndex"]);
model.Status = dr["Status"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Status"]);
model.Createdate = dr["CreateDate"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["CreateDate"]);
modelList.Add(model);
}
return modelList;
}
/// <summary>
/// ���� ���/����
/// </summary>
/// <param name="category">ʵ��</param>
/// <returns>ִ�н��</returns>
public int CategoryInsertUpdate(out string resultMsg, ModelCategory category, DbTransaction tran = null)
{
resultMsg = string.Empty;
int res = 0;
try
{
//�洢��������
string sql = "USP_CATEGORY_INSERT_UPDATE";
//�������
IList<DBParameter> parm = new List<DBParameter>();
parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = category.Id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "NAME", ParameterValue = category.Name, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "NAMEEN", ParameterValue = category.Nameen, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "THUMBNAILS", ParameterValue = category.Thumbnails, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "INTRODUCTION", ParameterValue = category.Introduction, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "PARENTCATEG", ParameterValue = category.Parentcateg, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "SORT", ParameterValue = category.Sort, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "ISNAV", ParameterValue = category.Isnav, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "ISINDEX", ParameterValue = category.Isindex, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "STATUS", ParameterValue = category.Status, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
//parm.Add(new DBParameter() { ParameterName = "CREATEDATE", ParameterValue = category.Createdate, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.DateTime });
//parm.Add(new DBParameter() { ParameterName = "resultMsg", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.String });
//����/����ִ��
res = DBHelper.ExecuteNonQuery(sql, true, parm, tran);
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return res;
}
/// <summary>
/// ��ѯʵ��
/// </summary>
/// <param name="id">ModelId ���</param>
/// <returns>ModelCategory</returns>
public ModelCategory CategoryDetailByPid(out string resultMsg, Int32 id,DateTime StartDate ,DateTime EndDate)
{
resultMsg = string.Empty;
var model = new ModelCategory();
try
{
//�洢��������
string sql = "usp_category_select_detail_by_pid";
//�������
IList<DBParameter> parm = new List<DBParameter>();
parm.Add(new DBParameter() { ParameterName = "Id", ParameterValue = id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "StartDate", ParameterValue = StartDate, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.DateTime });
parm.Add(new DBParameter() { ParameterName = "EndDate", ParameterValue = EndDate, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.DateTime });
//��ѯִ��
using (IDataReader dr = DBHelper.ExecuteReader(sql, true, parm))
{
IList<ModelCategory> list = GetModel(dr);
model = list.First();
}
}
catch (Exception ex)
{
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return model;
}
/// <summary>
/// ��ѯʵ��
/// </summary>
/// <param name="id">ModelId ���</param>
/// <returns>ModelCategory</returns>
public ModelCategory CategoryDetail(out string resultMsg, Int32 id)
{
resultMsg = string.Empty;
var model = new ModelCategory();
try
{
//�洢��������
string sql = "USP_CATEGORY_SELECT_DETAIL_BY_ID";
//�������
IList<DBParameter> parm = new List<DBParameter>();
parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
//��ѯִ��
using (IDataReader dr = DBHelper.ExecuteReader(sql, true, parm))
{
IList<ModelCategory> list = GetModel(dr);
model = list.First();
}
}
catch (Exception ex)
{
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return model;
}
