/*ดึงเลขที่ใบเบิกโอนสาขาใหม่*/ private String getSaleAppHeadId(Class.clsDatabase cls) { String sql = "SELECT isnull(SUBSTRING((SELECT MAX(TranferReqHeadId)FROM TranferReqHead),1,6) ,'') ," + "isnull(SUBSTRING((SELECT MAX(TranferReqHeadId)FROM TranferReqHead),7,3),'') ," + "(SELECT CONVERT(VARCHAR(6),GETDATE(),12))"; DataTable dt = cls.QueryDataTable(sql); String id0 = "", id1 = "", id2 = ""; id0 = dt.Rows[0][0].ToString().Trim(); id1 = dt.Rows[0][1].ToString().Trim(); id2 = dt.Rows[0][2].ToString().Trim(); if (id0 == "" || id0 != id2) { return id2 + "001"; } String n = (Convert.ToInt16(id1) + 1) + ""; for (int i = n.Length; i < 3; i++) { n = "0" + n; } return id2 + n; }