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