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();
}