public ActionResult Create(ModelPictures model, FormCollection fc)
{
var resultMsg = string.Empty;
ViewBag.Categorys = base.QueryCategoryAll(model.Categoryid.ToString());
ViewBag.CategoryOwner = base.QueryCategoryAll(model.Owner);
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.Picuri = string.IsNullOrWhiteSpace(fileName) ? model.Picuri : fileName;
LogicPictures logic = new LogicPictures();
var res = logic.PicturesInsertUpdate(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 Create(string Id = null)
{
var resultMsg = string.Empty;
ModelPictures model = new ModelPictures();
if (string.IsNullOrWhiteSpace(Id))
{
ViewBag.Categorys = base.QueryCategoryAll();
ViewBag.CategoryOwner = base.QueryCategoryAll();
}
else
{
LogicPictures logic = new LogicPictures();
model = logic.PicturesDetail(out resultMsg,base.AuthorizeInfo, int.Parse(Id));
if (model != null)
{
ViewBag.Categorys = base.QueryCategoryAll();
ViewBag.CategoryOwner = base.QueryCategoryAll();
}
else
{
ViewBag.Categorys = base.QueryCategoryAll(model.Categoryid.ToString());
ViewBag.CategoryOwner = base.QueryCategoryAll(model.Owner);
}
}
return View(model);
}
/// <summary>
/// ���� ���/����
/// </summary>
/// <param name="pictures">ʵ��</param>
/// <returns>ִ�н��</returns>
public int PicturesInsertUpdate(out string resultMsg,ModelPictures pictures,DbTransaction tran =null)
{
resultMsg = string.Empty;
int res = 0;
try
{
//�洢��������
string sql = "USP_PICTURES_INSERT_UPDATE";
//�������
IList<DBParameter> parm = new List<DBParameter>();
parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = pictures.Id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "NAME", ParameterValue = pictures.Name, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "CATEGORYID", ParameterValue = pictures.Categoryid, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "OWNER", ParameterValue = pictures.Owner, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "PICURI", ParameterValue = pictures.Picuri, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "PICLINK", ParameterValue = pictures.Piclink, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "STATUS", ParameterValue = pictures.Status, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
//����/����ִ��
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>ModelPictures</returns>
public ModelPictures PicturesDetail(out string resultMsg,Int32 id )
{
resultMsg = string.Empty;
var model = new ModelPictures();
try
{
//�洢��������
string sql = "usp_pictures_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<ModelPictures> list = GetModel(dr);
model = list.First();
}
}
catch (Exception ex)
{
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return model;
}
/// <summary>
/// Model ��ֵ IDataReader
/// </summary>
private IList<ModelPictures> GetModel(IDataReader dr)
{
var modelList = new List<ModelPictures>();
while (dr.Read())
{
var model = new ModelPictures();
model.Id = dr["Id"]== DBNull.Value ? 0 : Convert.ToInt32(dr["Id"]);
model.Name = dr["Name"] == DBNull.Value ? string.Empty : dr["Name"].ToString();
model.CategoryName = dr["OwnerCategoryName"] == DBNull.Value ? string.Empty : dr["OwnerCategoryName"].ToString();
model.OwnerCategoryName = dr["CategoryName"] == DBNull.Value ? string.Empty : dr["CategoryName"].ToString();
model.Categoryid = dr["CategoryId"]== DBNull.Value ? 0 : Convert.ToInt32(dr["CategoryId"]);
model.Owner = dr["Owner"]== DBNull.Value ? string.Empty : Convert.ToString(dr["Owner"]);
model.Picuri = dr["PicUri"]== DBNull.Value ? string.Empty : dr["PicUri"].ToString();
model.Piclink = dr["PicLink"]== DBNull.Value ? string.Empty : dr["PicLink"].ToString();
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;
}
public IList<ModelPictures> QueryPicturesListByOwner(out string resultMsg, string CategoryCode, string ownerCode)
{
resultMsg = string.Empty;
var model = new ModelPictures();
IList<ModelPictures> list = new List<ModelPictures>();
try
{
//�洢��������
string sql = "usp_pictures_select_by_owner";
//�������
IList<DBParameter> parm = new List<DBParameter>();
parm.Add(new DBParameter() { ParameterName = "CategoryCode", ParameterValue = CategoryCode, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "OwnerCode", ParameterValue = ownerCode, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
//��ѯִ��
using (IDataReader dr = DBHelper.ExecuteReader(sql, true, parm))
{
list = GetModel(dr);
}
}
catch (Exception ex)
{
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return list;
}