/// <summary> /// 得到一个对象实体 /// </summary> public E_tb_ElectronicsMagazine GetModel(int MagazineID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MagazineID,MagazineName,ImgPath,FliePath,MagazineTypeID,AddTime,AreaID,EditPersonnelID from tb_ElectronicsMagazine "); strSql.Append(" where MagazineID=@MagazineID"); SqlParameter[] parameters = { new SqlParameter("@MagazineID", SqlDbType.Int, 4) }; parameters[0].Value = MagazineID; E_tb_ElectronicsMagazine model = new E_tb_ElectronicsMagazine(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["MagazineID"].ToString() != "") { model.MagazineID = int.Parse(ds.Tables[0].Rows[0]["MagazineID"].ToString()); } if (ds.Tables[0].Rows[0]["MagazineName"] != null) { model.MagazineName = ds.Tables[0].Rows[0]["MagazineName"].ToString(); } if (ds.Tables[0].Rows[0]["ImgPath"] != null) { model.ImgPath = ds.Tables[0].Rows[0]["ImgPath"].ToString(); } if (ds.Tables[0].Rows[0]["FliePath"] != null) { model.FliePath = ds.Tables[0].Rows[0]["FliePath"].ToString(); } if (ds.Tables[0].Rows[0]["MagazineTypeID"].ToString() != "") { model.MagazineTypeID = int.Parse(ds.Tables[0].Rows[0]["MagazineTypeID"].ToString()); } if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString()); } if (ds.Tables[0].Rows[0]["AreaID"].ToString() != "") { model.AreaID = int.Parse(ds.Tables[0].Rows[0]["AreaID"].ToString()); } if (ds.Tables[0].Rows[0]["EditPersonnelID"].ToString() != "") { model.EditPersonnelID = int.Parse(ds.Tables[0].Rows[0]["EditPersonnelID"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 显示详情页 /// </summary> /// <param name="EditType">编辑类型</param> /// <returns>返回编辑结果</returns> public ActionResult MagazineEdit(E_tb_ElectronicsMagazine eElectronicsMagazine, string EditType, int?InfoID) { ViewData["MagazineTypeList"] = GetNewsTypeList(false); if (EditType == "Edit") { eElectronicsMagazine = tElectronicsMagazine.GetModel(Convert.ToInt32(InfoID)); } eElectronicsMagazine.EditType = EditType; return(View(eElectronicsMagazine)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_ElectronicsMagazine model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_ElectronicsMagazine set "); strSql.Append("MagazineName=@MagazineName,"); strSql.Append("ImgPath=@ImgPath,"); strSql.Append("FliePath=@FliePath,"); strSql.Append("MagazineTypeID=@MagazineTypeID,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("AreaID=@AreaID,"); strSql.Append("EditPersonnelID=@EditPersonnelID"); strSql.Append(" where MagazineID=@MagazineID"); SqlParameter[] parameters = { new SqlParameter("@MagazineName", SqlDbType.NVarChar, 50), new SqlParameter("@ImgPath", SqlDbType.NVarChar, 50), new SqlParameter("@FliePath", SqlDbType.NVarChar, 50), new SqlParameter("@MagazineTypeID", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@AreaID", SqlDbType.Int, 4), new SqlParameter("@EditPersonnelID", SqlDbType.Int, 4), new SqlParameter("@MagazineID", SqlDbType.Int, 4) }; parameters[0].Value = model.MagazineName; parameters[1].Value = model.ImgPath; parameters[2].Value = model.FliePath; parameters[3].Value = model.MagazineTypeID; parameters[4].Value = model.AddTime; parameters[5].Value = model.AreaID; parameters[6].Value = model.EditPersonnelID; parameters[7].Value = model.MagazineID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public string Save(E_tb_ElectronicsMagazine eElectronicsMagazine) { string msg = "0"; eElectronicsMagazine.AddTime = DateTime.Now; eElectronicsMagazine.EditPersonnelID = CurrentUserInfo.PersonnelID; eElectronicsMagazine.AreaID = CurrentUserInfo.AreaID; if (eElectronicsMagazine.EditType == "Add") { tElectronicsMagazine.Add(eElectronicsMagazine); msg = "1"; } else { tElectronicsMagazine.Update(eElectronicsMagazine); msg = "1"; } return(msg); }
/// <summary> /// 获得数据列表 /// </summary> public List <E_tb_ElectronicsMagazine> DataTableToList(DataTable dt) { List <E_tb_ElectronicsMagazine> modelList = new List <E_tb_ElectronicsMagazine>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { E_tb_ElectronicsMagazine model; for (int n = 0; n < rowsCount; n++) { model = new E_tb_ElectronicsMagazine(); if (dt.Rows[n]["MagazineID"].ToString() != "") { model.MagazineID = int.Parse(dt.Rows[n]["MagazineID"].ToString()); } model.MagazineName = dt.Rows[n]["MagazineName"].ToString(); model.ImgPath = dt.Rows[n]["ImgPath"].ToString(); model.FliePath = dt.Rows[n]["FliePath"].ToString(); if (dt.Rows[n]["MagazineTypeID"].ToString() != "") { model.MagazineTypeID = int.Parse(dt.Rows[n]["MagazineTypeID"].ToString()); } if (dt.Rows[n]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(dt.Rows[n]["AddTime"].ToString()); } if (dt.Rows[n]["AreaID"].ToString() != "") { model.AreaID = int.Parse(dt.Rows[n]["AreaID"].ToString()); } if (dt.Rows[n]["EditPersonnelID"].ToString() != "") { model.EditPersonnelID = int.Parse(dt.Rows[n]["EditPersonnelID"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_ElectronicsMagazine model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_ElectronicsMagazine("); strSql.Append("MagazineName,ImgPath,FliePath,MagazineTypeID,AddTime,AreaID,EditPersonnelID)"); strSql.Append(" values ("); strSql.Append("@MagazineName,@ImgPath,@FliePath,@MagazineTypeID,@AddTime,@AreaID,@EditPersonnelID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MagazineName", SqlDbType.NVarChar, 50), new SqlParameter("@ImgPath", SqlDbType.NVarChar, 50), new SqlParameter("@FliePath", SqlDbType.NVarChar, 50), new SqlParameter("@MagazineTypeID", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@AreaID", SqlDbType.Int, 4), new SqlParameter("@EditPersonnelID", SqlDbType.Int, 4) }; parameters[0].Value = model.MagazineName; parameters[1].Value = model.ImgPath; parameters[2].Value = model.FliePath; parameters[3].Value = model.MagazineTypeID; parameters[4].Value = model.AddTime; parameters[5].Value = model.AreaID; parameters[6].Value = model.EditPersonnelID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 前台显示的电子杂志列表页面 /// </summary> /// <param name="NewTypeID">公告类型</param> /// <returns></returns> public ActionResult MagazineShowList(int?PageIndex) { E_tb_ElectronicsMagazine eElectronicsMagazine = new E_tb_ElectronicsMagazine(); StringBuilder PageHtml = new StringBuilder(); if (PageIndex == null || PageIndex == 0) { PageIndex = 1; } int pageSize = 12; //每页数据条数 int total = 0; //总数据条数 int pageNumber = Convert.ToInt32(PageIndex); //当前页数 int pageCount; //总页数 DataTable dt = new DataTable(); dt = tElectronicsMagazine.GetListByPage("", "AddTime Desc", pageNumber * pageSize - (pageSize - 1), pageNumber * pageSize, ref total).Tables[0]; pageCount = total / pageSize + (total % pageSize > 0 ? 1 : 0); //首页 if (pageNumber == 1) { PageHtml.Append("<a disabled=\"disabled\">首页</a>"); } else { PageHtml.Append("<a href=\"/Magazine/MagazineShowList?PageIndex=1\">首页</a>"); } //上一页 if (pageNumber == 1) { PageHtml.Append("<a disabled=\"disabled\">上一页</a>"); } else { PageHtml.Append("<a href=\"/Magazine/MagazineShowList?PageIndex=" + (pageNumber - 1) + "\">上一页</a>"); } //下一页 if (pageNumber == pageCount) { PageHtml.Append("<a disabled=\"disabled\">下一页</a>"); } else { PageHtml.Append("<a href=\"/Magazine/MagazineShowList?PageIndex=" + (pageNumber + 1) + "\">下一页</a>"); } //末页 if (pageNumber == pageCount) { PageHtml.Append("<a disabled=\"disabled\">末页</a>"); } else { PageHtml.Append("<a href=\"/Magazine/MagazineShowList?PageIndex=" + pageCount + "\">末页</a>"); } ViewData["MagazineDt"] = dt; eElectronicsMagazine.PageHtml = PageHtml.ToString(); return(View(eElectronicsMagazine)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_ElectronicsMagazine model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_ElectronicsMagazine model) { return(dal.Add(model)); }