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