获取库存结账日期

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：2

获取库存结账日期

string strSql = string.Format("SELECT max(FCLOSEDATE) as FCloseDate FROM {0} WHERE FORGID = @orgId AND FCATEGORY = 'STK' ", "T_STK_CLOSEPROFILE");
SqlParam sqlParam = new SqlParam("@orgId", DbType.Int64, orgId);
return DBUtils.ExecuteScalar(ctx, strSql, KDTimeZone.MaxSystemDateTime, sqlParam);