private void f_caplai_mabd(int i_nhom) { string user = m.user; LibDuoc.AccessData d = new LibDuoc.AccessData(); string sql = "update " + user + ".d_dmbd set ma='000000' where nhom=" + i_nhom;// +" and ma='BAN001'"; d.execute_data(sql); sql = "select id, ma, ten from " + user + ".d_dmbd where nhom=" + i_nhom + " order by ten, id ";//+" and ma='000000' DataSet lds = m.get_data(sql); string s_ma = ""; int i1 = lds.Tables[0].Rows.Count; int i2 = 0; foreach (DataRow r in lds.Tables[0].Rows) { s_ma = d.getMabd("d_dmbd", r["ten"].ToString(), i_nhom); sql = "update " + user + ".d_dmbd set ma='" + s_ma + "' where id=" + r["id"].ToString(); d.execute_data(sql); i2 += 1; lblma.Text = s_ma; lblma.Refresh(); lblten.Text = r["ten"].ToString() + " - " + i2.ToString() + "/" + i1.ToString(); lblten.Refresh(); } }
private void butHuy_Click(object sender, System.EventArgs e) { //if (dt.Rows.Count==1) //{ // MessageBox.Show("Không cho phép hủy ?",ttb.Msg); // return; //} try { if (ttb.get_data("select * from " + user + ".ttb_dmkho where nhom=" + decimal.Parse(dataGrid1[dataGrid1.CurrentCell.RowNumber, 3].ToString())).Tables[0].Rows.Count != 0) { MessageBox.Show("Nội dung đang sử dụng không cho phép hủy !", ttb.Msg); return; } } catch {} if (MessageBox.Show("Đồng ý hủy thông tin này !", ttb.Msg, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { l_id = decimal.Parse(dataGrid1[dataGrid1.CurrentCell.RowNumber, 3].ToString()); ttb.upd_eve_tables(itable, i_userid, "del"); ttb.upd_eve_upd_del(itable, i_userid, "del", ttb.fields(user + ".ttb_dmnhomkho", "id=" + l_id)); //ttb.execute_data("delete from "+user+".ttb_dmnhomkho where id="+l_id); ttb.execute_data("delete from " + user + ".ttb_dmnhomkho where id=-2"); try { d.execute_data("delete from " + d.user + ".d_dmnhomkho where id=-2"); } catch { } load_grid(); } }
private void butHuy_Click(object sender, System.EventArgs e) { if (b_admin == false) { MessageBox.Show(lan.Change_language_MessageText("Bạn chưa được quyền hủy danh mục này, liên hệ với người quản trị.")); return; } if (l_id <= 0) { return; } if (MessageBox.Show(lan.Change_language_MessageText("Đồng ý hủy?"), lan.Change_language_MessageText("Thông báo"), MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { sql = "delete from " + m.user + ".bhyt_maubaocao where id=" + l_id; m.execute_data(sql); loadgrid(s_maloai); dataGrid1.Refresh(); } ena_object(false); }
private void frmAbout_KeyDown(object sender, KeyEventArgs e) { string user = d.user, xxx = user + mmyy; if (e.KeyCode == Keys.F7) { string sql = "select a.* from " + xxx + ".d_tutrucct a," + user + ".d_dmkho b," + xxx + ".d_theodoi t where a.makho=b.id and a.tondau<0 and a.stt=t.id and b.nhom=" + i_nhom + " order by a.makp,a.makho,t.manguon,a.mabd,a.stt"; decimal sl = 0; foreach (DataRow r in d.get_data(sql).Tables[0].Rows) { sl = decimal.Parse(r["tondau"].ToString()); sql = "select a.* from " + xxx + ".d_tutrucct a," + xxx + ".d_theodoi t where a.stt=t.id and a.mabd=" + decimal.Parse(r["mabd"].ToString()) + " and a.makp=" + decimal.Parse(r["makp"].ToString()); sql += " and a.makho=" + decimal.Parse(r["makho"].ToString()) + " and t.manguon=" + decimal.Parse(r["manguon"].ToString()); sql += " and a.tondau>=" + Math.Abs(sl) + " and a.tondau+a.slnhap-a.slxuat>=" + Math.Abs(sl); sql += " order by a.makp,a.makho,t.manguon,a.mabd,a.stt"; foreach (DataRow r1 in d.get_data(sql).Tables[0].Rows) { sql = "update " + xxx + ".d_tutrucct set tondau=tondau+" + sl + " where mabd=" + decimal.Parse(r["mabd"].ToString()); sql += " and makp=" + decimal.Parse(r["makp"].ToString()) + " and stt=" + decimal.Parse(r1["stt"].ToString()); d.execute_data(sql); sql = "update " + xxx + ".d_tutrucct set tondau=0 where mabd=" + decimal.Parse(r["mabd"].ToString()); sql += " and makp=" + decimal.Parse(r["makp"].ToString()) + " and stt=" + decimal.Parse(r["stt"].ToString()); d.execute_data(sql); break; } } MessageBox.Show(lan.Change_language_MessageText("Đã kiểm tra lại tồn đầu tủ trực !"), d.Msg); } else if (e.KeyCode == Keys.F8) { kiemtra_nhap(); } else if (e.KeyCode == Keys.F12) { if (!d.bMahoamatkhau) { foreach (DataRow r in m.get_data("select * from " + user + ".d_dlogin").Tables[0].Rows) { try { d.execute_data("update " + user + ".d_dlogin set password_='" + m.encode(r["password_"].ToString()) + "' where id=" + decimal.Parse(r["id"].ToString())); } catch { } } d.upd_thongso(i_nhom, -13, "", "1"); MessageBox.Show(lan.Change_language_MessageText("Đã mã hóa mật khẩu !"), LibMedi.AccessData.Msg); } else { MessageBox.Show(lan.Change_language_MessageText("Mật khẩu đã mã hóa !"), LibMedi.AccessData.Msg); } } else if (e.KeyCode == Keys.F11) { if (d.bMahoamatkhau) { foreach (DataRow r in m.get_data("select * from " + user + ".d_dlogin").Tables[0].Rows) { try { d.execute_data("update " + user + ".d_dlogin set password_='" + m.decode(r["password_"].ToString()) + "' where id=" + decimal.Parse(r["id"].ToString())); } catch { } } d.execute_data("delete from " + user + ".d_thongso where id=-13"); MessageBox.Show(lan.Change_language_MessageText("Đã giải hóa mật khẩu !"), LibMedi.AccessData.Msg); } else { MessageBox.Show(lan.Change_language_MessageText("Mật khẩu chưa mã hóa !"), LibMedi.AccessData.Msg); } } else if (e.KeyCode == Keys.L && e.Control && e.Alt && e.Shift) { frmRight_BV f = new frmRight_BV(d, tree, i_nhom); f.Show(); } }
private void butTao_Click(object sender, EventArgs e) { m.execute_data("create table " + user + ".anhxa(ma_medisoft numeric(7) ,ma_benhvien numeric(7),loai varchar(50),constraint pk_anhxa primary key(ma_medisoft,ma_benhvien,loai))"); m.execute_data("alter table " + user + ".anhxa modify (ma_benhvien numeric(7),ma_medisoft numeric(7))"); dtdm = m.get_data("select * from " + user + ".anhxa where loai='" + cboSolieu.Tag.ToString() + "'").Tables[0]; }