//查询base_year是否有重复ICQ代码库根据id和name（修改）
public DataSet check_base_year_by_idandname(JObject json)
{
string sql = @"select * from base_year where name = '{0}' and id not in ('{1}') and kind = '{2}'";
sql = string.Format(sql, json.Value <string>("NAME"), json.Value <string>("ID"), (int)Base_YearKindEnum.CIQ);
return(DBMgrBase.GetDataSet(sql));
}
public DataSet check_sys_recordinfo(JObject json)
{
string sql = @"select * from SYS_RECORDINFO where code = '{0}'";
sql = string.Format(sql, json.Value <string>("CODE"));
return(DBMgrBase.GetDataSet(sql));
}
//查询base_year是否有重复HS代码库（新增）
public DataSet check_base_year(JObject json)
{
string sql = @"select * from base_year where name = '{0}' and kind = '{1}'";
sql = string.Format(sql, json.Value <string>("NAME"), (int)Base_YearKindEnum.HS);
return(DBMgrBase.GetDataSet(sql));
}