private void btnNew_Click(object sender, EventArgs e) { SCIndexData obj = new SCIndexData(); obj.OID = newOid--; obj.IndexMonth = 0; obj.IndexYear = 0; obj.IndexValue = 0; dataTable = (DataTable)gridData.DataSource; if (dataTable == null || dataTable.Rows.Count <= 0) { dataTable = ObjectUtils.ConvertToDataTable(new List <SCIndexData> { obj }); gridData.DataSource = dataTable; } else { DataRow drToAdd = dataTable.NewRow(); drToAdd[Constant.OID] = obj.OID; drToAdd["IndexYear"] = obj.IndexYear; drToAdd["IndexMonth"] = obj.IndexMonth; drToAdd["IndexValue"] = obj.IndexValue; dataTable.Rows.Add(drToAdd); dataTable.AcceptChanges(); } gridData.Refresh(); }
public void addSupplierCbx() { bool flag = false; foreach (DataGridViewColumn dc in headerControl1.dgvSubcontract.Columns) { if (dc.Name == "colSupplier") { flag = true; break; } } if (!flag) { ls = SubContractorContract.getSuppliers(); if (ls.Count > 0) { DataTable dt = new DataTable(); dt = ObjectUtils.ConvertToDataTable(ls); DataGridViewComboBoxColumn cb = new DataGridViewComboBoxColumn(); cb.HeaderText = "Supplier"; cb.FlatStyle = FlatStyle.Flat; cb.Name = "colSupplier"; cb.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; cb.DataSource = dt; cb.DataPropertyName = "SuplNoVal"; cb.ValueMember = "strValue1"; cb.DisplayMember = "strText"; cb.DisplayIndex = 0; cb.DisplayStyle = DataGridViewComboBoxDisplayStyle.DropDownButton; headerControl1.dgvSubcontract.Columns.Add(cb); } } }
private void loaddata() { SCBase sb = new SCBase(); datasource = sb.getContractTypes(); this.dt = ObjectUtils.ConvertToDataTable(datasource); contractTypeList.DataSource = this.dt; }
private void loadInvoiceDetail(int invoiceID) { List <SCInvoiceItem> lstInvoiceDetail = SCInvoiceUtil.getInvoiceDetail(invoiceID); DataTable dataTable = ObjectUtils.ConvertToDataTable(lstInvoiceDetail); gridLines.DataSource = dataTable; // gridLines.Refresh(); }
private DataTable searchEmployee(string key) { DataTable dt = new DataTable(); List <SCViewEmployee> result = new List <SCViewEmployee>(); result = SCViewEmployee.seach(key); dt = ObjectUtils.ConvertToDataTable(result); return(dt); }
private void Form1_Load(object sender, EventArgs e) { SCBase sb = new SCBase(); datasource = sb.getContractTypes(); this.dt = ObjectUtils.ConvertToDataTable(datasource); contractTypeList.DataSource = this.dt; this.Visible = true; }
private DataTable LoadVehicle(string key) { DataTable dt = new DataTable(); List <ContractVehicle> result = new List <ContractVehicle>(); result = ContractVehicle.seach(key); dt = ObjectUtils.ConvertToDataTable(result); return(dt); }
private DataTable LoadSCViewWorks(string key) { DataTable dt = new DataTable(); List <SCViewWorks> result = new List <SCViewWorks>(); result = SCViewWorks.seach(key); dt = ObjectUtils.ConvertToDataTable(result); return(dt); }
private DataTable loadMileage(ContractVehicle contractVehicle) { List <VehicleMileage> ret = new List <VehicleMileage>(); DataTable dt = new DataTable(); List <VehicleMileage> Mileages = contractVehicle.Mileages; // MessageBox.Show(Mileages.Count.ToString()); dt = ObjectUtils.ConvertToDataTable(Mileages); return(dt); }
public void loadDataGrid() { if (sCBase == null) { sCBase = new SCBase(); } buildTable(); fillToListOptionDetail(); dataTable = ObjectUtils.ConvertToDataTable(listOptionDetail); dataGridView1.DataSource = dataTable; }
private void loadData() { newOid = -1; listDataChange = new List <SCIndexData>(); gridData.DataSource = null; listData = SCIndexData.getIndexData(); if (listData == null) { listData = new List <SCIndexData>(); } dataTable = ObjectUtils.ConvertToDataTable(listData); gridData.DataSource = dataTable; }
private void fillRisk() { List <ZSC_SubcontractorContractRisk> lstContractRisk = ContractFrm.objContract.loadZSC_SubcontractorContractRisk(); dataTable = ObjectUtils.ConvertToDataTable(lstContractRisk); //Add Column subcontracter List <SubContractorContract> SubContracts = ContractFrm.objContract.SubContracts; List <ZSC_SubcontractorContractRisk> listRiskSub = null; foreach (SubContractorContract subContract in SubContracts) { dataTable.Columns.Add("sub" + subContract.OID, typeof(Int32)); } ZSC_SubcontractorContractRisk contractRisk = null; foreach (SubContractorContract subContract in SubContracts) { listRiskSub = ZSC_SubcontractorContractRisk.getContractRiskBySub(ContractFrm.objContract.ContractOID, subContract.OID); if (listRiskSub.Count > 0) { foreach (DataRow row in dataTable.Rows) { contractRisk = null; contractRisk = listRiskSub.SingleOrDefault(s => s.RiskPartnerCustId == Int32.Parse(row["RiskPartnerCustId"].ToString())); if (contractRisk != null) { row["sub" + subContract.OID] = contractRisk.RiskLevel; } else { row["sub" + subContract.OID] = 0; } } } else { foreach (DataRow row in dataTable.Rows) { row["sub" + subContract.OID] = 0; } } } }
public void loadData() { ls = CollectiveContract.searchSelfContract(ContractFrm.objContract.ContractCustId.CustId, ContractFrm.objContract.ContractOID); if (ls != null && ls.Count > 0) { DataTable dt = ObjectUtils.ConvertToDataTable(ls); if (dt != null) { this.dataGridView1.DataSource = dt; } } //bool tmp = checkColumnSelect(); //if (!tmp) //{ // addCheckColumn(); //} }
public void fillDataGrid(List <SCInvoice> lstContractInvoice) { DataTable dataTable = ObjectUtils.ConvertToDataTable(lstContractInvoice); gridInvoice.DataSource = dataTable; //ThuyetLV: Load detail cho Invoice dau tien if (lstContractInvoice.Count > 0) { SCInvoice item = lstContractInvoice[0]; loadInvoiceDetail(item.OID); } else { //Clear invoice detail loadInvoiceDetail(-1); } }
public static DataTable LoadGridMileage(ContractVehicle contractVehicle) { DataTable dt = new DataTable(); List <VehicleMileage> Mileages = contractVehicle.Mileages; System.Diagnostics.Debug.WriteLine("---------------------LoadGridMileage: " + Mileages.Count + " - " + contractVehicle.VehiId); if (Mileages.Count > 0) { System.Diagnostics.Debug.WriteLine("---------------------Mileages data: " + Mileages[0].MileageDate + " - " + Mileages[0].Mileage + " - " + Mileages[0].InputType); } else { System.Diagnostics.Debug.WriteLine("---------------------Mileages data emplty "); } dt = ObjectUtils.ConvertToDataTable(Mileages); System.Diagnostics.Debug.WriteLine("---------------------LoadGridMileage DataTable: " + dt.Rows.Count); return(dt); }
private void loadDataGrid(Int32 contactId) { //Clear list item thay doi ma chua save if (scPriceListChange != null && scPriceListChange.Count > 0) { scPriceListChange.Clear(); } //Clear data gridPrice.DataSource = null; if (contactId > 0) { //Load data List <Model.SCOptionPrice> listData = new Model.SCContractType().getOptionPriceList(contactId); //sCOptionPriceBindingSource.DataSource = listData; DataTable dataTable = ObjectUtils.ConvertToDataTable(listData); gridPrice.DataSource = dataTable; //gridPrice.Refresh();; } }
private void button1_Click(object sender, EventArgs e) { SCContractRemark sc = new SCContractRemark(); sc.OID = newOid; sc.ContractOID = ContractFrm.objContract.ContractOID; //sc.UserId = ""; sc.RemarkType = 0; sc.Info = ""; this.dataTable = null; this.dataTable = (DataTable)gridMark.DataSource; if (dataTable == null || dataTable.Rows.Count <= 0) { this.dataTable = ObjectUtils.ConvertToDataTable(new List <SCContractRemark> { sc }); gridMark.DataSource = dataTable; } else { DataRow drToAdd = this.dataTable.NewRow(); drToAdd[Constant.OID] = sc.OID; drToAdd["ContractOID"] = sc.ContractOID; drToAdd["UserId"] = sc.UserId; drToAdd["RemarkType"] = sc.RemarkType; drToAdd["Info"] = sc.Info; dataTable.Rows.Add(drToAdd); dataTable.AcceptChanges(); } buildGrid(); gridMark.Refresh(); newOid--; }
public void loadRemark(List <SCContractRemark> listData) { dataTable = ObjectUtils.ConvertToDataTable(listData); gridMark.DataSource = dataTable; buildGrid(); }