예제 #1
0
        public vmLSCurrentStock GetCurrentStock(vmSLCmnParameters objcmnParam)
        {
            GenericFactory_vmLSCurrentStock = new VmSLCurrentStock_VM();

            vmLSCurrentStock CurrentStock = null;
            string           spQuery      = string.Empty;

            try
            {
                using (_ctxCmn = new ERP_Entities())
                {
                    Hashtable ht = new Hashtable();
                    ht.Add("CompanyID", objcmnParam.CompanyID);
                    ht.Add("ItemID", objcmnParam.ItemID);
                    ht.Add("DepartmentID", objcmnParam.DepartmentID);
                    ht.Add("SupplierID", objcmnParam.SupplierID);
                    ht.Add("BatchID", objcmnParam.BatchID);
                    ht.Add("GradeID", objcmnParam.GradeID);
                    ht.Add("LotID", objcmnParam.LotID);

                    spQuery      = "[Get_LSCurrentStock]";
                    CurrentStock = GenericFactory_vmLSCurrentStock.ExecuteQuerySingle(spQuery, ht);
                }
            }
            catch (Exception e)
            {
                e.ToString();
            }
            return(CurrentStock);
        }
        public IHttpActionResult GetCurrentStock(object[] data)
        {
            vmLSCurrentStock slCurrentStock = null;

            objLocalSalesDDDl = new CmnLocalSalesMgt();
            vmSLCmnParameters objcmnParam = JsonConvert.DeserializeObject <vmSLCmnParameters>(data[0].ToString());

            try
            {
                slCurrentStock = objLocalSalesDDDl.GetCurrentStock(objcmnParam);
            }
            catch (Exception e)
            {
                e.ToString();
            }
            return(Json(new
            {
                slCurrentStock
            }));
        }