public int EditMaterial(MemberShipCardMaterial material) { using (var helper = new SqlHelper()) { var id = new InternalMemberShipCardMaterial(helper).EditMaterial(material); return(id); } }
internal MemberShipCardMaterial GetMembershipcardMaterial(int comid, int materialid) { string sql = @"SELECT [MaterialId] ,[title] ,[imgpath] ,[summary] ,[article] ,[applystate] ,[phone] ,[price] ,[sortid] ,[comid] FROM [EtownDB].[dbo].[MemberShipCardMaterial] where MaterialId=" + materialid + " and comid=" + comid; var cmd = sqlHelper.PrepareTextSqlCommand(sql); using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { MemberShipCardMaterial material = new MemberShipCardMaterial(); material.MaterialId = reader.GetValue <int>("MaterialId"); material.Title = reader.GetValue <string>("title"); material.Imgpath = reader.GetValue <string>("imgpath"); material.Summary = reader.GetValue <string>("summary"); material.Article = reader.GetValue <string>("article"); material.Applystate = reader.GetValue <bool>("applystate"); material.Phone = reader.GetValue <string>("phone") == null ? "" : reader.GetValue <string>("phone"); material.Price = reader.GetValue <decimal>("price"); material.Comid = reader.GetValue <int>("comid"); reader.Close(); return(material); } else { return(null); } } }
internal List <MemberShipCardMaterial> Membershipcardpagelist(int comid, int pageindex, int pagesize, bool applystate, out int totalcount) { var cmd = this.sqlHelper.PrepareStoredSqlCommand("usp_PagingLarge"); var tblName = "MemberShipCardMaterial"; var strGetFields = "*"; var sortKey = "sortid"; var sortMode = "0"; var condition = " comid=" + comid; condition += " and applystate='" + applystate + "'"; cmd.PagingCommand(tblName, strGetFields, pageindex, pagesize, sortKey, sortMode, condition); List <MemberShipCardMaterial> list = new List <MemberShipCardMaterial>(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { MemberShipCardMaterial model = new MemberShipCardMaterial(); model.MaterialId = reader.GetValue <int>("MaterialId"); model.Title = reader.GetValue <string>("title"); model.Applystate = reader.GetValue <bool>("applystate"); model.Article = reader.GetValue <string>("article"); model.Imgpath = reader.GetValue <string>("imgpath"); model.Summary = reader.GetValue <string>("Summary"); model.Phone = reader.GetValue <string>("phone"); model.Price = reader.GetValue <decimal>("price"); list.Add(model); } } totalcount = int.Parse(cmd.Parameters[7].Value.ToString()); return(list); }
internal List <MemberShipCardMaterial> GetMCMateralListByComId(int comid, out int totalcount) { string sql = @"SELECT [MaterialId] ,[title] ,[imgpath] ,[summary] ,[article] ,[applystate] ,[phone] ,[sortid] ,[comid] ,[price] FROM [EtownDB].[dbo].[MemberShipCardMaterial] where comid=@comid and applystate=1"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@comid", comid); List <MemberShipCardMaterial> list = new List <MemberShipCardMaterial>(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { MemberShipCardMaterial model = new MemberShipCardMaterial(); model.MaterialId = reader.GetValue <int>("MaterialId"); model.Title = reader.GetValue <string>("title"); model.Applystate = reader.GetValue <bool>("applystate"); model.Article = reader.GetValue <string>("article"); model.Imgpath = reader.GetValue <string>("imgpath"); model.Summary = reader.GetValue <string>("Summary"); model.Phone = reader.GetValue <string>("phone"); model.Price = reader.GetValue <decimal>("price"); list.Add(model); } } totalcount = int.Parse(cmd.Parameters[0].Value.ToString()); return(list); }
internal int EditMaterial(MemberShipCardMaterial model) { var cmd = sqlHelper.PrepareStoredSqlCommand(SQLInsertOrUpdate); cmd.AddParam("@MaterialId", model.MaterialId); cmd.AddParam("@Title", model.Title); cmd.AddParam("@Imgpath", model.Imgpath); cmd.AddParam("@Summary", model.Summary); cmd.AddParam("@Article", model.Article); cmd.AddParam("@ApplyState", model.Applystate); cmd.AddParam("@Phone", model.Phone); cmd.AddParam("@Price", model.Price); cmd.AddParam("@comid", model.Comid); var parm = cmd.AddReturnValueParameter("ReturnValue"); cmd.ExecuteNonQuery(); return((int)parm.Value); }