/// <summary> /// 推广接收设置 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool ReceivedSet(Tz888.Model.SubscribeGetSet model) { bool b = false; SqlParameter[] parameters = { new SqlParameter("@flag", SqlDbType.VarChar, 30), new SqlParameter("@LoginName", SqlDbType.Char, 10), new SqlParameter("@IsGet", SqlDbType.Int, 4), new SqlParameter("@objectGradeID", SqlDbType.VarChar, 20), new SqlParameter("@objectNeed", SqlDbType.VarChar, 50), new SqlParameter("@CountryCode", SqlDbType.VarChar, 50), new SqlParameter("@ProvinceID", SqlDbType.VarChar, 50), new SqlParameter("@CityID", SqlDbType.VarChar, 50), new SqlParameter("@CountyID", SqlDbType.VarChar, 50), new SqlParameter("@Industry", SqlDbType.VarChar, 100), new SqlParameter("@OtherCriter", SqlDbType.VarChar, 100), new SqlParameter("@ReveiveType", SqlDbType.Char, 10) }; parameters[0].Value = "ReceivedSet";//接收设置 parameters[1].Value = model.LoginName; parameters[2].Value = model.IsGet; parameters[3].Value = model.objectGradeID; parameters[4].Value = model.objectNeed; parameters[5].Value = model.CountryCode; parameters[6].Value = model.ProvinceID; parameters[7].Value = model.CityID; parameters[8].Value = model.CountyID; parameters[9].Value = model.Industry; parameters[10].Value = model.OtherCriter; parameters[11].Value = model.ReveiveType; b = DbHelperSQL.RunProcLob("SubscribeReceivedSet", parameters); return(b); }
public Tz888.Model.SubscribeGetSet GetModel(string LoginName) { SqlParameter[] parameters = { new SqlParameter("@flag", SqlDbType.VarChar, 50), new SqlParameter("@LoginName", SqlDbType.VarChar, 16) }; parameters[0].Value = "GetModel"; parameters[1].Value = LoginName; Tz888.Model.SubscribeGetSet model = new Tz888.Model.SubscribeGetSet(); DataSet ds = DbHelperSQL.RunProcedure("SubscribeReceivedSet", parameters, "ds"); model.LoginName = LoginName; if (ds.Tables[0].Rows.Count > 0) { model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString(); if (ds.Tables[0].Rows[0]["IsGet"].ToString() != "") { model.IsGet = int.Parse(ds.Tables[0].Rows[0]["IsGet"].ToString()); } model.objectGradeID = ds.Tables[0].Rows[0]["objectGradeID"].ToString(); model.objectNeed = ds.Tables[0].Rows[0]["objectNeed"].ToString(); model.CountryCode = ds.Tables[0].Rows[0]["CountryCode"].ToString(); model.ProvinceID = ds.Tables[0].Rows[0]["ProvinceID"].ToString(); model.CityID = ds.Tables[0].Rows[0]["CityID"].ToString(); model.CountyID = ds.Tables[0].Rows[0]["CountyID"].ToString(); model.Industry = ds.Tables[0].Rows[0]["Industry"].ToString(); model.OtherCriter = ds.Tables[0].Rows[0]["OtherCriter"].ToString(); model.ReveiveType = ds.Tables[0].Rows[0]["ReveiveType"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 推广接收设置 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool ReceivedSet(Tz888.Model.SubscribeGetSet model) { return(dal.ReceivedSet(model)); }