/// <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);
}
