protected void btnLuu_Click(object sender, EventArgs e)
{
if (lblThongBao.Text.Trim() != "")
{
lblThongBao.Text = "";
}
string congty = DropCty.SelectedValue.ToString();
string bophan = DropDownBoPhan.SelectedValue.ToString();
string tenbophan = DropDownBoPhan.SelectedItem.ToString();
string manhanvien = txtChuQuan.Text.Trim();
if (manhanvien == "")
{
lblThongBao.Text = "Input Incorrect";
}
else
{
BDepartment bs = new BDepartment();
bs.GSBH = congty;
bs.ID = bophan;
bs.DepName = tenbophan;
bs.IdUserChuQuan = manhanvien;
bs.DepartmentTypeID = int.Parse(DropDownLoaiDonVi.SelectedValue.ToString());
BDepartmentBUS.SuaBoPhan(bs);
}
}
protected void DropCty_SelectedIndexChanged1(object sender, EventArgs e)
{
string congty = DropCty.SelectedValue.ToString();
GridView1.DataSource = BDepartmentBUS.DanhSachBoPhan(congty);
GridView1.DataBind();
}
private void HienThiDonViThongQua()
{
DropDownDonViThongQua.DataSource = BDepartmentBUS.DanhSachBoPhan();
DropDownDonViThongQua.DataValueField = "ID";
DropDownDonViThongQua.DataTextField = "DepName";
DropDownDonViThongQua.DataBind();
}
private void HienThiDropDownList()
{
string congty = Session["congty"].ToString();
DropBoPhan.DataSource = BDepartmentBUS.DanhSachBoPhan(congty);
DropBoPhan.DataValueField = "ID";
DropBoPhan.DataTextField = "DepName";
DropBoPhan.DataBind();
}
private void HienThiDropDownList()
{
string congty = DropCty.SelectedValue.ToString();
DropDownBoPhan.DataSource = BDepartmentBUS.DanhSachBoPhan(congty);
DropDownBoPhan.DataValueField = "ID";
DropDownBoPhan.DataTextField = "DepName";
DropDownBoPhan.DataBind();
}
private void HienThi()
{
string macongty = Session["congty"].ToString();
string idphieu = Session["maphieu"].ToString();
//string bophan = Session["bophan"].ToString();
string manguoidung = Session["user"].ToString();
//string tenloaiphieu = Session["loaiP"].ToString();
DateTime date = DateTime.Now;
//pdna phieu = pdnaBUS.TimVanBanTheoMa(idphieu, macongty, true);
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + idphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'"));
var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + idphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'");
foreach (pdna phieu in list)
{
if (phieu == null)
{
string noidung = Session["noidung"].ToString();
string ngaytao = Session["ngaytao"].ToString();
abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
BDepartment donvi = BDepartmentBUS.TimMaDonVi(phieu.pddepid, macongty);
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lbBoPhan.Text = donvi.DepName;
lbSoPhieu.Text = idphieu;
lbNoiDung.Text = noidung;
//lbNgay.Text = ngaytao;
string dinhdang = DateTime.Parse(date.ToShortDateString()).ToString("dd/MM/yyyy");
string ngay = dinhdang.Substring(3, 2);
string thang = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
}
else
{
BDepartment donvi = BDepartmentBUS.TimMaDonVi(phieu.pddepid, macongty);
lbBoPhan.Text = donvi.DepName;
lbSoPhieu.Text = idphieu;
lbNoiDung.Text = phieu.pdmemovn;
//lbNgay.Text = phieu.CFMDate0.ToString();
abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lblNoiDungDich.Text = phieu.NoiDungDich;
string dinhdang = phieu.CFMDate0.ToString();
string ngay = dinhdang.Substring(3, 2);
string thang = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DropDownNguoiDich.Enabled = false;
// string ngaythang = DateTime.Parse(phieu.CFMDate0.ToString("dd/MM/yyyy"));
if (!IsPostBack)
{
if (Session["user"] == null)
{
//Response.Redirect("~/presentationLayer/DangNhap.aspx");
Response.Redirect("http://portal.footgear.com.vn");
}
string strNgonngu = (string)Session["languege"];
if (strNgonngu != null)
{
LayngonNgu(32, strNgonngu);
}
else
{
Response.Redirect("http://portal.footgear.com.vn");
}
btnLuu.Attributes.Add("opacity", "0.3");
btnLuu.Enabled = false;
GanNgonNguVaoConTrol();
string maphieu = Session["maphieu"].ToString();
string macongty = Session["congty"].ToString();
string manguoidung = Session["user"].ToString();
DataTable dt = dal.TimPhieuTheoMaNguoiTao(maphieu, macongty, manguoidung);
if (dt.Rows.Count > 0)
{
string madonvi = dt.Rows[0]["pddepid"].ToString();
string maloaiphieu = dt.Rows[0]["Abtype"].ToString();
BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty);
abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
txtTieuDe.Text = dt.Rows[0]["mytitle"].ToString();
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lbBoPhan.Text = bophan.DepName;
lbSoPhieu.Text = dt.Rows[0]["pdno"].ToString();
string dinhdang = dt.Rows[0]["CFMDate0"].ToString();
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
//lbNgay.Text = ;
CKEditorControl1.Text = dt.Rows[0]["pdmemovn"].ToString();
}
DropDownNguoiDich.Enabled = false;
CKEditorControl1.Enabled = false;
HienThiNguoiDich();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["user"] == null)
{
//Response.Redirect("~/presentationLayer/DangNhap.aspx");
Response.Redirect("http://portal.footgear.com.vn");
}
string strNgonngu = (string)Session["languege"];
if (strNgonngu != null)
{
LayngonNgu(3, strNgonngu);
}
else
{
Response.Redirect("http://portal.footgear.com.vn");
}
GanNgonNguVaoConTrol();
string maphieu = Session["maphieu"].ToString();
string macongty = Session["congty"].ToString();
string manguoidung = Session["user"].ToString();
List <pdna> list = db.pdnas.ToList();
if (list.Count() > 0)
{
//pdna phieu = pnaDAO.LayVanBanChuaDichTheoNguoiTrinhKy(maphieu, macongty, manguoidung);
DataTable dt = dal.TimPhieuGuiNguoiDich(maphieu, macongty, manguoidung);
if (dt.Rows.Count > 0)
{
string madonvi = dt.Rows[0]["pddepid"].ToString();
string abtype = dt.Rows[0]["Abtype"].ToString();
string noidung = dt.Rows[0]["pdmemovn"].ToString();
string ngayt = dt.Rows[0]["CFMDate0"].ToString();
BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty);
abill loaiphieu = abillBUS.SearchAbillByID(abtype);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lbBoPhan.Text = bophan.DepName;
//lbNgay.Text = ;
lblNoiDung.Text = noidung;
lbSoPhieu.Text = maphieu;
string dinhdang = ngayt;
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
}
}
}
// string ngaythang = DateTime.Parse(phieu.CFMDate0.ToString("dd/MM/yyyy"));
}
private void HienThi()
{
string idphieu = Session["maphieu"].ToString();
//string bophan = Session["bophan"].ToString();
//string noidung = Session["noidung"].ToString();
//string ngaytao = Session["ngaythang"].ToString();
string user = Session["user"].ToString();
string congty = Session["congty"].ToString();
DataTable dt = dalP.TimPhieuTheoMaNguoiTao(idphieu, congty, user);
if (dt.Rows.Count > 0)
{
string madonvi = dt.Rows[0]["pddepid"].ToString();
string maloaiphieu = dt.Rows[0]["Abtype"].ToString();
int Abc = int.Parse(dt.Rows[0]["ABC"].ToString());
BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, congty);
abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu);
aABC douutien = ABCDAO.TimDoUuTien(Abc);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
if (douutien != null)
{
lblDoUutien.Text = douutien.NameABC + "-" + douutien.NameABCTW;
}
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lblTieuDe.Text = dt.Rows[0]["mytitle"].ToString() + " " + dt.Rows[0]["pdnsubject"].ToString();
lbBoPhan.Text = bophan.DepName;
lbSoPhieu.Text = idphieu;
lbNoiDung.Text = dt.Rows[0]["pdmemovn"].ToString();
LbNoiDungDich.Text = dt.Rows[0]["NoiDungDich"].ToString();
//lbNgay.Text = phieu.CFMDate0.ToString();
string dinhdang = dt.Rows[0]["CFMDate0"].ToString();
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
}
Busers2 user0 = AbconBUS.LayMaNguoiTaoTheoIDVanBan(idphieu, congty);
if (user0 != null)
{
TextBox1.Text = user0.USERID;
//ImageLevel0.ImageUrl = users.signatue;
ImageLevel0.Width = 100;
ImageLevel0.Height = 100;
ImageLevel0.ImageUrl = "~/MyPhoto.ashx?USERID=" + TextBox1.Text;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["user"] == null)
{
//Response.Redirect("~/presentationLayer/DangNhap.aspx");
Response.Redirect("http://portal.footgear.com.vn");
}
string strNgonngu = (string)Session["languege"];
if (strNgonngu != null)
{
LayngonNgu(3, strNgonngu);
}
else
{
Response.Redirect("http://portal.footgear.com.vn");
}
GanNgonNguVaoConTrol();
string maphieu = Session["maphieu"].ToString();
string macongty = Session["congty"].ToString();
string manguoidung = Session["user"].ToString();
DataTable dt = dal.TimPhieuTheoMaNguoiTao(maphieu, macongty, manguoidung);
if (dt.Rows.Count > 0)
{
string ngaythang = dt.Rows[0]["CFMDate0"].ToString();
string madonvi = dt.Rows[0]["pddepid"].ToString().Trim();
string maloaiphieu = dt.Rows[0]["Abtype"].ToString().Trim();
string noidung = dt.Rows[0]["pdmemovn"].ToString().Trim();
string tieude = dt.Rows[0]["mytitle"].ToString().Trim();
string tieudedich = dt.Rows[0]["pdnsubject"].ToString().Trim();
string noidungdich = dt.Rows[0]["NoiDungDich"].ToString();
int Yn = int.Parse(dt.Rows[0]["Yn"].ToString());
BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty);
abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lbBoPhan.Text = bophan.DepName;
//lbNgay.Text = ;
lblNoiDung.Text = noidung;
lbSoPhieu.Text = maphieu;
string dinhdang = ngaythang;
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
}
}
}
private void HienThi()
{
string macongty = Session["congty"].ToString();
string idphieu = Session["maphieu"].ToString();
//string bophan = Session["bophan"].ToString();
string manguoidung = Session["user"].ToString();
DataTable dt = dap.TimPhieuTheoMaNguoiTao(idphieu, macongty, manguoidung);
if (dt.Rows.Count > 0)
{
string ngaythang = dt.Rows[0]["CFMDate0"].ToString();
string madonvi = dt.Rows[0]["pddepid"].ToString().Trim();
string maloaiphieu = dt.Rows[0]["Abtype"].ToString().Trim();
string noidung = dt.Rows[0]["pdmemovn"].ToString().Trim();
string tieude = dt.Rows[0]["mytitle"].ToString().Trim();
string tieudedich = dt.Rows[0]["pdnsubject"].ToString().Trim();
string noidungdich = dt.Rows[0]["NoiDungDich"].ToString();
int Yn = int.Parse(dt.Rows[0]["Yn"].ToString());
abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty);
Session["bp"] = bophan.ID;
Session["bophan"] = bophan.DepName;
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lbBoPhan.Text = bophan.DepName;
lbSoPhieu.Text = idphieu;
lbNoiDung.Text = noidung;
//lbNgay.Text = phieu.CFMDate0.ToString();
lblTieuDe.Text = tieude;
string dinhdang = ngaythang;
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
if (Yn != 6)
{
btnEdit.Enabled = true;
btnNhoNguoi.Enabled = true;
btnEdit.Attributes.Add("opacity", "100");
btnNhoNguoi.Attributes.Add("opacity", "100");
}
else
{
btnEdit.Enabled = false;
btnNhoNguoi.Enabled = false;
btnEdit.Attributes.Add("opacity", "0.3");
btnNhoNguoi.Attributes.Add("opacity", "0.3");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
//Response.Redirect("~/presentationLayer/DangNhap.aspx");
Response.Redirect("http://portal.footgear.com.vn");
}
string strNgonngu = (string)Session["languege"];
if (strNgonngu != null)
{
LayngonNgu(25, strNgonngu);
}
else
{
Response.Redirect("http://portal.footgear.com.vn");
}
GanNgonNguVaoConTrol();
if (!IsPostBack)
{
string maphieu = Session["maphieu"].ToString();
string macongty = Session["congty"].ToString();
string manguoidung = Session["user"].ToString();
//pdna phieu = pnaDAO.LayVanBanChuaDichTheoNguoiDich(maphieu, macongty, manguoidung);
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and IDNguoiDich='" + manguoidung + "'"));
var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and IDNguoiDich='" + manguoidung + "'");
foreach (pdna phieu in list)
{
// string ngaythang = DateTime.Parse(phieu.CFMDate0.ToString("dd/MM/yyyy"));
BDepartment bophan = BDepartmentBUS.TimMaDonVi(phieu.pddepid, macongty);
abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lbBoPhan.Text = bophan.DepName;
txtNguoiDUyet.Text = phieu.CFMID1;
//lbNgay.Text = ;
lbNoiDung.Text = phieu.pdmemovn;
lbSoPhieu.Text = phieu.pdno;
lblTieuDe.Text = phieu.mytitle;
txtTieuDe.Text = phieu.pdnsubject;
CKEditorControl1.Text = phieu.NoiDungDich;
string dinhdang = phieu.CFMDate0.ToString();
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
}
}
}
private void HienThi()
{
string maphieu = Session["maphieu"].ToString();
string macongty = Session["congty"].ToString();
string manguoidung = Session["user"].ToString();
// pdna phieu = pnaDAO.LayVanBanTheoNguoiTrinh(maphieu, macongty,manguoidung);
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'"));
var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'");
foreach (pdna phieu in list)
{
Session["loaiphieu"] = phieu.Abtype;
Session["bp"] = phieu.pddepid;
Session["noidung"] = phieu.pdmemovn;
Session["noidungdich"] = phieu.NoiDungDich;
Session["tieude"] = phieu.mytitle;
if (phieu == null)
{
return;
}
else
{
if (phieu.trangthaidich == true)
{
BDepartment bophan = BDepartmentBUS.TimMaDonVi(phieu.pddepid, macongty);
abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lbBoPhan.Text = bophan.DepName;
// lbNgay.Text =ngaytao ;
lbNoiDung.Text = phieu.pdmemovn;
lbSoPhieu.Text = phieu.pdno;
LbNoiDungDich.Text = phieu.NoiDungDich;
string dinhdang = phieu.CFMDate0.ToString();
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
}
}
}
}
private void HienThi()
{
string idphieu = Session["maphieu"].ToString();
//string bophan = Session["bophan"].ToString();
//string noidung = Session["noidung"].ToString();
//string ngaytao = Session["ngaythang"].ToString();
string user = Session["user"].ToString();
string bp = Session["bp"].ToString();
string congty = Session["congty"].ToString();
BDepartment bophan = BDepartmentBUS.TimMaDonVi(bp, congty);
//string loaiphieu = Session["loaiphieu"].ToString();
pdna phieu = pdnaBUS.TimVanBanTheoMa(idphieu, congty, true);
abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
// lbBoPhan.Text = bophan;
// lbNoiDung.Text = phieu.pdmemovn.ToString();
// lbNgay.Text =Convert.ToString(phieu.CFMDate0);
// Buser users = UserBUS.TimMaNhanVienTheoBoPhan(user, bp);
lblTieuDe.Text = phieu.mytitle + phieu.pdnsubject;
lbldonvidenghi.Text = bophan.DepName;
lbSoPhieu.Text = idphieu;
lblMucDichSuDung.Text = phieu.UseIntent;
//lbNgay.Text = phieu.CFMDate0.ToString();
string dinhdang = phieu.CFMDate0.ToString();
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lblNgaytao.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
Busers2 user0 = AbconBUS.LayMaNguoiTaoTheoIDVanBan(idphieu, congty);
if (user0 != null)
{
TextBox1.Text = user0.USERID;
//ImageLevel0.ImageUrl = users.signatue;
ImageLevel0.Width = 100;
ImageLevel0.Height = 100;
ImageLevel0.ImageUrl = "~/MyPhoto.ashx?USERID=" + TextBox1.Text;
}
}
private void HienThi()
{
string idphieu = Session["maphieu"].ToString();
string user = Session["user"].ToString();
//string bp = Session["bp"].ToString();
string congty = Session["congty"].ToString();
//pdna phieu = pdnaBUS.TimVanBanTheoMa(idphieu, congty, true);
DataTable dt = dalPDN.TimPhieuTheoMaPhieu(idphieu, congty);
if (dt.Rows.Count > 0)
{
string madonvi = dt.Rows[0]["pddepid"].ToString();
string maloaip = dt.Rows[0]["Abtype"].ToString();
int dout = int.Parse(dt.Rows[0]["ABC"].ToString());
BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, congty);
abill loaiphieu = abillBUS.SearchAbillByID(maloaip);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lbldonvidenghi.Text = bophan.DepName;
lbSoPhieu.Text = idphieu;
lblMucDichSuDung.Text = dt.Rows[0]["UseIntent"].ToString();
lblTieuDe.Text = dt.Rows[0]["mytitle"].ToString() + "-" + dt.Rows[0]["pdnsubject"].ToString();
//lbNgay.Text = phieu.CFMDate0.ToString();
string dinhdang = dt.Rows[0]["CFMDate0"].ToString();
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lblNgaytao.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
}
Busers2 user0 = AbconBUS.LayMaNguoiTaoTheoIDVanBan(idphieu, congty);
if (user0 != null)
{
TextBox1.Text = user0.USERID;
//ImageLevel0.ImageUrl = users.signatue;
ImageLevel0.Width = 100;
ImageLevel0.Height = 100;
ImageLevel0.ImageUrl = "~/MyPhoto.ashx?USERID=" + TextBox1.Text;
}
}
private void HienThiDonVi()
{
string madonvi = (string)Session["madonvi"];
if (madonvi == "All")
{
DropDownLDonVi.Items.Insert(0, "All");
}
else
{
DropDownLDonVi.DataSource = BDepartmentBUS.DanhSachBoPhan();
DropDownLDonVi.DataValueField = "ID";
DropDownLDonVi.DataTextField = "DepName";
DropDownLDonVi.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
//Response.Redirect("~/presentationLayer/DangNhap.aspx");
Response.Redirect("http://portal.footgear.com.vn");
}
string maphieu = Session["maphieu"].ToString();
string macongty = Session["congty"].ToString();
string manguoidung = Session["user"].ToString();
//pdna phieu = pnaDAO.LayVanBanDaDichTheoNguoiDich(maphieu, macongty, manguoidung);
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and IdnguoiDich='" + manguoidung + "'"));
var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and IdnguoiDich='" + manguoidung + "'");
foreach (pdna phieu in list)
{
BDepartment bophan = BDepartmentBUS.TimMaDonVi(phieu.pddepid, macongty);
abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype);
if (!IsPostBack)
{
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
lbBoPhan.Text = bophan.DepName;
lbLoaiPhieu.Text = loaiphieu.abname;
//lbNgay.Text = ;
txtTieuDe.Text = phieu.pdnsubject;
lbNoiDung.Text = phieu.pdmemovn;
lbSoPhieu.Text = phieu.pdno;
string dinhdang = phieu.CFMDate0.ToString();
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
CKEditorControl1.Text = phieu.NoiDungDich;
CKEditorControl1.ReadOnly = true;
CKEditorControl1.Enabled = false;
btnLuu.Enabled = false;
}
}
}
private void HienThiBoPhan()
{
string congty = Session["congty"].ToString();
string user = Session["user"].ToString();
DataTable dt = dal.QryDonViTheoDieuKien(user, congty);
if (dt.Rows.Count > 0)
{
DropDonVi.DataSource = dt;
DropDonVi.DataValueField = "ID";
DropDonVi.DataTextField = "DepName";
DropDonVi.DataBind();
}
else
{
DropDonVi.DataSource = BDepartmentBUS.DanhSachBoPhan(congty);
DropDonVi.DataValueField = "ID";
DropDonVi.DataTextField = "DepName";
DropDonVi.DataBind();
}
}
private void HienThiThongTin()
{
string maphieu = Session["maphieu"].ToString();
string macongty = Session["congty"].ToString();
string manguoidung = Session["user"].ToString();
DataTable dt = dal.TimPhieuTheoMaNguoiTao(maphieu, macongty, manguoidung);
if (dt.Rows.Count > 0)
{
// string ngaythang = DateTime.Parse(phieu.CFMDate0.ToString("dd/MM/yyyy"));
string madonvi = dt.Rows[0]["pddepid"].ToString();
string maloaiphieu = dt.Rows[0]["Abtype"].ToString();
BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty);
abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu);
string tenloaiphieuVN = loaiphieu.abname;
string tenloaiphieuTW = loaiphieu.abnameTW;
txtTieuDe.Text = dt.Rows[0]["mytitle"].ToString();
lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW;
//lbNgay.Text = ;
//CKEditorControl1.Text = phieu.pdmemovn;
lbBoPhan.Text = bophan.DepName;
lbSoPhieu.Text = dt.Rows[0]["pdno"].ToString();
string dinhdang = dt.Rows[0]["CFMDate0"].ToString();
string thang = dinhdang.Substring(3, 2);
string ngay = dinhdang.Substring(0, 2);
string nam = dinhdang.Substring(6, 4);
lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + "";
CKEditorControl1.Text = dt.Rows[0]["pdmemovn"].ToString();
DropDownNguoiDich.Enabled = false;
HienThiNguoiDich();
btnLuu.Enabled = false;
btnLuu.Attributes.CssStyle.Add("opacity", "0.3");
}
CKEditorControl1.Enabled = false;
}
protected void Button1_Click(object sender, EventArgs e)
{
string ngonngu = Session["languege"].ToString();
string dem = (pdnaBUS.DemSoLuongVanBan() + 1).ToString();
string maphieu = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyyMMdd") + dem;
string bophan = DropDonVi.SelectedItem.Value.ToString();
string tieude = txtTieuDe.Text;
string noidung = CKEditorControl1.Text;
string bp = DropDonVi.SelectedItem.Text;
string loaiP = DropLoaiPhieu.SelectedItem.Text;
string macongty = Session["congty"].ToString();
string user = Session["user"].ToString();
string ngaythang = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy");
string ngaythang1 = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("Ngày " + "dd" + "Tháng " + "MM" + "Năm" + "yyyy");
//string idphieu = Session["maphieu"].ToString();
string loaiphieu = DropLoaiPhieu.SelectedValue.ToString();
if (loaiphieu != "PDN2")
{
Busers2 timnguoitao = UserBUS.TimNhanVienTheoMa(user, macongty);
if (timnguoitao.IDCapDuyet >= 12)
{
string madonvi = "CBCC";
Session["bp"] = madonvi;
BDepartment bd = BDepartmentBUS.TimMaDonVi(madonvi, macongty);
Busers2 us = UserBUS.TimMaNhanVienTheoBoPhan(user, madonvi, macongty);
if (us == null)
{
Busers2 kiemtra = UserDAO.TimNhanVienQuanLyDonVi(user, madonvi, macongty);
if (kiemtra == null)
{
if (ngonngu == "lbl_VN")
{
lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bd.DepName;
}
else if (ngonngu == "lbl_TW")
{
lbthongbao.Text = "该用户不属于部门 " + bd.DepName;
}
else if (ngonngu == "lbl_EN")
{
lbthongbao.Text = "The user does not belong to the department" + bd.DepName;
}
}
else
{
pdna phieun = new pdna();
{
phieun.pdno = maphieu;
phieun.GSBH = macongty;
phieun.pdno = maphieu;
phieun.Abtype = loaiphieu;
phieun.pddepid = bophan;
phieun.mytitle = tieude;
phieun.pdmemovn = noidung;
phieun.CFMDate0 = DateTime.Parse(ngaythang);
phieun.CFMID0 = user;
phieun.USERID = user;
phieun.dagui = false;
phieun.bixoa = false;
}
db.pdnas.InsertOnSubmit(phieun);
db.SubmitChanges();
Session["bp"] = bophan;
Session["bophan"] = bp;
Session["loaiP"] = loaiP;
Session["loaiphieu"] = loaiphieu;
Session["maphieu"] = maphieu;
Session["noidung"] = noidung;
Session["ngaytao"] = ngaythang;
Session["tieude"] = tieude;
Response.Redirect("FrmViewCB.aspx");
}
Busers2 usertao = UserBUS.TimNhanVienTheoMa(user, macongty);
if (usertao != null && usertao.IDCapDuyet > 12)
{
Response.Redirect("FrmViewCB.aspx");
}
else
{
if (ngonngu == "lbl_VN")
{
lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bd.DepName;
}
else if (ngonngu == "lbl_TW")
{
lbthongbao.Text = "该用户不属于部门 " + bd.DepName;
}
else if (ngonngu == "lbl_EN")
{
lbthongbao.Text = "The user does not belong to the department" + bd.DepName;
}
}
}
else
{
pdna phieun = new pdna();
{
phieun.pdno = maphieu;
phieun.GSBH = macongty;
phieun.pdno = maphieu;
phieun.Abtype = loaiphieu;
phieun.pddepid = bophan;
phieun.mytitle = tieude;
phieun.pdmemovn = noidung;
phieun.CFMDate0 = DateTime.Parse(ngaythang);
phieun.CFMID0 = user;
phieun.USERID = user;
phieun.dagui = false;
phieun.bixoa = false;
}
db.pdnas.InsertOnSubmit(phieun);
db.SubmitChanges();
Session["bp"] = bophan;
Session["bophan"] = bp;
Session["loaiP"] = loaiP;
Session["loaiphieu"] = loaiphieu;
Session["maphieu"] = maphieu;
Session["noidung"] = noidung;
Session["ngaytao"] = ngaythang;
Session["tieude"] = tieude;
Response.Redirect("FrmViewCB.aspx");
}
}
else
{
BDepartment bd = BDepartmentBUS.TimMaDonVi(bophan, macongty);
Busers2 us = UserBUS.TimMaNhanVienTheoBoPhan(user, bophan, macongty);
if (us == null)
{
Busers2 kiemtra = UserDAO.TimNhanVienQuanLyDonVi(user, bophan, macongty);
if (kiemtra == null)
{
if (ngonngu == "lbl_VN")
{
lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bd.DepName;
}
else if (ngonngu == "lbl_TW")
{
lbthongbao.Text = "该用户不属于部门 " + bd.DepName;
}
else if (ngonngu == "lbl_EN")
{
lbthongbao.Text = "The user does not belong to the department" + bd.DepName;
}
}
else
{
pdna phieun = new pdna();
{
phieun.pdno = maphieu;
phieun.GSBH = macongty;
phieun.pdno = maphieu;
phieun.Abtype = loaiphieu;
phieun.pddepid = bophan;
phieun.mytitle = tieude;
phieun.pdmemovn = noidung;
phieun.CFMDate0 = DateTime.Parse(ngaythang);
phieun.CFMID0 = user;
phieun.USERID = user;
phieun.dagui = false;
phieun.bixoa = false;
}
db.pdnas.InsertOnSubmit(phieun);
db.SubmitChanges();
Session["bp"] = bophan;
Session["bophan"] = bp;
Session["loaiP"] = loaiP;
Session["loaiphieu"] = loaiphieu;
Session["maphieu"] = maphieu;
Session["noidung"] = noidung;
Session["ngaytao"] = ngaythang;
Session["tieude"] = tieude;
Response.Redirect("FrmViewCB.aspx");
}
Busers2 usertao = UserBUS.TimNhanVienTheoMa(user, macongty);
if (usertao != null && usertao.IDCapDuyet > 12)
{
}
else
{
if (ngonngu == "lbl_VN")
{
lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bp;
}
else if (ngonngu == "lbl_TW")
{
lbthongbao.Text = "该用户不属于部门 " + bp;
}
else if (ngonngu == "lbl_EN")
{
lbthongbao.Text = "The user does not belong to the department" + bp;
}
}
}
else
{
pdna phieun = new pdna();
{
phieun.pdno = maphieu;
phieun.GSBH = macongty;
phieun.pdno = maphieu;
phieun.Abtype = loaiphieu;
phieun.pddepid = bophan;
phieun.mytitle = tieude;
phieun.pdmemovn = noidung;
phieun.CFMDate0 = DateTime.Parse(ngaythang);
phieun.CFMID0 = user;
phieun.USERID = user;
phieun.dagui = false;
phieun.bixoa = false;
phieun.YN = 6;
}
db.pdnas.InsertOnSubmit(phieun);
db.SubmitChanges();
Session["bp"] = bophan;
Session["bophan"] = bp;
Session["loaiP"] = loaiP;
Session["loaiphieu"] = loaiphieu;
Session["maphieu"] = maphieu;
Session["noidung"] = noidung;
Session["ngaytao"] = ngaythang;
Session["tieude"] = tieude;
Response.Redirect("FrmViewCB.aspx");
}
}
}
else
{
Response.Redirect("FrmViewCB.aspx");
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
// tao phieu mua hang
string ngonngu = Session["languege"].ToString();
//string dem = (pdnaBUS.DemSoLuongVanBan() + 1).ToString();
//string maphieu = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyyMMdd") + "00" + dem;
string maphieu = "";
dalPDN dal = new dalPDN();
DataTable dt = dal.DemSoLuongPhieu();
string aa = dt.Rows[0]["pdno"].ToString().Trim();
if (dt.Rows.Count != 0 && aa != "")
{
string dem = (int.Parse(aa) + 1).ToString();
maphieu = dem;
}
else
{
maphieu = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyyMM") + "00" + 1;
}
string bophan = DropDonVi.SelectedItem.Value.ToString();
string tieude = txtTieuDe.Text;
string noidung = CKEditorControl1.Text;
string bp = DropDonVi.SelectedItem.Text;
string loaiP = DropLoaiPhieu.SelectedItem.Text;
string macongty = Session["congty"].ToString();
string user = Session["user"].ToString();
string ngaythang = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy");
string ngaythang1 = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("Ngày " + "dd" + "Tháng " + "MM" + "Năm" + "yyyy");
//string idphieu = Session["maphieu"].ToString();
string loaiphieu = DropLoaiPhieu.SelectedValue.ToString();
Busers2 timnguoitao = UserBUS.TimNhanVienTheoMa(user, macongty);
if (timnguoitao.IDCapDuyet >= 12)
{
string madonvi = "CBCC";
Session["bp"] = madonvi;
BDepartment bd = BDepartmentBUS.TimMaDonVi(madonvi, macongty);
Busers2 us = UserBUS.TimMaNhanVienTheoBoPhan(user, madonvi, macongty);
if (us == null)
{
Busers2 kiemtra = UserDAO.TimNhanVienQuanLyDonVi(user, madonvi, macongty);
if (kiemtra == null)
{
if (ngonngu == "lbl_VN")
{
lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bd.DepName;
tablePMH.Visible = true;
btnLuuTam.Enabled = false;
btnTiepTu.Enabled = false;
}
else if (ngonngu == "lbl_TW")
{
lbthongbao.Text = "该用户不属于部门 " + bd.DepName;
tablePMH.Visible = true;
btnLuuTam.Enabled = false;
btnTiepTu.Enabled = false;
}
else if (ngonngu == "lbl_EN")
{
lbthongbao.Text = "The user does not belong to the department" + bd.DepName;
tablePMH.Visible = true;
btnLuuTam.Enabled = false;
btnTiepTu.Enabled = false;
}
}
else
{
pdna phieun = new pdna();
{
phieun.GSBH = macongty;
phieun.pdno = maphieu;
phieun.pddepid = bophan;
phieun.mytitle = tieude;
phieun.pdmemovn = noidung;
phieun.CFMDate0 = DateTime.Parse(ngaythang);
phieun.USERID = user;
phieun.Abtype = DropLoaiPhieu.SelectedValue.ToString();
phieun.bixoa = false;
phieun.CFMID0 = user;
phieun.YN = 5;
phieun.bixoa = false;
phieun.USERDATE = DateTime.Parse(ngaythang);
phieun.UseIntent = txtMucDich.Text;
}
db.pdnas.InsertOnSubmit(phieun);
db.SubmitChanges();
string tenhang = txtTenHang.Text;
//string tenhang = dropTenHang.SelectedValue;
string donvitinh = txtdonvitinh.Text;
string soluong = txtSoLuong.Text;
string ghichu = txtGhiChu.Text;
string Size = "";
if (txtSize.Text.Trim() == "")
{
Size = ".";
}
else
{
Size = txtSize.Text.Trim();
}
pdna1 hang = new pdna1();
hang.GSBH = macongty;
hang.pdNO = maphieu;
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'"));
//GridView1.DataSource = db.ExecuteQuery<BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'");
//GridView1.DataBind();
tablePMH.Visible = false;
btnLuuTam.Enabled = true;
btnTiepTu.Enabled = true;
}
Busers2 usertao = UserBUS.TimNhanVienTheoMa(user, macongty);
if (usertao != null && usertao.IDCapDuyet > 12)
{
Response.Redirect("FrmViewCB.aspx");
}
else
{
if (ngonngu == "lbl_VN")
{
lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bd.DepName;
tablePMH.Visible = true;
btnLuuTam.Enabled = false;
btnTiepTu.Enabled = false;
}
else if (ngonngu == "lbl_TW")
{
lbthongbao.Text = "该用户不属于部门 " + bd.DepName;
tablePMH.Visible = true;
btnLuuTam.Enabled = false;
btnTiepTu.Enabled = false;
}
else if (ngonngu == "lbl_EN")
{
lbthongbao.Text = "The user does not belong to the department" + bd.DepName;
tablePMH.Visible = true;
btnLuuTam.Enabled = false;
btnTiepTu.Enabled = false;
}
}
}
else
{
pdna phieun = new pdna();
{
phieun.GSBH = macongty;
phieun.pdno = maphieu;
phieun.pddepid = bophan;
phieun.mytitle = tieude;
phieun.pdmemovn = noidung;
phieun.CFMDate0 = DateTime.Parse(ngaythang);
phieun.USERID = user;
phieun.Abtype = DropLoaiPhieu.SelectedValue.ToString();
phieun.bixoa = false;
phieun.CFMID0 = user;
phieun.YN = 5;
phieun.bixoa = false;
phieun.USERDATE = DateTime.Parse(ngaythang);
phieun.UseIntent = txtMucDich.Text;
}
db.pdnas.InsertOnSubmit(phieun);
db.SubmitChanges();
string tenhang = txtTenHang.Text;
//string tenhang = dropTenHang.SelectedValue;
string donvitinh = txtdonvitinh.Text;
string soluong = txtSoLuong.Text;
string ghichu = txtGhiChu.Text;
BOfSupply hang = new BOfSupply();
hang.GSBH = macongty;
hang.pdno = maphieu;
hang.OfSuppliesName = tenhang;
hang.BUnit = donvitinh;
hang.BNumber = int.Parse(soluong);
hang.BCommnent = ghichu;
SuppliesDAO.ThemVatTu(hang);
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'"));
//GridView1.DataSource = db.ExecuteQuery<BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'");
//GridView1.DataBind();
tablePMH.Visible = false;
btnLuuTam.Enabled = true;
btnTiepTu.Enabled = true;
}
}
else
{
BDepartment bd = BDepartmentBUS.TimMaDonVi(bophan, macongty);
Busers2 us = UserBUS.TimMaNhanVienTheoBoPhan(user, bophan, macongty);
if (us == null)
{
Busers2 kiemtra = UserDAO.TimNhanVienQuanLyDonVi(user, bophan, macongty);
if (kiemtra == null)
{
if (ngonngu == "lbl_VN")
{
lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bd.DepName;
tablePMH.Visible = true;
btnLuuTam.Enabled = false;
btnTiepTu.Enabled = false;
}
else if (ngonngu == "lbl_TW")
{
lbthongbao.Text = "该用户不属于部门 " + bd.DepName;
tablePMH.Visible = true;
btnLuuTam.Enabled = false;
btnTiepTu.Enabled = false;
}
else if (ngonngu == "lbl_EN")
{
lbthongbao.Text = "The user does not belong to the department" + bd.DepName;
tablePMH.Visible = true;
btnLuuTam.Enabled = false;
btnTiepTu.Enabled = false;
}
}
else
{
pdna phieun = new pdna();
{
phieun.GSBH = macongty;
phieun.pdno = maphieu;
phieun.pddepid = bophan;
phieun.mytitle = tieude;
phieun.pdmemovn = noidung;
phieun.CFMDate0 = DateTime.Parse(ngaythang);
phieun.USERID = user;
phieun.Abtype = DropLoaiPhieu.SelectedValue.ToString();
phieun.bixoa = false;
phieun.CFMID0 = user;
phieun.YN = 5;
phieun.bixoa = false;
phieun.USERDATE = DateTime.Parse(ngaythang);
phieun.UseIntent = txtMucDich.Text;
}
db.pdnas.InsertOnSubmit(phieun);
db.SubmitChanges();
string tenhang = txtTenHang.Text.ToUpper();
//string tenhang = dropTenHang.SelectedValue;
string donvitinh = txtdonvitinh.Text.ToUpper();
string soluong = txtSoLuong.Text;
string ghichu = txtGhiChu.Text;
BOfSupply hang = new BOfSupply();
hang.GSBH = macongty;
hang.pdno = maphieu;
hang.OfSuppliesName = tenhang;
hang.BUnit = donvitinh;
hang.BNumber = int.Parse(soluong);
hang.BCommnent = ghichu;
SuppliesDAO.ThemVatTu(hang);
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'"));
//GridView1.DataSource = db.ExecuteQuery<BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'");
//GridView1.DataBind();
tablePMH.Visible = false;
btnLuuTam.Enabled = true;
btnTiepTu.Enabled = true;
}
//Busers2 usertao = UserBUS.TimNhanVienTheoMa(user, macongty);
//if (usertao != null && usertao.IDCapDuyet > 12)
//{
//}
//else
//{
// if (ngonngu == "lbl_VN")
// {
// lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bp;
// }
// else if (ngonngu == "lbl_TW")
// {
// lbthongbao.Text = "该用户不属于部门 " + bp;
// }
// else if (ngonngu == "lbl_EN")
// {
// lbthongbao.Text = "The user does not belong to the department" + bp;
// }
//}
}
else
{
pdna phieun = new pdna();
{
phieun.GSBH = macongty;
phieun.pdno = maphieu;
phieun.pddepid = bophan;
phieun.mytitle = tieude;
phieun.pdmemovn = noidung;
phieun.CFMDate0 = DateTime.Parse(ngaythang);
phieun.USERID = user;
phieun.Abtype = DropLoaiPhieu.SelectedValue.ToString();
phieun.bixoa = false;
phieun.CFMID0 = user;
phieun.YN = 5;
phieun.bixoa = false;
phieun.USERDATE = DateTime.Parse(ngaythang);
phieun.UseIntent = txtMucDich.Text;
}
db.pdnas.InsertOnSubmit(phieun);
db.SubmitChanges();
string tenhang = txtTenHang.Text;
//string tenhang = dropTenHang.SelectedValue;
string donvitinh = txtdonvitinh.Text;
string soluong = txtSoLuong.Text;
string ghichu = txtGhiChu.Text;
BOfSupply hang = new BOfSupply();
hang.GSBH = macongty;
hang.pdno = maphieu;
hang.OfSuppliesName = tenhang;
hang.BUnit = donvitinh;
hang.BNumber = int.Parse(soluong);
hang.BCommnent = ghichu;
SuppliesDAO.ThemVatTu(hang);
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'"));
//GridView1.DataSource = db.ExecuteQuery<BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'");
//GridView1.DataBind();
tablePMH.Visible = false;
btnLuuTam.Enabled = true;
btnTiepTu.Enabled = true;
}
}
// them vat tu
Session["bp"] = bophan;
Session["bophan"] = bp;
Session["loaiP"] = loaiP;
Session["loaiphieu"] = loaiphieu;
Session["maphieu"] = maphieu;
Session["noidung"] = noidung;
Session["ngaytao"] = ngaythang;
Session["tieude"] = tieude;
}
