async void CreateQuotaField() { var query = DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControlValues_Get", new { AnswerID }); DataSet ds = Services.Execute(query); if (DependencyService.Get <IDataSetExtension>().IsNull(ds) == true) { await DisplayAlert("Lỗi load dữ liệu", this.Services.LastError, "Ok"); return; } foreach (DataRow r in tblQuotaControl.Rows) { string oldValue = FindValue(ds.Tables[0], "FieldName", r["FieldName"].ToString(), "FieldValue"); var control = new QuotaControl(r, oldValue); control.HorizontalOptions = LayoutOptions.FillAndExpand; control.Orientation = StackOrientation.Vertical; //layoutQuota.Children.Add(new QuotaControl(r, oldValue)); layoutQuota.Children.Add(control); } }
public async Task <ActionResult <Order> > ListItem(String order_id) { string sessionID = Request.Headers["Session-ID"]; ClientServices Services = new ClientServices(sessionID); var query = DataAccess.DataQuery.Create("dms", "ws_ordermasters_get", new { order_id }); query += DataAccess.DataQuery.Create("dms", "ws_orderdetails_list", new { order_id }); var ds = Services.Execute(query); if (ds == null) { return(BadRequest(Services.LastError)); } if (ds.Tables[0].Rows.Count == 0) { return(NotFound()); } var result = ds.Tables[0].ToModel <Order>()[0]; result.products = ds.Tables[1].ToModel <Product>(); return(result); }
public async Task <ActionResult <List <Order> > > getAll(string searchText = "", string filter = "[]") { string sessionID = Request.Headers["Session-ID"]; ClientServices Services = new ClientServices(sessionID); var query = DataAccess.DataQuery.Create("dms", "ws_ordermasters_list", new { filter_expression = filter == null ? "" : filter, search_text = searchText == null ? "" : searchText, }); var ds = Services.Execute(query); if (ds == null) { return(BadRequest(Services.LastError)); } return(ds.Tables[0].ToModel <Order>()); }
public async Task <ActionResult <string> > PostItem(string order_id, int status, string export_stock_id = "") { string sessionID = Request.Headers["Session-ID"]; ClientServices Services = new ClientServices(sessionID); DataAccess.RequestCollection query; if (status == 1) { query = DataAccess.DataQuery.Create("dms", "ws_ordermasters_export4order_approve", new { order_id = order_id, export_stock_id }); } else { if (status == 2) { query = DataAccess.DataQuery.Create("dms", "ws_ordermasters_export4order_cancel", new { order_id = order_id }); } else { return(BadRequest("Không tìm thấy status")); } } var ds = Services.Execute(query); if (ds == null) { return(BadRequest(Services.LastError)); } return("Ok"); }
async Task LoadRespondentList() { var query = DataAccess.DataQuery.Create("Docs", "ws_DOC_Answers_GetForWaitingMobile", new { ProjectID, UserID = Services.GetInformation("UserID").ToString() }); query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControl_Get", new { ProjectID }); query += DataAccess.DataQuery.Create("KadenceDB", "ws_L_WardDistrictCity_ListFromMobile", new { ProjectID, UserID = Services.GetInformation("UserID").ToString() }); query += DataAccess.DataQuery.Create("KadenceDB", "ws_HR_PTEProject_ListFromMobile", new { ProjectID, UserID = Services.GetInformation("UserID").ToString() }); var ds = Services.Execute(query); if (DependencyService.Get <IDataSetExtension>().IsNull(ds) == true) { await DisplayAlert("Lỗi load dữ liệu", Services.LastError, "Ok"); return; } gData.ItemsSource = ds.Tables[0]; tblQuota = ds.Tables[1]; tblHanhChanh = ds.Tables[2]; tblNhanSu = ds.Tables[3]; }
public async void btnLogin_Clicked(object sender, EventArgs args) { UserDialogs.Instance.ShowLoading("Đang đăng nhập..."); var query = DataAccess.DataQuery.Create("Security", "ws_Session_AuthenticateFromMobile", new { Username = txtUsername.Text.Trim(), PasswordHash = DependencyService.Get <IMd5HashExtensions>().GetMd5Hash(txtPassword.Text.Trim()), FacID = "1" }); var ds = Services.Execute(query); if (DependencyService.Get <IDataSetExtension>().IsNull(ds) == true) { UserDialogs.Instance.HideLoading(); await DisplayAlert("Lỗi đăng nhập", Services.LastError, "Thử lại"); return; } if (ds.Tables[0].Rows.Count == 0) { UserDialogs.Instance.HideLoading(); await DisplayAlert("Lỗi phân quyền", "Bạn chưa được phân quyền dự án", "Thử lại"); return; } if (ds.Tables[0].Rows[0][0].ToString().ToUpper() != "OK") { UserDialogs.Instance.HideLoading(); await DisplayAlert("Lỗi đăng nhập", ds.Tables[0].Rows[0][0].ToString().ToUpper(), "Thử lại"); return; } Services.SetInformation("UserID", ds.Tables[0].Rows[0]["UserID"].ToString()); if (chkRememberPassword.Checked == true) { await Save(txtUsername.Text.Trim(), txtPassword.Text.Trim()); } else { await Save("", ""); } //if(Authenticated!=null) // { // Authenticated(this, null); // } if (ds.Tables[0].Rows.Count == 1) { //await DisplayAlert("Dự án", string.Format("Bạn đang thực hiện dự án {0}",ds.Tables[0].Rows[0]["ProjectName"].ToString()), "Ok"); Services.SetInformation("MinYOB", ds.Tables[0].Rows[0]["MinYOB"]); Services.SetInformation("ProjectNo", ds.Tables[0].Rows[0]["ProjectNo"]); Services.SetInformation("ProjectName", ds.Tables[0].Rows[0]["ProjectNo"]); Services.SetInformation("MaxYOB", ds.Tables[0].Rows[0]["MaxYOB"]); Services.SetInformation("AcceptGender", ds.Tables[0].Rows[0]["AcceptGender"]); Services.SetInformation("MonthICMA", ds.Tables[0].Rows[0]["MonthICMA"]); Services.SetInformation("CityHandle", ds.Tables[0].Rows[0]["CityHandle"]); var row = ds.Tables[0].Rows[0]; var homePage = new TabbedPage(); var _RespondentProfileListPage = new RespondentProfileListPage(Services, row["ProjectID"].ToString()); homePage.Children.Add(_RespondentProfileListPage); homePage.Children.Add(new QuotaControlPage(Services, row["ProjectID"].ToString())); homePage.CurrentPageChanged += (object obj, EventArgs evt) => { var i = homePage.Children.IndexOf(homePage.CurrentPage); if (i == 0) { (homePage.CurrentPage as RespondentProfileListPage).Process(); } if (i == 1) { (homePage.CurrentPage as QuotaControlPage).Process(); } }; Application.Current.MainPage = new NavigationPage(homePage); } else { var page = new ProjectListPage(Services, ds.Tables[0]); Application.Current.MainPage = new NavigationPage(page); } UserDialogs.Instance.HideLoading(); }
private static void Run(string[] args) { SplashScreenManager.ShowForm(typeof(SplashScreen)); var services = new ClientServices(); services.SetInformation("FacID", QA.QAFunction.ReadFromConfigXMlFile("FacID")); services.Initialize(); using (var frm = new frmLogin()) { frm.Initialize(services); frm.Process(); SplashScreenManager.CloseForm(); if (frm.ShowDialog() != DialogResult.OK) { return; } //UserID = frm.UserID; //UserName = frm.UserName; } services.LoadPermissions(services.GetInformation("FacID").ToString()); string ProjectID = "", ProjectNo = ""; var query = DataAccess.DataQuery.Create("KadenceDB", "ws_HR_UserProjectPermissions_Get", new { UserID = services.GetInformation("UserID"), IsFWSupInterview = 0, IsFWSupRecuit = 1, IsQC = 0, Type = 1 }); var ds = services.Execute(query); if (ds == null) { UI.ShowError(services.LastError); return; } if (ds.FirstTable().Rows.Count == 1) { ProjectID = ds.FirstRow().Item("ProjectID"); ProjectNo = ds.FirstRow().Item("ProjectNo"); } else { if (ds.FirstTable().Rows.Count < 1) { UI.ShowError("Bạn không có dự án nào"); return; } else { using (var frm = new frmProjectList()) { frm.Initialize(services); frm.InitializeDataSource = ds.FirstTable(); frm.Process(); if (frm.ShowDialog() == DialogResult.OK) { ProjectID = frm.SelectedProjectID; ProjectNo = frm.SelectedProjectNo; } } } } //SplashScreenManager.ShowForm(typeof(SplashScreen)); // services.LoadSettings(); // Debug.WriteLine("Shell #4 : ClearReport"); // ReportUtility.ClearReports(); // Debug.WriteLine("Shell #5 : Opening Main form"); using (var frm = new frmQCRecall()) { frm.Text = String.Format("FW Assignment Bạn đang làm việc với dự án : {0}", ProjectNo); frm.ProjectID = ProjectID; frm.ProjectNo = ProjectNo; frm.Initialize(services); frm.Process(); //SplashScreenManager.CloseForm(); Application.Run(frm); } }
async Task LoadData() { //danh sach phieu Ok using (UserDialogs.Instance.Loading("Đang lấy dữ liệu quota")) { try { var CityHandle = Services.GetInformation("CityHandle"); var query = new DataAccess.RequestCollection(); int checkChecked = 0; int TypeView = 0; if (rRercuit.Checked == true) { TypeView = 1; checkChecked += 1; } if (rCLTRercuit.Checked == true) { TypeView = 2; checkChecked += 1; } if (rQC.Checked == true) { TypeView = 3; checkChecked += 1; } if (rInterview.Checked == true) { TypeView = 4; checkChecked += 1; } if (checkChecked != 1) { await DisplayAlert("Lỗi check option", Services.LastError, "Ok"); return; } //data quota value //query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControl_List", new //{ // ProjectID //}); ////data quota field name //query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControlValues_List", new //{ // ProjectID //}); //query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaConditionExpression_ListWithCityHandle", new //{ // ProjectID, // CityHandle=Services.GetInformation("CityHandle") //}); query = DataAccess.DataQuery.Create("Docs", "ws_DOC_Answers_ListCalculateQuotaWithCity", new { ProjectID, TypeView, CityHandle = CityHandle, IsAll = IsAll }); var ds = Services.Execute(query); if (DependencyService.Get <IDataSetExtension>().IsNull(ds) == true) { await DisplayAlert("Lỗi load dữ liệu", Services.LastError, "Ok"); return; } gData.ItemsSource = ds.Tables[0]; //var tblProfile = ds.Tables[0]; //var tblQuotaValue = ds.Tables[2]; //var tblQuotaField = ds.Tables[1]; //var tblExpression = ds.Tables[3]; //foreach (DataRow row in tblQuotaField.Rows) //{ // tblProfile.Columns.Add(row["FieldName"].ToString().ToUpper(), typeof(String)); //} //foreach (DataRow row in tblProfile.Rows) //{ // for (int i = 0; i < row.ItemArray.Length; i++) // { // string AnswerID = row["AnswerID"].ToString(); // string columnName = row.Table.Columns[i].ColumnName.ToString().ToUpper(); // if (IsFieldQuota(columnName, tblQuotaField) == true) // { // row[i] = FindValue(tblQuotaValue, AnswerID, "FieldName", columnName, "FieldValue"); // } // } //} //foreach (DataRow row in tblExpression.Rows) //{ // string queryCondition = row["ConditionExpression"].ToString(); // var items = DependencyService.Get<IDataTableExtension>().SelectQuery(tblProfile, queryCondition); // int currentCount = items.Length; // row["CurrentCount"] = currentCount; // int minValue = (int)row["MinValue"]; // int maxValue = (int)row["MaxValue"]; // if (currentCount <= minValue && minValue != maxValue) // row["NeedQty"] = String.Format("Còn {0}-{1}", minValue - currentCount, maxValue - currentCount); // if (currentCount <= minValue && minValue == maxValue) // row["NeedQty"] = String.Format("Còn {0}", minValue - currentCount); // if (currentCount > minValue && minValue == maxValue) // row["NeedQty"] = String.Format("Dư {0}", currentCount - minValue); // if (currentCount > minValue && minValue != maxValue && currentCount <= maxValue) // row["NeedQty"] = String.Format("Dư +{0}", maxValue - currentCount); // if (currentCount > minValue && minValue != maxValue && currentCount > maxValue) // row["NeedQty"] = String.Format("Dư +{0}", currentCount - maxValue); //} //gData.ItemsSource = tblExpression; } catch (Exception ex) { await DisplayAlert(ex.StackTrace.ToString(), ex.Message, "Ok"); return; } } }