/// <summary>
/// 链接类别审核
/// </summary>
/// <param name="LinkInfo">Model.Link.LinkInfoTab</param>
/// <returns></returns>
public bool UpdateTypeById(Tz888.Model.Link.LinkTypeTab LinkType)
{
string sql = "update LinkTypeTab set LinkName=@LinkName,CheckId=@CheckId,Remarks=@Remarks where LinkId=@LinkId";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@LinkName", SqlDbType.VarChar, 50),
new SqlParameter("@CheckId", SqlDbType.VarChar, 50),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 100),
new SqlParameter("@LinkId", SqlDbType.Int, 4)
};
Paras[0].Value = LinkType.LinkName;
Paras[1].Value = LinkType.CheckId;
Paras[2].Value = LinkType.Remarks;
Paras[3].Value = LinkType.LinkId;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加链接类别
/// </summary>
/// <param name="LinkTypeTab">类别</param>
/// <returns></returns>
public bool AddType(Tz888.Model.Link.LinkTypeTab LinkType)
{
string sql = "insert into LinkTypeTab(LinkName,CheckId,Remarks) values(@LinkName,@CheckId,@Remarks)";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@LinkName", SqlDbType.VarChar, 50),
new SqlParameter("@CheckId", SqlDbType.VarChar, 50),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 100)
};
Paras[0].Value = LinkType.LinkName;
Paras[1].Value = LinkType.CheckId;
Paras[2].Value = LinkType.Remarks;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加链接类别
/// </summary>
/// <param name="LinkTypeTab">类别</param>
/// <returns></returns>
public bool AddType(Tz888.Model.Link.LinkTypeTab Type)
{
return(dal.AddType(Type));
}
/// <summary>
/// 链接类别审核
/// </summary>
/// <param name="LinkInfo">Model.Link.LinkInfoTab</param>
/// <returns></returns>
public bool UpdateTypeById(Tz888.Model.Link.LinkTypeTab LinkType)
{
return(dal.UpdateTypeById(LinkType));
}
