private void Frm_TransactionMaintain_Load(object sender, EventArgs e)
{
//load combobox module
load_module();
txtSQL.Visible = false;
txtTransactionCode.Enabled = false;
txtTransactionCode.Text = tcode;
if (active == "1")
{
this.Text = "Modify transaction";
var ctx = gen.GetNewEntity(); // khai bao new entity Framework
var data = ctx.Transactions.FirstOrDefault(c => c.TransactionCode == txtTransactionCode.Text);
if (data != null)
{
txtFormName.Text = data.FormName;
txtTransactionName.Text = data.TransactionName;
txtSortNo.Text = data.SortNo.ToString();
txtIsParent.Text = data.IsParent.ToString();
txtIsDisplay.Text = data.IsDisplay.ToString();
txtRoleCode.Text = data.RoleCode;
txtParentFolder.Text = data.ParentFolder;
txtIsDynamic.Text = data.IsDynamic.ToString();
txtProcedureName.Text = data.ProcedureName;
}
load_grid_item(); // table Transactions_DynamicReport
}
}
private void copyStock(string username1, string username2)
{
//copy Stock
var ctx = gen.GetNewEntity(); // khai bao new entity Framework
var query = ctx.UserJoinStocks
.Where(c => c.UserName == username1 && c.CompanyCode == Globals.companycode);
foreach (var data in query)
{
UserJoinStock obj = new UserJoinStock();
obj.StockCode = data.StockCode;
obj.UserName = username2;
obj.CompanyCode = data.CompanyCode;
ctx.UserJoinStocks.Add(obj); //insert
}
try
{
ctx.SaveChanges();
XtraMessageBox.Show("Copy stocks successfully", "Copy", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//catch (DbUpdateException ex) // exception khac
catch (DbUpdateConcurrencyException ex) // exception khac
{
XtraMessageBox.Show(ex.Message + ex.StackTrace + ex.TargetSite + ex.InnerException.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Frm_Demo2_Load(object sender, EventArgs e)
{
load_item();
// Load dữ liệu cho gridcontrol
var ctx = gen.GetNewEntity(); // khai bao new entity Framework
var dt = ctx.MMDocumentDetails.ToList();
gridControl1.DataSource = new BindingList <MMDocumentDetail>(dt);
}
private void load_grid_item()
{
var ctx = gen.GetNewEntity(); // khai bao new entity Framework
var dt = ctx.MMDocumentDetails
.Where(c => c.InventoryItemCode == InventoryItemCode && c.RefDate.Value.Year == FiscalYear && c.RefDate.Value.Month == FiscalPeriod && c.INOut == 1)
.ToList();
gridControl_Nhap.DataSource = new BindingList <MMDocumentDetail>(dt);
var dt2 = ctx.MMDocumentDetails
.Where(c => c.InventoryItemCode == InventoryItemCode && c.RefDate.Value.Year == FiscalYear && c.RefDate.Value.Month == FiscalPeriod && c.INOut == 0)
.ToList();
gridControl_Xuat.DataSource = new BindingList <MMDocumentDetail>(dt2);
}
private void btnContent_Click(object sender, EventArgs e)
{
if (txtTableName.Text == "")
{
XtraMessageBox.Show("Please enter the table name", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
// view content of a table
DataTable temp = new DataTable();
DataTable dt = new DataTable();
string code = txtTableName.Text;
SQLString = "SELECT name FROM sys.columns where object_id = OBJECT_ID('" + code + "')";
dt = gen.GetTable(SQLString);
int sum = dt.Rows.Count; // so cot trong table
if (sum > 10)
{
sum = 10;
}
for (int i = 0; i < sum; i++)
{
string name = dt.Rows[i][0].ToString();
temp.Columns.Add(name);
}
view.OptionsView.ColumnAutoWidth = true;
view.Columns.Clear();
var db = gen.GetNewEntity(); // khai bao new entity Framework
{
var select = from s in db.Accounts select s; // chua lay table name dong duoc
foreach (var data in select.Take(5))
{
DataRow dr = temp.NewRow();
dr[0] = data.AccountNumber;
dr[1] = data.AccountName;
temp.Rows.Add(dr);
}
}
lvpq.DataSource = temp;
view.OptionsBehavior.Editable = false;
view.OptionsSelection.EnableAppearanceFocusedCell = false;
view.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
//view.Columns[0].Visible = false;
view.OptionsView.ShowFooter = true;
view.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
view.Columns[1].SummaryItem.DisplayFormat = "Số dòng: {0}";
}
}
private void load_txtTableName()
{
DataTable temp2 = new DataTable();
temp2.Clear();
temp2.Columns.Add("Table Name");
var ctx3 = gen.GetNewEntity(); // khai bao new entity Framework
var query3 = ctx3.TableImports
.OrderBy(c => c.TableName);
foreach (var data in query3)
{
DataRow dr = temp2.NewRow();
dr[0] = data.TableName;
temp2.Rows.Add(dr);
}
txtTableName.Properties.DataSource = temp2;
txtTableName.Properties.DisplayMember = "Table Name";
txtTableName.Properties.ValueMember = "Table Name";
}
private void tsbtsave_Click(object sender, EventArgs e)
{
string tkth = "";
string stk = txtstk.Text;
string name = txtten.Text;
string namee = txttta.Text;
string ntk = cbntk.SelectedValue.ToString();
string dg = txtdg.Text;
string ntd = chbntd.Checked.ToString();
string tonquy = cbtonquy.Checked.ToString();
clsItem cls2 = (clsItem)cbnhomcp.SelectedItem;
string nhom = "0";
if (cbnhomcp.Text != "")
{
nhom = cls2.PstrValue;
}
clsItem cls1 = (clsItem)cbtc.SelectedItem;
string tc = cls1.PstrValue;
clsItem cls = (clsItem)cbdt.SelectedItem;
string dt = cls.PstrValue;
string chdt = chbdt.Checked.ToString();
string chcp = chbcp.Checked.ToString();
string chhd = chbhd.Checked.ToString();
string vthh = chbvthh.Checked.ToString();
string tknh = chtknh.Checked.ToString();
string ctnt = chbctnt.Checked.ToString();
string sql;
//update kieu moi
Account data = new Account();// lop Account
if (active == "0")
{
data.AccountID = Guid.NewGuid();// tao guiid moi
}
else
{
data.AccountID = Guid.Parse(role);
}
// AccountingObjectType='" + dt + "',DetailByBankAccount='" + tknh + "',Exits='" + tonquy + "',GroupCost='" + nhom + "' where AccountNumber='" + stk + "'";
data.AccountName = name;
data.AccountNameEnglish = namee;
data.Description = dg;
data.AccountCategoryID = ntk;
data.AccountCategoryKind = Int32.Parse(tc);
data.DetailByAccountingObject = chbdt.Checked;
data.DetailByInventoryItem = chbvthh.Checked;
data.DetailByJob = chbcp.Checked;
data.DetailByContract = chbhd.Checked;
data.Inactive = chbntd.Checked;
data.DetailByForeignCurrency = chbctnt.Checked;
data.AccountingObjectType = Int32.Parse(dt);
data.DetailByBankAccount = chtknh.Checked;
data.Exits = cbtonquy.Checked;
data.GroupCost = Int32.Parse(nhom);
data.AccountNumber = stk;
var db = gen.GetNewEntity(); // khai bao new entity Framework
{
try
{
if (active == "0")
{
db.Accounts.Add(data); //insert
}
else
{
db.Entry(data).State = System.Data.Entity.EntityState.Modified; // update
}
db.SaveChanges();
XtraMessageBox.Show("Submit successfully", "tsbtsave_Click", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//catch (DbUpdateException ex) // exception khac
catch (DbUpdateConcurrencyException ex) // exception khac
{
XtraMessageBox.Show(ex.Message + ex.StackTrace + ex.TargetSite + ex.InnerException.Message + active, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
//txtSQL.Text = ex.Message + data + active;
}
}
/*
* if (active == "1")
* {
*
* try
* {
* tkth = cbtkth.SelectedValue.ToString();
* sql = "update Account set AccountName=N'" + name + "',AccountNameEnglish=N'" + namee + "',Description=N'" + dg + "',AccountCategoryID='" + ntk + "',AccountCategoryKind='" + tc + "',DetailByAccountingObject='" + chdt + "',DetailByInventoryItem='" + vthh + "',DetailByJob='" + chcp + "',DetailByContract='" + chhd + "',Inactive='" + ntd + "',DetailByForeignCurrency='" + ctnt + "',AccountingObjectType='" + dt + "',DetailByBankAccount='" + tknh + "',Exits='" + tonquy + "',GroupCost='" + nhom + "' where AccountNumber='" + stk + "'";
* }
* catch
* {
* sql = "update Account set AccountName=N'" + name + "',AccountNameEnglish=N'" + namee + "',Description=N'" + dg + "',AccountCategoryID='" + ntk + "',ParentID=NULL,AccountCategoryKind='" + tc + "',DetailByAccountingObject='" + chdt + "',DetailByInventoryItem='" + vthh + "',DetailByJob='" + chcp + "',DetailByContract='" + chhd + "',Inactive='" + ntd + "',DetailByForeignCurrency='" + ctnt + "',AccountingObjectType='" + dt + "',DetailByBankAccount='" + tknh + "',Exits='" + tonquy + "',GroupCost='" + nhom + "' where AccountNumber='" + stk + "'";
* }
* account.checkaccount(name, sql, this);
* }
* else
* {
* sql = "insert into Account values(newid(),'" + stk + "',N'" + name + "','" + dg + "','" + role + "','" + lop + "','False','" + ntk + "','" + tc + "','" + chdt + "','" + vthh + "','" + chcp + "','" + chhd + "','False','" + ctnt + "','" + dt + "','" + tknh + "','" + namee + "','"+tonquy+"','"+nhom+"')";
* tkth = cbtkth.SelectedValue.ToString();
* account.checkaccount(name, sql, this);
* }*/
}
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_user_Load(object sender, EventArgs e)
{
txtSQL.Visible = false;
txtCompanyCode.ReadOnly = true;
txtInactive.ReadOnly = true;
//branch
load_ledv();
//kho
load_txtStockCode();
load_txtStockCode2();
// role
load_txtRole();
if (active == "1")
{
this.Text = "Sửa người dùng";
var ctx = gen.GetNewEntity(); // khai bao new entity Framework
var query = ctx.MSC_User
.Where(c => c.UserName == username && c.CompanyCode == Globals.companycode);
//da = gen.GetTable("select * from MSC_User where UserID = '" + role + "'");
foreach (var data in query)
{
txtuser.Text = data.UserName;
txtname.Text = data.FullName;
txtjob.Text = data.JobTitle;
txtdes.Text = data.Description;
txtInactive.Text = data.Inactive.ToString();
txtCompanyCode.Text = data.CompanyCode;
txtmail.Text = data.Email;
txtweb.Text = data.Website;
txtwphone.Text = data.WorkPhone;
txtphone.Text = data.MobilePhone;
txthphone.Text = data.HomePhone;
txtfax.Text = data.Fax;
txtwadress.Text = data.WorkAddress;
txthadress.Text = data.HomeAddress;
string dv = gen.GetString("select BranchCode from Branch where BranchID='" + data.BranchID.ToString() + "'");
ledv.EditValue = dv;
role = data.UserID.ToString(); // doi dang GUID --> string
password = data.Password;
}
load_lai_grid_kho();
load_lai_grid_kho2();
load_lai_grid_role();
}
else
{
this.Text = "Thêm người dùng";
txtCompanyCode.Text = Globals.companycode;
txtInactive.Text = "False";
txtuser.Text = username;
txtuser.ReadOnly = true;
}
}
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_stock_Load(object sender, EventArgs e)
{
DataTable daa = new DataTable();
DataTable temp1 = new DataTable();
temp1.Columns.Add("Mã tỉnh");
temp1.Columns.Add("Tên tỉnh");
var ctx = gen.GetNewEntity(); // khai bao new entity Framework;
//var query = from ctx.Province ;
var query = ctx.Provinces
.OrderBy(c => c.ProvinceName);
//.OrderBy(c => c.BranchCode);
//daa = gen.GetTable("select * from Province order by ProvinceName");
foreach (var data2 in query)
{
DataRow dr = temp1.NewRow();
dr[0] = data2.ProvinceCode;
dr[1] = data2.ProvinceName;
temp1.Rows.Add(dr);
}
leprovince.Properties.DataSource = temp1;
leprovince.Properties.ValueMember = "Mã tỉnh";
leprovince.Properties.DisplayMember = "Tên tỉnh";
leprovince.EditValue = "CT";
DataTable data = new DataTable();
DataTable da2 = new DataTable();
da2.Columns.Add("Mã kho");
da2.Columns.Add("Tên kho");
//data = gen.GetTable("select StockCode,StockName from Stock order by StockCode");
var query1 = ctx.Stocks
.OrderBy(c => c.StockCode)
.Select(c => new { c.StockCode, c.StockName });
foreach (var data2 in query1)
{
DataRow dr = da2.NewRow();
dr[0] = data2.StockCode;
dr[1] = data2.StockName;
da2.Rows.Add(dr);
}
lekho.Properties.DataSource = da2;
lekho.Properties.DisplayMember = "Mã kho";
lekho.Properties.ValueMember = "Mã kho";
DataTable da1 = new DataTable();
da1.Columns.Add("ID", typeof(String));
da1.Columns.Add("Name", typeof(String));
//data = gen.GetTable("select branchCode, branchName,branchID from Branch order by branchCode");
var query2 = ctx.Branches
.OrderBy(c => c.BranchCode);
//.Select(c => new { c.BranchCode, c.BranchName, c.BranchID });
/*for (int i = 0; i < data.Rows.Count; i++)
* {
* da1.Rows.Add(new String[] { data.Rows[i][0].ToString(), data.Rows[i][1].ToString() });
* }*/
foreach (var data2 in query2)
{
DataRow dr = da1.NewRow();
dr[0] = data2.BranchCode;
dr[1] = data2.BranchName;
da1.Rows.Add(dr);
}
cbbranch.Properties.DataSource = da1;
cbbranch.Properties.DisplayMember = "ID";
cbbranch.Properties.ValueMember = "ID";
if (active == "1")
{
this.Text = "Sửa kho";
txtcode.ReadOnly = true;
DataTable da = new DataTable();
//da = gen.GetTable("select * from Stock where StockID='" + role + "'");\
var db = gen.GetNewEntity(); // khai bao new entity Framework
{
Guid stockid = Guid.Parse(role);
var query3 = ctx.Stocks
.Where(c => c.StockID == stockid && c.CompanyCode == Globals.companycode)
.OrderBy(c => c.StockCode);
//da = gen.ConvertToDataTable(query3);
foreach (var data2 in query3)
{
txtcode.Text = data2.StockCode;
txtname.Text = data2.StockName;
txtdg.Text = data2.Description;
// string stockid = data2.StockID.ToString();
lekho.EditValue = gen.GetString2("Stock", "StockCode", "StockID", data2.StockID.ToString(), Globals.clientid);
cbbranch.EditValue = gen.GetString2("Branch", "BranchCode", "BranchID", data2.BranchID.ToString(), Globals.clientid);
chbntd.Checked = data2.Inactive;
LPG.Checked = (bool)data2.LPG;
leprovince.EditValue = data2.Province;
txtmst.Text = data2.Code;
txttcn.Text = data2.InvName;
txtnote.Text = data2.Note;
}
}
/*
* try
* {
* lekho.EditValue = gen.GetString("select StockCode from Stock where StockID='" + da.Rows[0][8].ToString() + "'");
* }
* catch
* {
* lekho.EditValue = da.Rows[0][1].ToString();
* }*/
/*for (int i = 0; i < data.Rows.Count; i++)
* {
* if (da.Rows[0][4].ToString() == data.Rows[i][2].ToString())
* cbbranch.SelectedIndex = i;
* }*/
}
else
{
this.Text = "Thêm kho";
lekho.ItemIndex = 0;
chbntd.Hide();
}
}
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;
}
}
private void load_topmenu()
{
// tao menu dua vao profile
barManager1.BeginUpdate();
Bar bar1 = new Bar(barManager1, "My MainMenu");
bar1.DockStyle = BarDockStyle.Top;
//bar1.DockRow = 0;
barManager1.MainMenu = bar1;
BarSubItem subMenuSystem = new BarSubItem(barManager1, "System");
BarButtonItem buttonOld = new BarButtonItem(barManager1, "Old version");
BarButtonItem buttonOpen = new BarButtonItem(barManager1, "Change Password");
BarButtonItem buttonExit = new BarButtonItem(barManager1, "Exit");
subMenuSystem.AddItems(new BarItem[] { buttonOld, buttonOpen, buttonExit });
//tao menu con trong profile UserJoinRole
SQLString = "select * from UserJoinRole where username='******'";
dt = gen.GetTable(SQLString);
for (int i = 0; i < dt.Rows.Count; i++)
{
string rcode = dt.Rows[i]["RoleCode"].ToString(); // rolecode
string rolename = gen.GetString2("Roles", "RoleName", "RoleCode", rcode);
BarSubItem subMenuFunctionsi = new BarSubItem(barManager1, rolename);
bar1.AddItems(new BarItem[] { subMenuFunctionsi });
// ung voi moi profile tao menu con transaction
try
{
var ctx = gen.GetNewEntity(); // khai bao new entity Framework
var query = ctx.Transactions
.Where(c => c.RoleCode == rcode && c.IsDisplay == 1 && c.IsParent == 0).OrderBy(c => c.SortNo); // khong co folder cha
foreach (var data in query)
{
string tcode = data.TransactionCode.Trim();
string TransactionName = data.TransactionName;
BarButtonItem buttonj = new BarButtonItem(barManager1, tcode + " - " + TransactionName);
subMenuFunctionsi.AddItems(new BarItem[] { buttonj });
}
}
catch
{
// MessageBox.Show(SQLString);
}
// hien tiep cac folder
DataTable dt2 = new DataTable();
SQLString = "select ParentFolder from Transactions where IsDisplay = 1 and IsParent = 1 and rolecode='" + rcode + "' group by ParentFolder";
dt2 = gen.GetTable(SQLString);
for (int j = 0; j < dt2.Rows.Count; j++)
{
string ParentFolder = dt2.Rows[j]["ParentFolder"].ToString();
BarSubItem subMenuFunctionsj = new BarSubItem(barManager1, ParentFolder);
subMenuFunctionsi.AddItems(new BarItem[] { subMenuFunctionsj });
// tao tiep transaction con
var ctx = gen.GetNewEntity(); // khai bao new entity Framework
var query = ctx.Transactions
.Where(c => c.RoleCode == rcode && c.IsDisplay == 1 && c.IsParent == 1 && c.ParentFolder == ParentFolder).OrderBy(c => c.SortNo);
foreach (var data in query)
{
string tcode = data.TransactionCode.Trim();
string TransactionName = data.TransactionName;
BarButtonItem buttonj = new BarButtonItem(barManager1, tcode + " - " + TransactionName);
subMenuFunctionsj.AddItems(new BarItem[] { buttonj });
}
}
}
//Add the sub-menus to the bar1
bar1.AddItems(new BarItem[] { subMenuSystem });
barManager1.ItemClick += new ItemClickEventHandler(barManager1_ItemClick);
barManager1.EndUpdate();
}
