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));
        }
Beispiel #2
0
        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));
        }
Beispiel #3
0
        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));
        }
Beispiel #4
0
        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()));
        }
Beispiel #5
0
        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));
        }