public int AddSubjectExtend(SubjectExtendModel model)
{
int rowsAffected;
int num = 0;
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", SqlDbType.VarChar, 50),
new SqlParameter("@SubTitle", SqlDbType.NVarChar, 500),
new SqlParameter("@Remark", SqlDbType.NVarChar, 4000),
new SqlParameter("@Audit", SqlDbType.Int, 4),
new SqlParameter("@Source", SqlDbType.Int, 4),
new SqlParameter("@HtmlUrl", SqlDbType.NVarChar, 200),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@SubType", SqlDbType.Int, 4),
new SqlParameter("@SubTime", SqlDbType.DateTime),
new SqlParameter("@LinkMan", SqlDbType.VarChar, 50),
new SqlParameter("@Phone", SqlDbType.VarChar, 50),
new SqlParameter("@Picture", SqlDbType.NVarChar, 1000)
};
parameters[0].Value = model.LoginName;
parameters[1].Value = model.SubTitle;
parameters[2].Value = model.Remark;
parameters[3].Value = model.Audit;
parameters[4].Value = model.Source;
parameters[5].Value = model.HtmlUrl;
parameters[6].Value = model.Sort;
parameters[7].Value = model.SubType;
parameters[8].Value = model.SubTime;
parameters[9].Value = model.LinkMan;
parameters[10].Value = model.Phone;
parameters[11].Value = model.Picture;
num = crm.RunProcedure("SP_SubjectExtendTab_Add", parameters, out rowsAffected);
return(num);
}
public SubjectExtendModel SelSubject(int id)
{
SubjectExtendModel model = new SubjectExtendModel();
string sql = "select SubID,LoginName,SubTitle,Remark,Audit,Source,HtmlUrl,Sort,SubType,SubTime,LinkMan,Phone,Picture from SubjectExtendTab where SubID=@id ";
SqlParameter[] para =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
para[0].Value = id;
DataSet ds = crm.Query(sql, para);
if (ds != null & ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SubID"].ToString() != "")
{
model.SubID = int.Parse(ds.Tables[0].Rows[0]["SubID"].ToString()); //主键
}
model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString(); //用户名
model.SubTitle = ds.Tables[0].Rows[0]["SubTitle"].ToString(); //专题标题
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); //专题说明
if (ds.Tables[0].Rows[0]["Audit"].ToString() != "")
{
model.Audit = int.Parse(ds.Tables[0].Rows[0]["Audit"].ToString());//审核状态
}
if (ds.Tables[0].Rows[0]["Source"].ToString() != "")
{
model.Source = int.Parse(ds.Tables[0].Rows[0]["Source"].ToString()); //来源
}
model.HtmlUrl = ds.Tables[0].Rows[0]["HtmlUrl"].ToString(); //访问地址
if (ds.Tables[0].Rows[0]["Sort"].ToString() != "")
{
model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString());//排序
}
if (ds.Tables[0].Rows[0]["SubType"].ToString() != "")
{
model.SubType = int.Parse(ds.Tables[0].Rows[0]["SubType"].ToString());//类型
}
if (ds.Tables[0].Rows[0]["SubTime"].ToString() != "")
{
model.SubTime = DateTime.Parse(ds.Tables[0].Rows[0]["SubTime"].ToString()); //发布时间
}
model.LinkMan = ds.Tables[0].Rows[0]["LinkMan"].ToString(); //联系人
model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString(); //联系人电话
model.Picture = ds.Tables[0].Rows[0]["Picture"].ToString(); //图片
return(model);
}
else
{
return(null);
}
}
public int ModfiySubjectExtend(SubjectExtendModel model, int id)
{
return(dal.ModfiySubjectExtend(model, id));
}
public int AddSubjectExtend(SubjectExtendModel model)
{
return(dal.AddSubjectExtend(model));
}
