public ActionResult GetpageE(Int64?purch_id)
{
ProcurementResult com = new ProcurementResult();
string exmsg = string.Empty;
List <ProcurementModelE> mylist = _service.GetProcurementEList(out exmsg, purch_id.Value);
if (!string.IsNullOrEmpty(exmsg))
{
com.Msg = exmsg;
com.success = false;
return(Json(com));
}
else
{
ProcurementViewModelE mylistview = new ProcurementViewModelE();
mylistview.supplist = mylist;
com.DataResult = mylistview;
com.success = true;
return(Json(com));
}
}
// GET: Sections/Procurement
public ActionResult Index()
{
int siteCoID = base.siteusercompanyid;
if (TempData["SyncSuccessMessage"] != null)
{
ViewBag.SyncSuccessMessage = TempData["SyncSuccessMessage"];
TempData.Remove("SyncSuccessMessage");
}
if (TempData["SyncErrorMessage"] != null)
{
ViewBag.SyncErrorMessage = TempData["SyncErrorMessage"];
TempData.Remove("SyncErrorMessage");
}
ViewBag.VendorList = db.GetVendorsByPors(siteusercompanyid).Where(s => s.Vendor != null && s.Vendor.Trim() != "").ToList();
ViewBag.JobList = db.GetProjectsByPors(siteusercompanyid).ToList();
ViewBag.StatusList = db.GetStatusByPors(siteusercompanyid).ToList();
ViewBag.SelectPORList = db.GetPorNumberByPors(siteCoID).ToList();
ProcurementResult result = new ProcurementResult();
result.PurchaseList = db.GetPurchasingBySiteCoID(siteCoID).ToList();
result.CustodyList = db.GetCustodyBySiteCoID(siteCoID).ToList();
result.DeliveryList = db.GetDeliveriesBySiteCoID(siteCoID).ToList();
result.TransferList = db.GetTransfersBySiteCoID(siteCoID).ToList();
result.PendingList = db.GetPendingBySiteCoID(siteCoID).ToList();
result.InventoryList = db.GetInventoryBySiteCoID(siteCoID).ToList();
qbModels = new QBModels();
qbModels.SyncObjectsModel = new QBSyncdto();
qbModels.OAuthorizationModel = new QBAuthorizationdto();
qbModels.IsReadySync = false;
var oAuthModel = new QBOAuthService(qbModels.OAuthorizationModel).IsTokenAvailable(this, siteusercompanyid);
if (oAuthModel.IsConnected)
{
ViewBag.IsQBConnected = true;
}
return(View(result));
}
public ActionResult Getpage(string pagenum, string onepagecount, int?type, string purch_code, string OrderCode, string express_code, string supp_name)
{
ProcurementResult com = new ProcurementResult();
if (!Regex.IsMatch(pagenum, @"(?i)^[0-9a-z\u4e00-\u9fa5]+$") && !string.IsNullOrEmpty(pagenum))
{
com.Msg = "页数不正确";
com.success = false;
return(Json(com));
}
if (!Regex.IsMatch(onepagecount, @"(?i)^[0-9a-z\u4e00-\u9fa5]+$") && !string.IsNullOrEmpty(onepagecount))
{
com.Msg = "每页数量不正确";
com.success = false;
return(Json(com));
}
int totil = 0;
int totilpage = 0;
string exmsg = string.Empty;
List <ProcurementModel> mylist = _service.GetProcurementList(Convert.ToInt32(pagenum), Convert.ToInt32(onepagecount), out totil, out totilpage, out exmsg, type, purch_code, OrderCode, express_code, supp_name);
if (!string.IsNullOrEmpty(exmsg))
{
com.Msg = exmsg;
com.success = false;
return(Json(com));
}
else
{
ProcurementViewModel mylistview = new ProcurementViewModel();
mylistview.supplist = mylist;
mylistview.totil = totil.ToString();
mylistview.totilcount = totilpage.ToString();
com.DataResult = mylistview;
com.success = true;
return(Json(com));
}
}
public ActionResult Index(string SearchText, string SelectedType, string SelectedVendors, string SelectedJobs, string SelectedStatus = "", string SelectedPOR = "")
{
int siteCoID = base.siteusercompanyid;
if (TempData["SyncSuccessMessage"] != null)
{
ViewBag.SyncSuccessMessage = TempData["SyncSuccessMessage"];
TempData.Remove("SyncSuccessMessage");
}
if (TempData["SyncErrorMessage"] != null)
{
ViewBag.SyncErrorMessage = TempData["SyncErrorMessage"];
TempData.Remove("SyncErrorMessage");
}
ViewBag.VendorList = db.GetVendorsByPors(siteusercompanyid).Where(s => s.Vendor != null && s.Vendor.Trim() != "").ToList();
ViewBag.JobList = db.GetProjectsByPors(siteusercompanyid).ToList();
ViewBag.StatusList = db.GetStatusByPors(siteusercompanyid).ToList();
ViewBag.SelectPORList = db.GetPorNumberByPors(siteCoID).ToList();
ProcurementResult result = new ProcurementResult();
var PurchaseList = db.GetPurchasingBySiteCoID(siteCoID).ToList();
if (SelectedType == "PO")
{
char[] sep = new char[] { ',' };
if (SelectedVendors != null && SelectedVendors != "")
{
PurchaseList = PurchaseList.Where(p => SelectedVendors.Split(sep).Contains(Convert.ToString(p.VendorID))).ToList();
}
if (SelectedJobs != null && SelectedJobs != "")
{
PurchaseList = PurchaseList.Where(p => SelectedJobs.Split(sep).Contains(Convert.ToString(p.ProjectID))).ToList();
}
if (SelectedStatus != null && SelectedStatus != "")
{
PurchaseList = PurchaseList.Where(p => SelectedStatus.Split(sep).Contains(Convert.ToString(p.StatusID))).ToList();
}
}
var CustodyList = db.GetCustodyBySiteCoID(siteCoID).ToList();
if (SelectedType == "Custody")
{
char[] sep = new char[] { ',' };
if (SelectedVendors != null && SelectedVendors != "")
{
CustodyList = CustodyList.Where(p => SelectedVendors.Split(sep).Contains(Convert.ToString(p.VendorID))).ToList();
}
if (SelectedJobs != null && SelectedJobs != "")
{
CustodyList = CustodyList.Where(p => SelectedJobs.Split(sep).Contains(Convert.ToString(p.ProjectID))).ToList();
}
if (SelectedPOR != null && SelectedPOR != "")
{
CustodyList = CustodyList.Where(p => SelectedPOR.Split(sep).Contains(Convert.ToString(p.PorID))).ToList();
}
}
result.DeliveryList = db.GetDeliveriesBySiteCoID(siteCoID).ToList();
result.TransferList = db.GetTransfersBySiteCoID(siteCoID).ToList();
result.PendingList = db.GetPendingBySiteCoID(siteCoID).ToList();
result.InventoryList = db.GetInventoryBySiteCoID(siteCoID).ToList();
result.CustodyList = CustodyList.ToList();
result.PurchaseList = PurchaseList.ToList();
qbModels = new QBModels();
qbModels.SyncObjectsModel = new QBSyncdto();
qbModels.OAuthorizationModel = new QBAuthorizationdto();
qbModels.IsReadySync = false;
var oAuthModel = new QBOAuthService(qbModels.OAuthorizationModel).IsTokenAvailable(this, siteusercompanyid);
if (oAuthModel.IsConnected)
{
ViewBag.IsQBConnected = true;
}
return(View(result));
}
