private void Frm_phieuthuvt_Load(object sender, EventArgs e)
{
dt = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + roleid + "' and SubSystemCode='" + subsys + "'");
refreshrole();
if (pt == "pttmvt")
{
refeshpttmvt();
}
else if (pt == "ptnhvt")
{
labelControl1.Text = "Phiếu thu ngân hàng bán vật tư";
refeshptnhvt();
}
else if (pt == "pctmvt")
{
labelControl1.Text = "Phiếu chi tiền mặt mua vật tư";
refeshpctmvt();
}
else if (pt == "pcnhvt")
{
labelControl1.Text = "Phiếu chi ngân hàng mua vật tư";
refeshpcnhvt();
}
change();
load = "0";
radioGroup1.SelectedIndex = -1;
}
private void Frm_distrist_Load(object sender, EventArgs e)
{
clsItem cls;
DataTable da = new DataTable();
da = gen.GetTable("select * from Province order by ProvinceName");
for (int i = 0; i < da.Rows.Count; i++)
{
cls = new clsItem(da.Rows[i][0].ToString(), da.Rows[i][2].ToString());
cbprovince.Items.Add(cls);
}
cbprovince.DisplayMember = "PstrName";
cbprovince.ValueMember = "PstrValue";
cbprovince.SelectedIndex = 0;
if (active == "1")
{
DataTable data = new DataTable();
data = gen.GetTable("select * from Distrist where DistristID='" + role + "'");
txtcode.Text = data.Rows[0][1].ToString();
txtname.Text = data.Rows[0][2].ToString();
txtdg.Text = data.Rows[0][3].ToString();
for (int i = 0; i < da.Rows.Count; i++)
{
if (data.Rows[0][4].ToString() == da.Rows[i][0].ToString())
{
cbprovince.SelectedIndex = i;
}
}
}
}
public void layhoadon(string ngaychungtu, string mk, string branchid)
{
string sql = "select * from SSInvoice where Month(PURefDate)='" + DateTime.Parse(ngaychungtu).Month.ToString() + "' and Year(PURefDate)='" + DateTime.Parse(ngaychungtu).Year.ToString() + "' and BranchID='" + branchid + "' and AccountingObjectID='" + mk + "' order by RefNo";
DataTable dt = new DataTable();
DataTable temp = new DataTable();
view.Columns.Clear();
temp = gen.GetTable(sql);
dt.Columns.Add("ID", Type.GetType("System.String"));
dt.Columns.Add("Số chứng từ", Type.GetType("System.String"));
dt.Columns.Add("Hóa đơn", Type.GetType("System.String"));
dt.Columns.Add("Ngày chứng từ", Type.GetType("System.DateTime"));
dt.Columns.Add("Ngày hóa đơn", Type.GetType("System.DateTime"));
dt.Columns.Add("Số tiền", Type.GetType("System.Double"));
for (int i = 0; i < temp.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = temp.Rows[i][0].ToString();
dr[1] = temp.Rows[i][5].ToString();
dr[2] = temp.Rows[i][69].ToString();
dr[3] = temp.Rows[i][2].ToString();
dr[4] = temp.Rows[i][14].ToString();
Double cth, khautru, gtgt, tong, ck, chiphi;
cth = Double.Parse(temp.Rows[i][38].ToString());
ck = Double.Parse(temp.Rows[i][46].ToString());
chiphi = Double.Parse(temp.Rows[i][73].ToString());
khautru = Double.Parse(temp.Rows[i][44].ToString());
cth = cth - ck - khautru + chiphi;
gtgt = Double.Parse(temp.Rows[i][42].ToString());
tong = cth + gtgt;
dr[5] = tong;
dt.Rows.Add(dr);
}
lvpq.DataSource = dt;
view.BestFitColumns();
view.OptionsBehavior.Editable = false;
view.OptionsSelection.EnableAppearanceFocusedCell = false;
view.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
view.Columns[0].Visible = false;
view.Columns["Ngày chứng từ"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
view.Columns["Ngày chứng từ"].DisplayFormat.FormatString = "dd/MM/yyyy";
view.Columns["Ngày chứng từ"].Width = 100;
view.Columns["Ngày chứng từ"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
view.Columns["Ngày hóa đơn"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
view.Columns["Ngày hóa đơn"].DisplayFormat.FormatString = "dd/MM/yyyy";
view.Columns["Ngày hóa đơn"].Width = 100;
view.Columns["Ngày hóa đơn"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
view.Columns["Hóa đơn"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
view.Columns["Số tiền"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
view.Columns["Số tiền"].DisplayFormat.FormatString = "{0:n0}";
view.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
view.Columns[1].SummaryItem.DisplayFormat = "Số dòng: {0}";
view.Columns["Số chứng từ"].Width = 160;
view.Columns["Số tiền"].Width = 120;
}
private void ledt_EditValueChanged(object sender, EventArgs e)
{
try
{
DataTable da = new DataTable();
da = gen.GetTable("select * from AccountingObject where AccountingObjectCode='" + ledt.EditValue.ToString() + "'");
txtname.Text = da.Rows[0][2].ToString();
}
catch { }
}
private void Frm_iic_Load(object sender, EventArgs e)
{
DataTable da = new DataTable();
DataTable da1 = new DataTable();
da1.Columns.Add("ID", typeof(String));
da1.Columns.Add("Name", typeof(String));
DataTable data = new DataTable();
data = gen.GetTable("select * from InventoryItemCategory");
for (int i = 0; i < data.Rows.Count; i++)
{
da1.Rows.Add(new String[] { data.Rows[i][5].ToString(), data.Rows[i][6].ToString() });
}
cbloai.DataSource = da1;
cbloai.DisplayMember = "Name";
cbloai.ValueMember = "ID";
cbloai.SelectedIndex = -1;
if (role != "")
{
da = gen.GetTable("select * from InventoryItemCategory where InventoryCategoryID='" + role + "'");
for (int i = 0; i < data.Rows.Count; i++)
{
if (active == "1")
{
if (da.Rows[0][1].ToString() == data.Rows[i][0].ToString())
{
cbloai.SelectedIndex = i;
}
}
else
{
if (da.Rows[0][0].ToString() == data.Rows[i][0].ToString())
{
cbloai.SelectedIndex = i;
}
}
}
}
if (active == "1")
{
this.Text = "Sửa loại vật tư hàng hóa, công cụ dụng cụ";
txtcode.ReadOnly = true;
txtcode.Text = da.Rows[0][5].ToString();
txtname.Text = da.Rows[0][6].ToString();
checkBox1.Checked = (bool)da.Rows[0][9];
}
else
{
this.Text = "Thêm loại vật tư hàng hóa, công cụ dụng cụ";
}
}
public void getkhachhang()
{
DataTable dt = new DataTable();
DataTable temp = new DataTable();
string thang = DateTime.Parse(ngaychungtu).Month.ToString();
string nam = DateTime.Parse(ngaychungtu).Year.ToString();
view.Columns.Clear();
temp = gen.GetTable("select b.AccountingObjectID,b.AccountingObjectCode,b.AccountingObjectName,EmployeeCode,EmployeeName,EmployeeID from ((select * from (select distinct AccountingObjectID from HACHTOAN where MONTH(CABA)='" + thang + "' and YEAR(CABA)='" + nam + "' and StockID='" + kho + "' and (DebitAccount='131' or CreditAccount='131')) a left join (select AccountingObjectID as AccountingObject ,EmployeeCode,EmployeeName,EmployeeID from SalaryList where StockID='" + kho + "' and Months='" + thang + "' and Years='" + nam + "') b on a.AccountingObjectID=b.AccountingObject)) a, AccountingObject b where a.AccountingObjectID=b.AccountingObjectID order by b.AccountingObjectCode");
dt.Columns.Add("ID", Type.GetType("System.String"));
dt.Columns.Add("Mã khách hàng", Type.GetType("System.String"));
dt.Columns.Add("Tên khách hàng", Type.GetType("System.String"));
dt.Columns.Add("Mã nhân viên", Type.GetType("System.String"));
dt.Columns.Add("Tên nhân viên", Type.GetType("System.String"));
dt.Columns.Add("Chọn", Type.GetType("System.Boolean"));
dt.Columns.Add("ID nhân viên", Type.GetType("System.String"));
for (int i = 0; i < temp.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = temp.Rows[i][0].ToString();
dr[1] = temp.Rows[i][1].ToString();
dr[2] = temp.Rows[i][2].ToString();
dr[3] = temp.Rows[i][3].ToString();
dr[4] = temp.Rows[i][4].ToString();
dr[5] = "False";
if (temp.Rows[i][3].ToString() != "")
{
dr[5] = "True";
}
dr[6] = temp.Rows[i][5].ToString();
dt.Rows.Add(dr);
}
gridControl1.DataSource = dt;
view.Columns["Mã khách hàng"].OptionsColumn.AllowEdit = false;
view.Columns["Tên khách hàng"].OptionsColumn.AllowEdit = false;
view.Columns["Mã nhân viên"].OptionsColumn.AllowEdit = false;
view.Columns["Tên nhân viên"].OptionsColumn.AllowEdit = false;
view.Columns["Chọn"].OptionsColumn.AllowEdit = false;
view.Columns[0].Visible = false;
view.Columns[6].Visible = false;
view.Columns["Chọn"].Width = 100;
view.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
view.Columns[1].SummaryItem.DisplayFormat = "Số dòng: {0}";
}
private void Frm_hoadonxhgb_Load(object sender, EventArgs e)
{
refreshrole();
dt = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + roleid + "' and SubSystemCode='" + subsys + "'");
refreshhdmh();
change();
}
private void gridView1_Click(object sender, EventArgs e)
{
if (gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.FocusedColumn).ToString() != "")
{
string ngay = DateTime.Parse(thang + "/" + gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.FocusedColumn).ToString() + "/" + nam).ToString();
if (tsbt == "tsbtbktdng")
{
Frm_rpcongno rp = new Frm_rpcongno();
rp.getngaychungtu(ngay);
rp.gettsbt(tsbt);
rp.Show();
}
else if (tsbt == "tsbtpttm")
{
DataSet ds = new DataSet();
ds.Tables.Add(gen.GetTable("select RefNo as 'Số phiếu',b.CustomField5 as 'Số phiếu đơn vị',DebitAccount as 'TK nợ',CreditAccount as 'TK có',d.AccountingObjectCode as 'Người nộp',d.AccountingObjectName as 'Tên người nộp',b.JournalMemo as 'Lý do',c.AccountingObjectCode as 'Đối tượng',c.AccountingObjectName as 'Tên đối tượng',Amount as 'Số tiền',b.Contactname as 'Đội',Note as 'Ghi chú' from CAReceiptDetail a, CAReceipt b, AccountingObject c, AccountingObject d where b.AccountingObjectID=d.AccountingObjectID and a.AccountingObjectID=c.AccountingObjectID and a.RefID=b.RefID and Cast(RefDate as date)= cast('" + ngay + "' as date) and b.StockID in (select StockID from MSC_UserJoinStock where UserID='" + userid + "') order by RefNo,d.AccountingObjectCode,c.AccountingObjectCode"));
gen.CreateExcel(ds, "Bangkephieuthu_" + String.Format("{0:dd-MM-yyyy}", DateTime.Parse(ngay)) + ".xlsx");
}
else if (tsbt == "bctqtkho")
{
Frm_rpcongno F = new Frm_rpcongno();
F.gettsbt(tsbt);
F.getngaychungtu(ngay);
F.getkho(kho);
F.ShowDialog();
}
else
{
thtk.loadton(gridView1, account, accountname, tsbt, ngay);
}
}
}
private void Frm_phieunhaphangbantralai_Load(object sender, EventArgs e)
{
dt = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + roleid + "' and SubSystemCode='" + subsys + "'");
refreshrole();
refreshpxhmtl();
change();
}
public void loaddistrist(DevExpress.XtraGrid.GridControl lvpq, DevExpress.XtraGrid.Views.Grid.GridView view)
{
string sql = "select DistristID,DistristCode,DistristName,a.Description,ProvinceName from Distrist a, Province b where a.ProvinceID=b.ProvinceID order by ProvinceName";
DataTable dt = new DataTable();
DataTable temp = new DataTable();
view.Columns.Clear();
temp = gen.GetTable(sql);
dt.Columns.Add("ID", Type.GetType("System.String"));
dt.Columns.Add("Mã Quận/Huyện", Type.GetType("System.String"));
dt.Columns.Add("Tên Quận/Huyện", Type.GetType("System.String"));
dt.Columns.Add("Tên Tỉnh/Thành", Type.GetType("System.String"));
dt.Columns.Add("Diễn giải", Type.GetType("System.String"));
for (int i = 0; i < temp.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = temp.Rows[i][0].ToString();
dr[1] = temp.Rows[i][1].ToString();
dr[2] = temp.Rows[i][2].ToString();
dr[3] = temp.Rows[i][4].ToString();
dr[4] = temp.Rows[i][3].ToString();
dt.Rows.Add(dr);
}
lvpq.DataSource = dt;
view.OptionsBehavior.Editable = false;
view.OptionsSelection.EnableAppearanceFocusedCell = false;
view.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
view.Columns[0].Visible = false;
view.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
view.Columns[1].SummaryItem.DisplayFormat = "Số dòng: {0}";
}
private void btnContent_Click(object sender, EventArgs e)
{
gridControl1.Visible = true;
SQLString = "select a.UserID,a.UserName,a.FullName, a.Email, a.JobTitle,a.Inactive,b.BranchName from MSC_User a, Branch b ";
SQLString += " where a.BranchID = b.BranchID and a.CompanyCode = '" + Globals.companycode + "'";
gridView1.OptionsView.ColumnAutoWidth = true;
DataTable dt = new DataTable();
DataTable temp = new DataTable();
gridView1.Columns.Clear();
try
{
temp = gen.GetTable(SQLString);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "btnContent_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtSQL.Text = SQLString;
}
txtSQL.Visible = true;
txtSQL.Text = SQLString;
dt.Columns.Add("UserID", Type.GetType("System.String"));
dt.Columns.Add("UserName", Type.GetType("System.String"));
dt.Columns.Add("Full Name", Type.GetType("System.String"));
dt.Columns.Add("Email", Type.GetType("System.String"));
dt.Columns.Add("Job Title", Type.GetType("System.String"));
dt.Columns.Add("Branch Name", Type.GetType("System.String"));
dt.Columns.Add("Is Lock", Type.GetType("System.Boolean"));
for (int i = 0; i < temp.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = temp.Rows[i].Field <Guid>("UserID").ToString();
dr[1] = temp.Rows[i].Field <string>("UserName").ToString();
dr[2] = temp.Rows[i].Field <string>("FullName");
dr[3] = temp.Rows[i].Field <string>("Email");
dr[4] = temp.Rows[i].Field <string>("JobTitle");
dr[5] = temp.Rows[i].Field <string>("BranchName");
dr[6] = temp.Rows[i].Field <bool>("Inactive");
if (temp.Rows[i].Field <bool>("Inactive") == true)
{
dr[6] = true;
}
else
{
dr[6] = false;
}
dt.Rows.Add(dr);
}
gridControl1.DataSource = dt;
gridView1.OptionsBehavior.Editable = false;
gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;
gridView1.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
gridView1.Columns[0].Visible = false;
gridView1.OptionsView.ShowFooter = true;
gridView1.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
gridView1.Columns[1].SummaryItem.DisplayFormat = "Số dòng: {0}";
}
private void Frm_baocaotaichinh_Load(object sender, EventArgs e)
{
if (tsbt == "tsbthdbhchange" || tsbt == "tsbtddhlpgchange")
{
labelControl11.Text = "Mã khách cũ";
labelControl1.Text = "Mã khách mới";
textEdit1.Visible = false;
searchLookUpEdit1.Visible = true;
if (tsbt == "tsbthdbhchange")
{
DataTable dulieu = gen.GetTable("select AccountingObjectCode,a.BranchID, PURefDate,a.TotalAmount-a.TotalDiscountAmount-a.TotalFreightAmount+a.TotalVATAmount from SSInvoice a, AccountingObject b where a.AccountingObjectID=b.AccountingObjectID and RefID='" + ID + "'");
txtsct.Text = dulieu.Rows[0][0].ToString();
makho = dulieu.Rows[0][1].ToString();
//ngaychungtu = dulieu.Rows[0][2].ToString();
congno = Double.Parse(dulieu.Rows[0][3].ToString());
donvi = gen.GetString("select BranchID from Stock where StockID='" + makho + "'");
}
else if (tsbt == "tsbtddhlpgchange")
{
txtsct.Text = gen.GetString("select AccountingObjectCode from INOutwardLPG a, AccountingObject b where a.AccountingObjectID=b.AccountingObjectID and RefID='" + ID + "'");
}
searchLookUpEdit1.Properties.View.Columns.Clear();
DataTable temp = new DataTable();
temp.Columns.Add("Mã khách");
temp.Columns.Add("Tên khách");
temp.Columns.Add("Địa chỉ");
temp.Columns.Add("Mã số thuế");
for (int i = 0; i < khach.Rows.Count; i++)
{
DataRow dr = temp.NewRow();
dr[0] = khach.Rows[i][1].ToString();
dr[1] = khach.Rows[i][2].ToString();
dr[2] = khach.Rows[i][3].ToString();
dr[3] = khach.Rows[i][4].ToString();
temp.Rows.Add(dr);
}
searchLookUpEdit1.Properties.DataSource = temp;
searchLookUpEdit1.Properties.DisplayMember = "Mã khách";
searchLookUpEdit1.Properties.ValueMember = "Mã khách";
searchLookUpEdit1.Focus();
}
else
{
txtsct.Text = textEdit1.Text = chungtu;
}
}
private void Frm_accountgroup_Load(object sender, EventArgs e)
{
radioButton1.Checked = true;
txtcode.ReadOnly = true;
DataTable da = new DataTable();
da = gen.GetTable("select * from AccountCategory where AccountCategoryID='" + role + "' ");
txtcode.Text = da.Rows[0][0].ToString();
txtname.Text = da.Rows[0][1].ToString();
clsItem cls;
cls = new clsItem("0", "Dư nợ");
cbtc.Items.Add(cls);
cls = new clsItem("1", "Dư có");
cbtc.Items.Add(cls);
cls = new clsItem("2", "Lưỡng tính");
cbtc.Items.Add(cls);
cls = new clsItem("3", "Không có số dư");
cbtc.Items.Add(cls);
cbtc.DisplayMember = "PstrName";
cbtc.ValueMember = "PstrValue";
cbtc.SelectedIndex = (int)da.Rows[0][2];
clsItem cls1;
cls1 = new clsItem("0", "Nhà cung cấp");
cbdt.Items.Add(cls1);
cls1 = new clsItem("1", "Khách hàng");
cbdt.Items.Add(cls1);
cls1 = new clsItem("2", "Nhân viên");
cbdt.Items.Add(cls1);
cbdt.DisplayMember = "PstrName";
cbdt.ValueMember = "PstrValue";
cbdt.SelectedIndex = (int)da.Rows[0][7];
int ch = 0;
for (int i = 1; i < 9; i++)
{
if (da.Rows[0][i].ToString() == "True")
{
ch = 1;
}
}
if (ch == 0)
{
cbct.Checked = true;
cbct.Checked = false;
}
else
{
cbct.Checked = true;
}
radioButton1.Checked = (bool)da.Rows[0][3];
radioButton2.Checked = (bool)da.Rows[0][5];
radioButton3.Checked = (bool)da.Rows[0][6];
radioButton4.Checked = (bool)da.Rows[0][4];
radioButton5.Checked = (bool)da.Rows[0][8];
}
private void lencc_EditValueChanged(object sender, EventArgs e)
{
DataTable da = gen.GetTable("select PolicyCode as 'Chính sách số',PolicyName as 'Nội dung' from Policy where (YEAR(BeginDate)='" + DateTime.Parse(ngaychungtu).Year + "' or YEAR(EndDate)='" + DateTime.Parse(ngaychungtu).Year + "') and PolicyCode=PolicyParent and InventoryItemCode='" + lencc.EditValue + "' order by PolicyCode");
lencs.Properties.DataSource = da;
lencs.Properties.DisplayMember = "Chính sách số";
lencs.Properties.ValueMember = "Chính sách số";
lencs.Properties.PopupWidth = 300;
lencs.ItemIndex = -1;
}
public void loadstock()
{
DataTable kho = new DataTable();
temp.Columns.Add("Mã kho");
temp.Columns.Add("Tên kho");
kho = gen.GetTable("select StockCode,StockName from Stock a order by StockCode");
for (int i = 0; i < kho.Rows.Count; i++)
{
DataRow dr = temp.NewRow();
dr[0] = kho.Rows[i][0].ToString();
dr[1] = kho.Rows[i][1].ToString();
temp.Rows.Add(dr);
}
ledv.Properties.DataSource = temp;
ledv.Properties.DisplayMember = "Mã kho";
ledv.Properties.ValueMember = "Mã kho";
ledv.Properties.PopupWidth = 300;
}
private void Frm_hdmhkpn_Load(object sender, EventArgs e)
{
txthttt.Text = "TM/CK";
dt = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + roleid + "' and SubSystemCode='" + subsys + "'");
refreshrole();
if (pt == "pxk")
{
refreshpxk();
labelControl1.Text = "Hóa đơn mua hàng kiêm phiếu nhập kho";
}
else if (pt == "hdmh")
{
refreshpxk();
txtddh.Text = phieu;
}
change();
load = "0";
radioGroup1.SelectedIndex = -1;
}
private void btnContent_Click(object sender, EventArgs e)
{
// view content
DataTable temp = new DataTable();
SQLString = "SELECT name FROM sys.columns where object_id = OBJECT_ID('" + code + "')";
dt = gen.GetTable(SQLString);
int sum = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
string name = dt.Rows[i][0].ToString();
temp.Columns.Add(name);
}
//content
SQLString = "SELECT * FROM " + code + " WHERE ClientID=" + Globals.clientid;
DataTable dt2 = new DataTable();
try
{
dt2 = gen.GetTable(SQLString);
for (int j = 0; j < dt2.Rows.Count; j++)
{
DataRow dr = temp.NewRow();
for (int i = 0; i < sum; i++)
{
dr[j + i] = dt2.Rows[j + i][i].ToString(); // dong j cot i
}
temp.Rows.Add(dr);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "btnContent_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtSQL.Visible = true;
txtSQL.Text = ex.ToString();
}
gridControl1.Visible = true;
gridControl1.DataSource = temp;
}
private void MSC_Load(object sender, EventArgs e)
{
SplashScreenManager.ShowForm(typeof(Frm_wait));
temp = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + role + "'");
int counttemp = temp.Rows.Count;
for (start = 0; start < counttemp; start++)
{
mscstr[start, 0] = temp.Rows[start][1].ToString();
mscstr[start, 1] = temp.Rows[start][3].ToString();
mscstr[start, 2] = "1";
}
ImageList il = new ImageList();
il.Images.Add(HAMACO.Properties.Resources.previous);
tvmsc.ImageList = il;
this.tvmsc.Nodes.Add("HAMACO");
temp = gen.GetTable("select * from MSC_SubSystem order by SortOrder");
int level = 0; int level1 = 0;
for (int i = 0; i < temp.Rows.Count; i++)
{
if (temp.Rows[i][3].ToString() == "ROOT")
{
mscrole.tvlevel(tvmsc, level, level1, temp, temp.Rows[i][0].ToString(), temp.Rows[i][1].ToString());
level1++;
}
}
tvmsc.Nodes[0].Expand();
SplashScreenManager.CloseForm();
//tạo cây phân quyền
/*da = gen.GetTable("select * from MSC_SubSystem where ParentSubSystemCode = 'Root' order by SortOrder ");
* int count = da.Rows.Count;
* int level = 0; int level1 = 0;
* for (int i = 0; i < count; i++)
* {
* mscrole.tvlevel1(tvmsc, level, level1, i, da);
* level1++;
* }*/
}
private void Frm_hangtieudung_Load(object sender, EventArgs e)
{
denct.EditValue = DateTime.Parse(ngaychungtu);
if (userid == null)
{
hang = gen.GetTable("select InventoryItemID as 'ID',InventoryItemCode as 'Mã hàng hóa',InventoryItemName as 'Tên hàng',Unit as 'Đơn vị tính', ConvertUnit as 'Đơn vị quy đổi',convert(decimal(22,2),ConvertRate) as 'Tỷ lệ quy đổi',SalePrice as 'Đơn giá tham khảo',GuarantyPeriod as 'Công ty' from InventoryItem order by InventoryItemCode");
}
else
{
htd.loadstart(ledv, userid);
}
}
public void gethoadon()
{
try
{
DataTable da = new DataTable();
da = gen.GetTable("select * from SSInvoice where RefID='" + hoadon + "'");
bthd.EditValue = da.Rows[0][5];
if (ckhd.Checked == false)
{
txtms.Text = da.Rows[0][67].ToString();
txtkhhd.Text = da.Rows[0][68].ToString();
txtshd.Text = da.Rows[0][69].ToString();
txtnhd.EditValue = DateTime.Parse(da.Rows[0][14].ToString());
cbthue.Text = da.Rows[0][66].ToString();
}
else
{
txtms.Text = "";
txtkhhd.Text = "";
txtshd.Text = "";
txtcth.Text = "0";
txtnhd.EditValue = DateTime.Now;
}
da = gen.GetTable("select InventoryItemCode,InventoryItemName from SSInvoiceDetail a,InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + hoadon + "' order by SortOrder ");
while (gridView1.RowCount > 0)
{
gridView1.DeleteRow(0);
}
for (int i = 0; i < da.Rows.Count; i++)
{
gridView1.AddNewRow();
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns["Mã hàng"], da.Rows[i][0].ToString());
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns["Tên hàng"], da.Rows[i][1].ToString());
}
gridView1.UpdateCurrentRow();
}
catch { }
}
private void refreshrole()
{
try
{
DataTable dt = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + roleid + "' and SubSystemCode='" + subsys + "'");
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][3].ToString() == "ADD")
{
baadd.Enabled = true;
lehd.Properties.ReadOnly = false;
txtshd.Properties.ReadOnly = false;
//ledv.Properties.ReadOnly = false;
txttenbl.Properties.ReadOnly = false;
txtsdt.Properties.ReadOnly = false;
txtfax.Properties.ReadOnly = false;
txtndd.Properties.ReadOnly = false;
txtcv.Properties.ReadOnly = false;
txtguq.Properties.ReadOnly = false;
txtnc.Properties.ReadOnly = false;
denk.Properties.ReadOnly = false;
denhh.Properties.ReadOnly = false;
txthmn.Properties.ReadOnly = false;
txthmtd.Properties.ReadOnly = false;
txthn.Properties.ReadOnly = false;
groupBox2.Enabled = true;
txtndtd.Properties.ReadOnly = false;
txtddgh.Properties.ReadOnly = false;
denl.Properties.ReadOnly = false;
deng.Properties.ReadOnly = false;
denqv.Properties.ReadOnly = false;
txtnl.Properties.ReadOnly = false;
chenqv.Properties.ReadOnly = false;
}
}
}
catch
{ }
}
private void Frm_nhapkhovo_Load(object sender, EventArgs e)
{
dt = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + roleid + "' and SubSystemCode='" + subsys + "'");
refreshrole();
if (pt == "pnk")
{
refreshpnk();
chtc.Text = "Phiếu nhập thế chân vỏ";
}
else if (pt == "pxk")
{
refreshpxk();
labelControl13.Text = "Phiếu xuất kho Vỏ LPG";
chtc.Text = "Phiếu xuất thế chân vỏ";
}
else if (pt == "pnkvtddh")
{
refreshpnktddh();
labelControl13.Text = "Phiếu nhập kho vỏ LPG theo đơn đặt hàng";
}
change();
radioGroup1.SelectedIndex = -1;
}
private void load_datagrid()
{
lvpq.Visible = true;
SQLString = "SELECT count(*) FROM information_schema.tables";
lblSum.Text = gen.GetString(SQLString);
lblSum.Text = "There are " + lblSum.Text + " tables and views in the database.";
SQLString = "SELECT * FROM information_schema.tables";
try
{
dt = gen.GetTable(SQLString);
}
catch
{
XtraMessageBox.Show(SQLString, "load_datagrid", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtSQL.Visible = true;
txtSQL.Text = SQLString;
}
DataTable temp = new DataTable();
temp.Columns.Add("No");
temp.Columns.Add("Table Name");
temp.Columns.Add("Type");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = temp.NewRow();
dr[0] = i + 1;
dr[1] = dt.Rows[i][2].ToString();
dr[2] = dt.Rows[i][3].ToString();
temp.Rows.Add(dr);
}
lvpq.DataSource = temp;
}
private void load_txtTransactionCode(string roleid) //load search edit table transactions
{
string SQLString = "select * from transactions where ClientID=" + clientid;
SQLString += " AND TransactionCode NOT IN ((select TransactionCode from RolePermissionMapping where RoleID = '" + roleid + "'))";
try
{
dt = gen.GetTable(SQLString);
}
catch
{
XtraMessageBox.Show(SQLString, "load_txtTransactionCode", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtSQL.Text = SQLString;
}
txtTransactionCode.Properties.View.Columns.Clear();
DataTable temp = new DataTable();
temp.Columns.Add("Transaction Code");
temp.Columns.Add("Transaction Name");
temp.Columns.Add("Module");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = temp.NewRow();
dr[0] = dt.Rows[i][1].ToString();
dr[1] = dt.Rows[i][2].ToString();
dr[2] = dt.Rows[i][4].ToString();
temp.Rows.Add(dr);
}
txtTransactionCode.Properties.DataSource = temp;
txtTransactionCode.Properties.DisplayMember = "Transaction Code";
txtTransactionCode.Properties.ValueMember = "Transaction Code";
txtTransactionCode.Focus();
}
private void Frm_uynhiemchi_Load(object sender, EventArgs e)
{
dt = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + roleid + "' and SubSystemCode='" + subsys + "'");
taikhoanchinh = gen.GetTable("select AccountNumber,AccountName from Account order by AccountNumber");
taikhoan = gen.GetTable("select Description,AccountNameEnglish from Account where DetailByBankAccount=1 and Description<>'' order by AccountNameEnglish,Description");
danhmuc = gen.GetTable("select STT,DebitAmout,CreditAmount from DANHMUC where Phieu='pcnh' order by STT");
refeshunc();
refreshrole();
change();
}
private void Frm_hdmuahang_Load(object sender, EventArgs e)
{
try
{
dt = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + roleid + "' and SubSystemCode='" + subsys + "'");
}
catch
{
tsbttruoc.Enabled = false;
tsbtsau.Enabled = false;
}
refreshrole();
hdmh.loadbox(gridControl1, gridView1, soluong, soluongquydoi, dongia, thanhtien, chiphi);
hdmh.loadboxhd(gridControl2, gridView2);
refreshhdmh();
change();
if (active == "0")
{
if (kho != null)
{
ledv.EditValue = kho;
if (doituong != null)
{
ledt.EditValue = doituong;
}
for (int i = 0; i < gridView3.RowCount; i++)
{
if (gridView3.GetRowCellValue(i, "ID").ToString() == phieu)
{
string pnkid = gridView3.GetRowCellValue(gridView3.FocusedRowHandle, "ID").ToString();
hdmh.loadcthd(gridView1, pnkid);
gridView3.SetRowCellValue(gridView3.FocusedRowHandle, gridView3.Columns["Chọn"], "True");
}
}
for (int i = 0; i < gridView1.RowCount; i++)
{
gridView1.SetRowCellValue(i, gridView1.Columns["Số lượng"], gridView1.GetRowCellValue(i, "Số lượng tồn").ToString());
gridView1.SetRowCellValue(i, gridView1.Columns["Số lượng quy đổi"], gridView1.GetRowCellValue(i, "SL tồn quy đổi").ToString());
}
}
}
load = "0";
radioGroup1.SelectedIndex = -1;
}
private void Frm_phieunhapgas_Load(object sender, EventArgs e)
{
dt = gen.GetTable("select * from MSC_RolePermissionMaping where RoleID='" + roleid + "' and SubSystemCode='" + subsys + "'");
refreshrole();
if (pt == "pnk")
{
labelControl12.Hide();
cbthue.Hide();
panelControl6.Hide();
refreshpnk();
}
else if (pt == "pxk")
{
refreshpxk();
labelControl13.Text = "Phiếu xuất kho Gas";
}
change();
}
private void FRM_MSCROLE_Load(object sender, EventArgs e)
{
if (active == "1")
{
this.Text = "Sửa vai trò";
this.txtmsccode.ReadOnly = true;
DataTable da = new DataTable();
da = gen.GetTable("select * from MSC_Role where RoleID = '" + role + "'");
txtmsccode.Text = da.Rows[0][1].ToString();
txtmscname.Text = da.Rows[0][2].ToString();
txtmscdg.Text = da.Rows[0][3].ToString();
}
else
{
this.Text = "Thêm vai trò";
}
}
private void Frm_province_Load(object sender, EventArgs e)
{
if (active == "1")
{
this.Text = "Sửa tỉnh/thành";
txtcode.ReadOnly = true;
DataTable da = new DataTable();
da = gen.GetTable("select * from Province where ProvinceID='" + role + "'");
txtcode.Text = da.Rows[0][1].ToString();
txtname.Text = da.Rows[0][2].ToString();
txtdg.Text = da.Rows[0][3].ToString();
}
else
{
this.Text = "Thêm tỉnh/thành";
}
}
private void cbprovince_SelectedIndexChanged(object sender, EventArgs e)
{
cbdistrist.Items.Clear();
cbdistrist.Text = "";
clsItem cls1 = (clsItem)cbprovince.SelectedItem;
string tt = cls1.PstrValue;
clsItem cls;
DataTable dapro = new DataTable();
dapro = gen.GetTable("select * from Distrist where ProvinceID='" + tt + "' order by DistristName");
for (int i = 0; i < dapro.Rows.Count; i++)
{
cls = new clsItem(dapro.Rows[i][0].ToString(), dapro.Rows[i][2].ToString());
cbdistrist.Items.Add(cls);
}
cbdistrist.DisplayMember = "PstrName";
cbdistrist.ValueMember = "PstrValue";
}
