public static int Delete(string FID)
{
string sql = string.Format("DELETE FROM MDS_IMP_DATA_SCRIPT_RULE WHERE FID='{0}'", FID);
return(OracleHelper.Excuse(sql));
}
public static int Release(string fid)
{
string sql = string.Format("UPDATE MDS_IMP_DATA_SCRIPT SET RELEASE='02' WHERE FID='{0}'", fid);
return(OracleHelper.Excuse(sql));
}
public static int updateInvalid(string fid, int Invalid)
{
string sql = string.Format("UPDATE MDS_IMP_DATA_SCRIPT SET INVALID={1} WHERE FID='{0}'", fid, Invalid);
return(OracleHelper.Excuse(sql));
}
public static int CheckCode(string code)
{
string sql = string.Format("SELECT COUNT(MIDS_SCRIPT_CODE) FROM MDS_IMP_DATA_SCRIPT WHERE MIDS_SCRIPT_CODE='{0}'", code);
return(Convert.ToInt32(OracleHelper.Scalar(sql).ToString()));
}
public static int updateLevel(string fid, string level)
{
string sql = string.Format("UPDATE MDS_IMP_DATA_SCRIPT SET MIDS_SCRIPT_VERSION='{1}' WHERE FID='{0}'", fid, level);
return(OracleHelper.Excuse(sql));
}