private void Frm_cuspro_Load(object sender, EventArgs e)
{
DataTable da1 = new DataTable();
da1.Columns.Add("ID", typeof(String));
da1.Columns.Add("Name", typeof(String));
DataTable data = new DataTable();
var db = gen.GetNewEntity(); // khai bao new entity Framework
{
var query = db.Branches
.Where(p => p.CompanyCode == Globals.companycode)
.Select(p => new { p.BranchID, p.BranchName })
.ToList();
data = gen.ConvertToDataTable(query);
}
for (int i = 0; i < data.Rows.Count; i++)
{
da1.Rows.Add(new String[] { data.Rows[i][0].ToString(), data.Rows[i][1].ToString() });
}
cbbranch.DataSource = da1;
cbbranch.DisplayMember = "Name";
cbbranch.ValueMember = "ID";
//clsItem cls;
DataTable da2 = new DataTable();
DataTable dapro = new DataTable();
//dapro = gen.GetTable("select * from Province order by ProvinceName");
var db2 = gen.GetNewEntity(); // khai bao new entity Framework
{
var query = db2.Provinces
.Select(p => new { p.ProvinceID, p.ProvinceName })
.ToList();
dapro = gen.ConvertToDataTable(query);
}
da2.Columns.Add("ID", Type.GetType("System.String"));
da2.Columns.Add("Name", Type.GetType("System.String"));
for (int i = 0; i < dapro.Rows.Count; i++)
{
DataRow dr = da2.NewRow();
dr[0] = dapro.Rows[i][0].ToString();
dr[1] = dapro.Rows[i][1].ToString();
da2.Rows.Add(dr);
}
// XtraMessageBox.Show(dapro.Rows.Count + dapro.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cbprovince.DataSource = da2;
cbprovince.DisplayMember = "Name";
cbprovince.ValueMember = "ID";
if (active == "1")
{
this.Text = "Sửa khách hàng, nhà cung cấp";
txtma.ReadOnly = true;
DataTable da = new DataTable();
// da = gen.GetTable("select * from AccountingObject where AccountingObjectID = '" + role + "'");
var ctx = gen.GetNewEntity(); // khai bao new entity Framework;
var stdId = Guid.Parse(role);
var query = ctx.AccountingObjects
.Where(c => c.CompanyCode == Globals.companycode && c.AccountingObjectID == stdId)
.OrderBy(x => x.AccountingObjectName);
foreach (var data2 in query)
{
txtma.Text = data2.AccountingObjectCode;
txttc.Text = data2.AccountingObjectName;
txtdc.Text = data2.Address;
txtmst.Text = data2.CompanyTaxCode;
txtdt.Text = data2.Tel;
txtfax.Text = data2.Fax;
txtwweb.Text = data2.Website;
txtemail.Text = data2.EmailAddress;
txttknh.Text = data2.BankAccount;
txtnh.Text = data2.BankName;
txtdg.Text = data2.Description;
txtsntd.Text = data2.MaximizeDebtAmount.ToString();
txthn.Text = data2.DueTime.ToString();
txttencon.Text = data2.ContactName;
txtcdcon.Text = data2.ContactTitle;
txtdccon.Text = data2.ContactAddress;
txtdtcq.Text = data2.ContactOfficeTel;
txtdtnr.Text = data2.ContactHomeTel;
txtdtdd.Text = data2.ContactMobile;
txtemailcon.Text = data2.ContactEmail;
txtscmnd.Text = data2.IdentificationNumber;
try
{
dateTimePicker1.Value = Convert.ToDateTime(data2.IssueDate);
}
catch { }
if (data2.IsVendor == data2.IsCustomer)
{
rbkhncc.Checked = true;
khtemp = "True";
ncctemp = "True";
}
else
{
rbncc.Checked = (bool)data2.IsVendor;
rbkh.Checked = (bool)data2.IsCustomer;
ncctemp = data2.IsVendor.ToString();
khtemp = data2.IsCustomer.ToString();
}
chbntd.Checked = (bool)data2.Inactive;
for (int i = 0; i < data.Rows.Count; i++)
{
if (data2.BranchID == Guid.Parse(data.Rows[i][0].ToString()))
{
cbbranch.SelectedIndex = i;
}
}
if (data2.IsPersonal == true)
{
rbcn.Checked = true;
}
for (int i = 0; i < dapro.Rows.Count; i++)
{
if (data2.Province == dapro.Rows[i][0].ToString())
{
cbprovince.SelectedIndex = i;
}
}
for (int i = 0; i < cbdistrist.Items.Count; i++)
{
clsItem cls1 = (clsItem)cbdistrist.Items[i];
string tt = cls1.PstrValue;
if (data2.District == tt)
{
cbdistrist.SelectedIndex = i;
}
}
}
}
else
{
this.Text = "Thêm khách hàng, nhà cung cấp";
rbkhncc.Checked = true;
rbtc.Checked = true;
}
}
private void Frm_nhanvien_Load(object sender, EventArgs e)
{
DataTable da1 = new DataTable();
da1.Columns.Add("ID", typeof(String));
da1.Columns.Add("Name", typeof(String));
DataTable data = new DataTable();
//data = gen.GetTable("select branchCode, branchName,branchID from Branch");
var db = gen.GetNewEntity(); // khai bao new entity Framework
{
var query = db.Branches
.Where(p => p.CompanyCode == Globals.companycode)
.Select(p => new { p.BranchID, p.BranchName })
.ToList();
data = gen.ConvertToDataTable(query);
}
for (int i = 0; i < data.Rows.Count; i++)
{
da1.Rows.Add(new String[] { data.Rows[i][0].ToString(), data.Rows[i][1].ToString() });
}
cbbranch.DataSource = da1;
cbbranch.DisplayMember = "Name";
cbbranch.ValueMember = "ID";
rbmale.Checked = true;
if (active == "1")
{
this.Text = "Sửa nhân viên";
txtma.ReadOnly = true;
DataTable da = new DataTable();
var ctx = gen.GetNewEntity(); // khai bao new entity Framework;
var stdId = Guid.Parse(role);
var query = ctx.AccountingObjects
.Join(ctx.Branches, a => a.BranchID, b => b.BranchID,
(a, b) => new {
a.AccountingObjectID, a.AccountingObjectCode, a.AccountingObjectName,
a.Inactive, b.BranchName,
a.CompanyCode,
a.IsEmployee, a.ContactSex, a.EmployeeBirthday, a.IssueDate, a.CompanyTaxCode, a.IdentificationNumber, a.IssueBy,
a.FamilyDeductionAmount, a.SalaryScaleID, a.BankAccount, a.BankName, a.Address, a.ContactAddress, a.ContactHomeTel,
a.ContactMobile, a.ContactEmail, a.ContactTitle, a.IsCustomer, a.IsVendor, a.IsPersonal, a.BranchID
}
)
.Where(c => c.CompanyCode == Globals.companycode && c.AccountingObjectID == stdId)
.OrderBy(x => new { x.BranchName, x.AccountingObjectName });
//da = gen.GetTable("select * from AccountingObject where AccountingObjectID = '" + role + "'");
foreach (var data2 in query)
{
txtma.Text = data2.AccountingObjectCode;
txtname.Text = data2.AccountingObjectName;
if (data2.ContactSex == 0)
{
rbfemale.Checked = true;
}
try
{
dtborn.Value = Convert.ToDateTime(data2.EmployeeBirthday);
}
catch { }
try
{
dtngaycap.Value = Convert.ToDateTime(data2.IssueDate);
}
catch { }
txtmst.Text = data2.CompanyTaxCode;
txtcmnd.Text = data2.IdentificationNumber;
txtnoicap.Text = data2.IssueBy;
txtgtgc.Text = data2.FamilyDeductionAmount.ToString();
try
{
string[] s = data2.SalaryScaleID.ToString().Split('.');
txthsl.Text = s[0] + "." + s[1].Substring(0, 4);
}
catch { }
txttknh.Text = data2.BankAccount;
txtnh.Text = data2.BankName;
txtdc.Text = data2.Address;
txtdtcq.Text = data2.ContactAddress;
txtdtnr.Text = data2.ContactHomeTel;
txtdtdd.Text = data2.ContactMobile;
txtemail.Text = data2.ContactEmail;
txtcv.Text = data2.ContactTitle;
chbkh.Checked = (bool)data2.IsCustomer;
chncc.Checked = (bool)data2.IsVendor;
chbntd.Checked = (bool)data2.IsPersonal;
for (int i = 0; i < data.Rows.Count; i++)
{
if (data2.BranchID == Guid.Parse(data.Rows[i][0].ToString()))
{
cbbranch.SelectedIndex = i;
}
}
}
}
}
private void Frm_branch_Load(object sender, EventArgs e)
{
DataTable da = new DataTable();
DataTable temp1 = new DataTable();
temp1.Columns.Add("Mã tỉnh");
temp1.Columns.Add("Tên tỉnh");
da = gen.GetTable("select * from Province order by ProvinceName");
for (int i = 0; i < da.Rows.Count; i++)
{
DataRow dr = temp1.NewRow();
dr[0] = da.Rows[i][1].ToString();
dr[1] = da.Rows[i][2].ToString();
temp1.Rows.Add(dr);
}
leprovince.Properties.DataSource = temp1;
leprovince.Properties.ValueMember = "Mã tỉnh";
leprovince.Properties.DisplayMember = "Tên tỉnh";
leprovince.EditValue = "CT";
radioButton1.Checked = true;
DataTable dt1 = new DataTable();
DataTable temp9 = gen.GetTable("select InventoryCategoryCode as 'Mã ngành',InventoryCategoryName as 'Tên ngành' from InventoryItemCategory where IsParent=0 and Grade=3 order by InventoryCategoryCode");
dt1.Columns.Add("Mã ngành", Type.GetType("System.String"));
dt1.Columns.Add("Tên ngành", Type.GetType("System.String"));
dt1.Columns.Add("Hạn mức", Type.GetType("System.Double"));
for (int i = 0; i < temp9.Rows.Count; i++)
{
DataRow dr = dt1.NewRow();
dr[0] = temp9.Rows[i][0].ToString();
dr[1] = temp9.Rows[i][1].ToString();
dt1.Rows.Add(dr);
}
DAT.DataSource = dt1;
ViewDAT.OptionsBehavior.Editable = true;
ViewDAT.Columns["Mã ngành"].OptionsColumn.AllowEdit = false;
ViewDAT.Columns["Tên ngành"].OptionsColumn.AllowEdit = false;
ViewDAT.Columns["Hạn mức"].OptionsColumn.AllowEdit = true;
ViewDAT.Columns["Hạn mức"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
ViewDAT.Columns["Hạn mức"].DisplayFormat.FormatString = "{0:n0}";
ViewDAT.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
if (active == "1")
{
this.Text = "Sửa đơn vị";
//da = gen.GetTable("select * from Branch where BranchID='" + role + "'");
Guid branchid = Guid.Parse(role);
var ctx = gen.GetNewEntity();
var query = ctx.Branches
.Where(c => c.BranchID == branchid).OrderBy(c => c.BranchCode);
foreach (var data in query)
{
txtcode.Text = data.BranchCode;
txtname.Text = data.BranchName;
txtdg.Text = data.Description;
if (data.IsDependent == true)
{
radioButton1.Checked = true;
}
else
{
radioButton2.Checked = true;
}
}
DataTable temp = new DataTable();
var query1 = ctx.Branches
.Where(p => p.CompanyCode == Globals.companycode && p.BranchCode != txtcode.Text)
.Select(p => new { p.BranchCode, p.BranchName })
.ToList();
temp = gen.ConvertToDataTable(query1);
ledv.Properties.DataSource = temp;
ledv.Properties.ValueMember = "BranchCode";
ledv.Properties.DisplayMember = "BranchCode";
//stock
var query2 = ctx.Stocks.Where(c => c.CompanyCode == Globals.companycode)
.Select(c => new { c.StockCode, c.StockName })
.ToList();
temp = gen.ConvertToDataTable(query2);
lekho.Properties.DataSource = temp;
lekho.Properties.ValueMember = "StockCode";
lekho.Properties.DisplayMember = "StockCode";
foreach (var data in query)
{
if (data.Parent != null)
{
string dv = gen.GetString("select BranchCode from Branch where BranchID='" + data.Parent.ToString() + "'");
ledv.EditValue = dv;
}
if (data.StockBranch != null)
{
string dv = gen.GetString("select StockCode from Stock where StockID='" + data.StockBranch + "'");
lekho.EditValue = dv;
}
leprovince.EditValue = data.Province;
txtmst.Text = data.Code; // ma so thue
}
}
else
{
this.Text = "Thêm đơn vị";
//da = gen.GetTable("select BranchCode,BranchName from Branch");
//chuyen sang dung kieu moi
var db = gen.GetNewEntity(); // khai bao new entity Framework
{
var query = db.Branches
.Where(p => p.CompanyCode == Globals.companycode)
.Select(p => new { p.BranchCode, p.BranchName })
.ToList();
da = gen.ConvertToDataTable(query);
}
ledv.Properties.DataSource = da;
ledv.Properties.ValueMember = "BranchCode";
ledv.Properties.DisplayMember = "BranchCode";
da = gen.GetTable("select StockCode,StockName from Stock");
lekho.Properties.DataSource = da;
lekho.Properties.ValueMember = "StockCode";
lekho.Properties.DisplayMember = "StockCode";
lekho.ItemIndex = 0;
}
}
