/// <summary>
/// 根据发票号查询发票单据信息
/// </summary>
/// <param name="cSBVCode">单据号</param>
/// <returns></returns>
public static DataTable GetSaleBillVouchByCSBVCode(string connectionString, string cSBVCode, out string errMsg)
{
DataTable dt = null;
errMsg = string.Empty;
//首先判断单据是否存在
string strSql = string.Format("IF EXISTS(SELECT 1 FROM SaleBillVouch WHERE cSBVCode='{0}') SELECT 1 ELSE SELECT 0", cSBVCode);
int result = Convert.ToInt32(DBHelperSQL.ExecuteScalar(connectionString, strSql));
if (result == 0)
{
errMsg = "单据不存在！";
return(dt);
}
//再判断单据是否审核
strSql = string.Format("IF EXISTS(SELECT 1 FROM SaleBillVouch WHERE cSBVCode='{0}' AND cVerifier IS NOT NULL AND dverifydate IS NOT NULL) SELECT 1 ELSE SELECT 0", cSBVCode);
result = Convert.ToInt32(DBHelperSQL.ExecuteScalar(connectionString, strSql));
if (result == 0)
{
errMsg = "单据未审核！";
return(dt);
}
strSql = string.Format("SELECT * FROM SaleBillVouch WHERE cSBVCode='{0}'", cSBVCode);
dt = DBHelperSQL.Query(connectionString, strSql).Tables[0];
return(dt);
}
/// <summary>
/// 根据存货编码，盘点单，批次信息查询盘点单详细
/// </summary>
/// <param name="barcode">存货编码</param>
/// <param name="cCVCode">盘点单</param>
/// <param name="cCVBatch">批次</param>
/// <param name="connectionString">链接字符串</param>
/// <param name="qty"></param>
/// <param name="sqty"></param>
/// <param name="autoid"></param>
/// <param name="cinvname">存货名称</param>
/// <param name="cinvdefine1">生产厂家</param>
/// <param name="cinvstd">规格</param>
/// <param name="cinvdefine6">产地</param>
/// <returns></returns>
public static int getQtyByBarcode(string barcode, string cCVCode, ref string cCVBatch, string connectionString,
out string qty, out string sqty, out string autoid, out string cinvname, out string cinvdefine1, out string cinvstd, out string cinvdefine6, out string errMsg)
{
string sql = "";
DataSet ds = null;
errMsg = string.Empty;
qty = "";
sqty = "";
autoid = "";
cinvname = "";
cinvdefine1 = "";
cinvstd = "";
cinvdefine6 = "";
sql = "select a.iCVQuantity,a.autoid,a.ccvbatch,i.cinvname,i.cinvdefine1,i.cInvStd,i.cinvdefine6 from checkvouchs a "
+ " join inventory i on i.cinvcode=a.cinvcode "
+ "join checkvouch b on b.id=a.id and b.cCVCode='" + cCVCode + "' "
+ " and a.cinvcode='" + barcode + "'";
if (!cCVBatch.Equals(""))
{
sql = sql + " and a.cCVBatch = '" + cCVBatch + "'";
}
//OperationSql.GetDataset(sql, connectionString, out ds, out errMsg);
ds = DBHelperSQL.Query(connectionString, sql);
if (ds != null && ds.Tables[0].Rows.Count == 0)
{
string _invname = null;
sql = "select cinvname from inventory where cinvcode='" + barcode + "'";
//OperationSql.GetString(sql, connectionString, out _invname, out errMsg);
_invname = DBHelperSQL.ExecuteScalar(connectionString, sql).ToString();
if (_invname == null || _invname.Length < 1)
{
errMsg = "该产品条码有误!";
return(-1);
}
sqty = "0";
autoid = "0";
cinvname = _invname;
errMsg = "该产品不属于该盘点单!";
return(-1);
}
sqty = ds.Tables[0].Rows[0][0].ToString();
autoid = ds.Tables[0].Rows[0][1].ToString();
cCVBatch = ds.Tables[0].Rows[0][2].ToString();
cinvname = ds.Tables[0].Rows[0][3].ToString();
cinvdefine1 = ds.Tables[0].Rows[0][4].ToString(); //生产厂家
cinvstd = ds.Tables[0].Rows[0][5].ToString(); //批次
cinvdefine6 = ds.Tables[0].Rows[0][6].ToString(); //产地
return(0);
}
