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