public int AddSysApi(SysApiEntity model) { string sql = "INSERT INTO SysApi(AppId,ApiName,ApiType,ApiDescription,ApiOwner,ApiAddress,ApiStatus,Remark,AddTime) VALUES(@AppId,@ApiName,@ApiType,@ApiDescription,@ApiOwner,@ApiAddress,@ApiStatus,@Remark,GETDATE())"; using (var conn = new SqlConnection(ConnectionStr.FxDb)) { conn.Open(); return(conn.Execute(sql, model)); } }
public int UpdateSysApi(SysApiEntity model) { string sql = "UPDATE SysApi SET AppId=@AppId,ApiName=@ApiName,ApiType=@ApiType,ApiDescription=@ApiDescription,ApiOwner=@ApiOwner,ApiAddress=@ApiAddress,ApiStatus=@ApiStatus,Remark=@Remark WHERE SysApiId=@SysApiId "; using (var conn = new SqlConnection(ConnectionStr.FxDb)) { conn.Open(); return(conn.Execute(sql, model)); } }
public int AddSysApi(SysApiEntity model) { return(sysApiDal.AddSysApi(model)); }
public int UpdateSysApi(SysApiEntity model) { return(sysApiDal.UpdateSysApi(model)); }