public bool SendSet1(Tz888.Model.SubscribeSet model, out int id)
{
SqlParameter[] parameters =
{
new SqlParameter("@InfoID", SqlDbType.BigInt, 8),
new SqlParameter("@Title", SqlDbType.VarChar, 50),
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@objectGradeID", SqlDbType.VarChar, 40),
new SqlParameter("@objectNeed", SqlDbType.VarChar, 100),
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, 500),
new SqlParameter("@SubscribeType", SqlDbType.Char, 10),
new SqlParameter("@SubscribeCount", SqlDbType.Int, 4),
new SqlParameter("@Promotioncount", SqlDbType.VarChar, 20),
new SqlParameter("@ManageTypeID", SqlDbType.VarChar, 20),
new SqlParameter("@ID", SqlDbType.Int, 4),
};
parameters[0].Value = model.InfoID;
parameters[1].Value = model.Title;
parameters[2].Value = model.LoginName;
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.SubscribeType;
parameters[12].Value = model.SubscribeCount;
parameters[13].Value = model.Promotioncount;
parameters[14].Value = model.ManageTypeId;
parameters[15].Direction = ParameterDirection.Output;
bool b = DbHelperSQL.RunProcLob("SubscribeSendSet", parameters);
if (parameters[15].Value == DBNull.Value)
{
id = 0;
}
else
{
id = Convert.ToInt32(parameters[15].Value);
}
return(b);
}
/// <summary>
/// 根据ID查询完整的信息
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Tz888.Model.SubscribeSet GetModels(int Id, out string infotypeid, out string htmlFile)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
Tz888.Model.SubscribeSet model = new Tz888.Model.SubscribeSet();
DataSet ds = DbHelperSQL.RunProcedure("SubscribeSetTab_GetListByID", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
model.InfoID = Convert.ToInt32(ds.Tables[0].Rows[0]["infoid"]);
model.LoginName = ds.Tables[0].Rows[0]["LoginName"].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.Title = ds.Tables[0].Rows[0]["Title"].ToString();
model.OtherCriter = ds.Tables[0].Rows[0]["OtherCriter"].ToString();
model.Promotioncount = ds.Tables[0].Rows[0]["Promotioncount"].ToString();
model.SubscribeCount = Convert.ToInt32(ds.Tables[0].Rows[0]["SubscribeCount"]);
model.SubscribeOver = Convert.ToInt32(ds.Tables[0].Rows[0]["SubscribeOver"]);
model.ManageTypeId = ds.Tables[0].Rows[0]["ManageTypeId"].ToString();
model.SubscribeType = ds.Tables[0].Rows[0]["SubscribeType"].ToString();
infotypeid = ds.Tables[0].Rows[0]["infotypeid"].ToString();
htmlFile = ds.Tables[0].Rows[0]["htmlFile"].ToString();
return(model);
}
else
{
htmlFile = "";
infotypeid = "";
return(null);
}
}
//推广设置
public bool SendSet(Tz888.Model.SubscribeSet model)
{
SqlParameter[] parameters =
{
new SqlParameter("@InfoID", SqlDbType.BigInt, 8),
new SqlParameter("@Title", SqlDbType.VarChar, 50),
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@objectGradeID", SqlDbType.VarChar, 40),
new SqlParameter("@objectNeed", SqlDbType.VarChar, 100),
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, 500),
new SqlParameter("@SubscribeType", SqlDbType.Char, 10),
new SqlParameter("@SubscribeCount", SqlDbType.Int, 4),
};
parameters[0].Value = model.InfoID;
parameters[1].Value = model.Title;
parameters[2].Value = model.LoginName;
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.SubscribeType;
parameters[12].Value = model.SubscribeCount;
bool b = DbHelperSQL.RunProcLob("SubscribeSendSet", parameters);
return(b);
}
/// <summary>
/// 推广设置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool SendSet1(Tz888.Model.SubscribeSet model, out int id)
{
return(dal.SendSet1(model, out id));
}
/// <summary>
/// 推广设置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool SendSet(Tz888.Model.SubscribeSet model)
{
return(dal.SendSet(model));
}
