//表体序列号 public static int GetBodyID() { string script = @"SELECT iChildId FROM ua_identity WHERE cVouchType = 'DISPATCH'"; Hashtable table = new Hashtable(); SqlHelperUtility.SqlHelpQueryOneLine(ConnString, script, table); return(int.Parse(table["iChildId"].ToString())); }
//存货名称 private static string Getcinvname(string cinvcode) { string script = @"SELECT cInvName FROM Inventory WHERE cInvCode ='" + cinvcode + "'"; Hashtable table = new Hashtable(); SqlHelperUtility.SqlHelpQueryOneLine(Program.ConnectionString, script, table); return(table["cInvName"].ToString()); }
//表头序列号 public static int GetHeadID() { //cAcc_id = '003' AND string script = @"SELECT iFatherId FROM ua_identity WHERE cVouchType = 'DISPATCH'"; Hashtable table = new Hashtable(); SqlHelperUtility.SqlHelpQueryOneLine(ConnString, script, table); return(int.Parse(table["iFatherId"].ToString())); }