//表体序列号
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()));
}
