/// <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); } }
/// <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); }