/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.ProjectTask_CSTMember_Brand model) { SqlParameter[] parameters = { new SqlParameter("@CSTMemberID", SqlDbType.Int, 4), new SqlParameter("@BrandID", SqlDbType.Int, 4), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Value = model.CSTMemberID; parameters[1].Value = model.BrandID; parameters[2].Value = model.CreateUserID; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_CSTMEMBER_BRAND_INSERT, parameters); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.ProjectTask_CSTMember_Brand model) { SqlParameter[] parameters = { new SqlParameter("@CSTMemberID", SqlDbType.Int, 4), new SqlParameter("@BrandID", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Value = model.CSTMemberID; parameters[1].Value = model.BrandID; parameters[2].Value = model.CreateTime; parameters[3].Value = model.CreateUserID; return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_CSTMEMBER_BRAND_UPDATE, parameters)); }
/// <summary> /// 根据车商通会员信息的ID查找主营品牌信息 /// </summary> /// <param name="memberId">车商通会员信息ID</param> /// <returns></returns> public List <Entities.ProjectTask_CSTMember_Brand> GetProjectTask_CSTMember_Brand(int memberId) { List <Entities.ProjectTask_CSTMember_Brand> list = new List <Entities.ProjectTask_CSTMember_Brand>(); SqlParameter[] parameters = { new SqlParameter("@MemberID", SqlDbType.VarChar, 8000) }; parameters[0].Value = memberId; DataSet ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, "P_projectTask_CSTMember_Brand_SELECTMainBrand", parameters); foreach (DataRow dr in ds.Tables[0].Rows) { Entities.ProjectTask_CSTMember_Brand brandInfo = LoadSingleProjectTask_CSTMember_Brand(dr); list.Add(brandInfo); } return(list); }
/// <summary> /// 插入车商通主营品牌 /// </summary> /// <param name="cstMemberBrands"></param> /// <param name="count"></param> /// <param name="memberId"></param> private void InsertCstMemberBrand(List <string> cstMemberBrands, int count, int memberId) { BLL.ProjectTask_CSTMember_Brand.Instance.Delete(memberId); string brands = cstMemberBrands[count]; if (brands != string.Empty) { string[] brandArry = brands.Split(','); foreach (string brandId in brandArry) { int id = -1; if (int.TryParse(brandId, out id)) { Entities.ProjectTask_CSTMember_Brand brandInfo = new Entities.ProjectTask_CSTMember_Brand(); brandInfo.BrandID = id; brandInfo.CreateUserID = BLL.Util.GetLoginUserID(); brandInfo.CSTMemberID = memberId; BLL.ProjectTask_CSTMember_Brand.Instance.Insert(brandInfo); } } } }
private Entities.ProjectTask_CSTMember_Brand LoadSingleProjectTask_CSTMember_Brand(DataRow row) { Entities.ProjectTask_CSTMember_Brand model = new Entities.ProjectTask_CSTMember_Brand(); if (row["CSTMemberID"].ToString() != "") { model.CSTMemberID = int.Parse(row["CSTMemberID"].ToString()); } if (row["BrandID"].ToString() != "") { model.BrandID = int.Parse(row["BrandID"].ToString()); } if (row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(row["CreateUserID"].ToString()); } return(model); }
public Entities.ProjectTask_CSTMember_Brand GetProjectTask_CSTMember_Brand1(int ID) { string where = string.Empty; Entities.ProjectTask_CSTMember_Brand model_Brand = null; DataSet ds; SqlParameter[] parameters = { new SqlParameter("@MemberID", SqlDbType.Int) }; parameters[0].Value = ID; ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, "P_rojectTask_CSTMember_Brand_SelectMainBrand", parameters); if (ds.Tables[0].Rows.Count > 0) { model_Brand = new Entities.ProjectTask_CSTMember_Brand(); model_Brand.BrandID = int.Parse(ds.Tables[0].Rows[0]["BrandID"].ToString()); model_Brand.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); model_Brand.CSTMemberID = int.Parse(ds.Tables[0].Rows[0]["CSTMemberID"].ToString()); model_Brand.CreateUserID = int.Parse(ds.Tables[0].Rows[0]["CreateUserID"].ToString()); } return(model_Brand); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.ProjectTask_CSTMember_Brand model) { return(Dal.ProjectTask_CSTMember_Brand.Instance.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.ProjectTask_CSTMember_Brand model) { Dal.ProjectTask_CSTMember_Brand.Instance.Insert(model); }