예제 #1
0
        /// <summary>
        /// 获取下达单配料状态
        /// 张镇波 2013-6-7
        /// </summary>
        /// <param name="ptID"></param>
        /// <returns></returns>
        public static int GetProduceTaskState(int ptID)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@ptID", ptID);
            DataTable dt = new DataTable();

            dt = YKDataClass.RunSqlProcForTable("W_GetProduceTaskState", ht);
            if (dt == null || dt.Rows.Count == 0)
            {
                return(0);
            }
            else
            {
                return(1);
            }
        }
예제 #2
0
        /// <summary>
        /// 获取最新的信息
        /// 张 2013-5-22
        /// </summary>
        /// <param name="eID"></param>
        /// <returns></returns>
        public static string GetNewestMessage(int eID)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@eID", eID);
            DataTable dt = new DataTable();

            dt = YKDataClass.RunSqlProcForTable("B_GetApproveMainListApproveNewest", ht);
            string message = "";

            if (dt.Rows.Count > 0)
            {
                string count  = dt.Rows.Count.ToString();
                string amID   = dt.Rows[0]["amID"].ToString();
                string writer = dt.Rows[0]["Writer"].ToString() + " " + dt.Rows[0]["WriteTime"].ToString().Substring(0, 16);
                string title  = dt.Rows[0]["Title"].ToString();

                message = "Approve#" + count + "#" + amID + "#" + writer + "#" + title;
            }
            return(message);
        }