/// <summary> /// lay hang hoa theo ma tra lai nha cung cap /// </summary> /// <param name="truyen"></param> public Entities.LayHangHoaTheoMaKhachHangTraLai[] LayHangHoaTheoMaTraLaiNhaCungCap(Entities.TruyenGiaTri truyen) { Entities.LayHangHoaTheoMaKhachHangTraLai[] arrC = null; try { string sql = "exec sp_LayHangHoaTheoMaTraLaiNhaCungCap @MaTraLaiNhaCungCap"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("MaTraLaiNhaCungCap", SqlDbType.VarChar, 20).Value = truyen.Giatritruyen; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.LayHangHoaTheoMaKhachHangTraLai bang = new Entities.LayHangHoaTheoMaKhachHangTraLai(); bang.Mahanghoa = dr[0].ToString(); bang.Tenhanghoa = dr[1].ToString(); bang.Soluong = int.Parse(dr[2].ToString()); bang.Giaban = dr[3].ToString(); string phantram = "0"; string chietkhau = "0"; string tong = "0"; if (Double.Parse(dr[4].ToString()) == 0) { tong = new Common.Utilities().FormatMoney(int.Parse(dr[2].ToString()) * Double.Parse(dr[3].ToString())); chietkhau = tong; } else { phantram = dr[4].ToString(); tong = new Common.Utilities().FormatMoney(int.Parse(dr[2].ToString()) * Double.Parse(dr[3].ToString())); chietkhau = new Common.Utilities().FormatMoney(Double.Parse(tong) - ((Double.Parse(phantram) / 100 * Double.Parse(dr[3].ToString())) * int.Parse(dr[2].ToString()))); } bang.Phantramchietkhau = phantram; bang.Thuegiatrigiatang = dr[5].ToString(); bang.Chietkhau = chietkhau; bang.Tongtien = tong; arr.Add(bang); } int n = arr.Count; if (n == 0) { arrC = null; } arrC = new Entities.LayHangHoaTheoMaKhachHangTraLai[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.LayHangHoaTheoMaKhachHangTraLai)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); arrC = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(arrC); }
private void XuLy() { try { lay = new Common.Utilities(); ServerConfig config = lay.ReadConfig(); Luu.Server = "" + config.Server; Luu.IP = "" + config.Ip; Luu.Ports = Convert.ToInt32(0 + config.Port); if (config.Server == "client") { this.Hide(); frmSQL fr = new frmSQL(); fr.Show(); } else { if (config.Server == "server") { server = new Server_Client.Server(Luu.Ports); Luu.maychu = server; this.Hide(); frmSQL fr = new frmSQL(); fr.Show(); } else { timer1.Stop(); count = 0; RunCount = 0; frmServerConfig frm = new frmServerConfig(); frm.ShowDialog(); timer1.Start(); } } } catch (Exception ex) { string s = ex.Message.ToString(); Application.Exit(); } }
public bool Update(Entities.SoDuCongNo[] sdcn) { int soluong = 0; Entities.SoDuCongNo[] hienthi = Select(); // nếu obj null int year1 = 0; int month1 = 0; if (hienthi == null) { hienthi = new SoDuCongNo[0]; } else { bool k1 = false; Entities.SoDuCongNo[] sdc = new SoDuCongNo[hienthi.Length]; // kiểm tra số dư hiện tại for (int i = 0; i < sdc.Length; i++) { k1 = false; int nam1 = sdcn[0].NgayKetChuyen.Year; int thang1 = sdcn[0].NgayKetChuyen.Month; if (nam1 == hienthi[i].NgayKetChuyen.Year && thang1 == hienthi[i].NgayKetChuyen.Month && sdcn[0].LoaiDoiTuong == hienthi[i].LoaiDoiTuong) { k1 = true; break; } } if (k1 == true) { for (int i = 0; i < sdc.Length; i++) { if (sdcn[0].NgayKetChuyen.Year == hienthi[i].NgayKetChuyen.Year && sdcn[0].NgayKetChuyen.Month == hienthi[i].NgayKetChuyen.Month && sdcn[0].LoaiDoiTuong == hienthi[i].LoaiDoiTuong) { year1 = sdcn[0].NgayKetChuyen.Year; month1 = sdcn[0].NgayKetChuyen.Month; sdc[soluong] = hienthi[i]; soluong++; } } hienthi = new SoDuCongNo[soluong]; for (int i = 0; i < soluong; i++) { hienthi[i] = sdc[i]; } } else { for (int i = 0; i < sdc.Length; i++) { if (sdcn[0].NgayKetChuyen.Month != 1) { if (sdcn[0].NgayKetChuyen.Year == hienthi[i].NgayKetChuyen.Year && (sdcn[0].NgayKetChuyen.Month - 1) == hienthi[i].NgayKetChuyen.Month && sdcn[0].LoaiDoiTuong == hienthi[i].LoaiDoiTuong) { Convert.ToDateTime((hienthi[0].NgayKetChuyen.Month - 1).ToString() + "/01/" + (hienthi[0].NgayKetChuyen.Year).ToString()); year1 = hienthi[0].NgayKetChuyen.Year; month1 = hienthi[0].NgayKetChuyen.Month - 1; sdc[soluong] = hienthi[i]; soluong++; } } else { if ((sdcn[0].NgayKetChuyen.Year - 1) == hienthi[i].NgayKetChuyen.Year && 12 == hienthi[i].NgayKetChuyen.Month && sdcn[0].LoaiDoiTuong == hienthi[i].LoaiDoiTuong) { year1 = hienthi[0].NgayKetChuyen.Year; month1 = 12; hienthi[i].NgayKetChuyen = Convert.ToDateTime(12.ToString() + "/01/" + year1.ToString()); sdc[soluong] = hienthi[i]; soluong++; } } } hienthi = new SoDuCongNo[soluong]; for (int i = 0; i < soluong; i++) { hienthi[i] = sdc[i]; } } } Entities.SoDuCongNo[] mangluu; int sotang = 0; // đếm số bản ghi tồn tại rồi for (int i = 0; i < hienthi.Length; i++) { if (hienthi[i].LoaiDoiTuong == sdcn[0].LoaiDoiTuong) { if (sdcn[0].MaDoiTuong != null) { sotang++; } } } if (hienthi.Length == 0) { mangluu = new SoDuCongNo[sotang]; } else { mangluu = new SoDuCongNo[hienthi.Length]; } sotang = 0; bool kt1 = true; // gán giá trị cho obj mangluu khởi tạo if (hienthi.Length == 0) { for (int i = 0; i < hienthi.Length; i++) { if (hienthi[i].LoaiDoiTuong == sdcn[0].LoaiDoiTuong) { mangluu[sotang] = hienthi[i]; sotang++; } } } else { for (int i = 0; i < hienthi.Length; i++) { mangluu[i] = hienthi[i]; } } bool kt = false; for (int i = 0; i < sdcn.Length; i++) { kt = false; for (int j = 0; j < mangluu.Length; j++) { if (sdcn[i].MaDoiTuong == mangluu[j].MaDoiTuong && sdcn[0].LoaiDoiTuong == mangluu[j].LoaiDoiTuong) { kt = true; break; } } string maSoDuCongNo = ""; Entities.LayID b = new LayID("", "SoDuCongNo"); b = (Entities.LayID) new BizLogic.Lay_ID().Select(b); if (b == null) { maSoDuCongNo = "SDCN_0001"; } else { maSoDuCongNo = new Common.Utilities().ProcessID(b.ID); } if (kt == true) { sdcn[i].MaSoDuCongNo = hienthi[i].MaSoDuCongNo; Update(sdcn[i]); int nam = sdcn[i].NgayKetChuyen.Year; int thang = sdcn[i].NgayKetChuyen.Month; int namhientai = 0; int thanghientai = 0; if (hienthi.Length == 0) { namhientai = DateTime.Now.Year; thanghientai = DateTime.Now.Month; } else { namhientai = hienthi[0].NgayKetChuyen.Year; thanghientai = hienthi[0].NgayKetChuyen.Month; } Entities.SoDuCongNo a; if (nam == namhientai && thang == thanghientai) { if (thang == 12) { a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime("01/01/" + (namhientai + 1).ToString()), "0", sdcn[i].LoaiDoiTuong, false); } else { a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime((thang + 1).ToString() + "/01/" + namhientai.ToString()), "0", sdcn[i].LoaiDoiTuong, false); } } else if (thanghientai == 12) { a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime(thang.ToString() + "/01/" + (namhientai + 1).ToString()), "0", sdcn[i].LoaiDoiTuong, false); } else { a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, DateTime.Now, "0", sdcn[i].LoaiDoiTuong, false); } Insert(a); } else { int nam = sdcn[i].NgayKetChuyen.Year; int thang = sdcn[i].NgayKetChuyen.Month; int namhientai = DateTime.Now.Year; int thanghientai = DateTime.Now.Month; Entities.SoDuCongNo a; if (sdcn[0].MaDoiTuong != null) { //a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, "0", Convert.ToDateTime(thang + "/01/" + nam), sdcn[i].SoDuCuoiKy, sdcn[i].LoaiDoiTuong, true); a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, "0", new DateTime(nam, thang, 1), sdcn[i].SoDuCuoiKy, sdcn[i].LoaiDoiTuong, true); Insert(a); //if (nam == namhientai && thang == thanghientai) //{ // if (thang == 12) // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime("01/01/" + (namhientai + 1).ToString()), "0", sdcn[i].LoaiDoiTuong, false); // else // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime((thang + 1).ToString() + "/01/" + namhientai.ToString()), "0", sdcn[i].LoaiDoiTuong, false); //} //else // if (thang == 12) // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime(thang.ToString() + "/01/" + (namhientai).ToString()), "0", sdcn[i].LoaiDoiTuong, false); // else // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, DateTime.Now, "0", sdcn[i].LoaiDoiTuong, false); a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, new DateTime(nam, thang, 1).AddMonths(1), "0", sdcn[i].LoaiDoiTuong, false); Insert(a); } else { //Có rồi thì update ngày kết chuyển = DateTime.Now a = new SoDuCongNo(hienthi[i].MaSoDuCongNo, hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, "0", DateTime.Now, hienthi[i].SoDuDauKy, hienthi[i].LoaiDoiTuong, true); Update(a); //gán số dư cuối kỳ, trạng thái = 1 where mã số dư công nợ, loại đối tượng //if (nam == namhientai && thang == thanghientai) //{ // if (thang == 12) // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, Convert.ToDateTime("01/01/" + (namhientai + 1).ToString()), "0", hienthi[i].LoaiDoiTuong, false); // else // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, Convert.ToDateTime((thang + 1).ToString() + "/01/" + namhientai.ToString()), "0", hienthi[i].LoaiDoiTuong, false); //} //else // if (thang == 12) // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, Convert.ToDateTime(thang.ToString() + "/01/" + (namhientai).ToString()), "0", hienthi[i].LoaiDoiTuong, false); // else // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, DateTime.Now, "0", hienthi[i].LoaiDoiTuong, false); a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, new DateTime(nam, thang, 1).AddMonths(1), "0", hienthi[i].LoaiDoiTuong, false); Insert(a); } } } return(true); }
/// <summary> /// lay hang hoa theo ma khach hang tra lai /// </summary> /// <param name="lay"></param> /// <returns></returns> //public Entities.LayHangHoaTheoMaKhachHangTraLai[] sp_LayHangHoaTheoMaKhachHangTraLai(Entities.TruyenGiaTri lay) //{ // Entities.LayHangHoaTheoMaKhachHangTraLai[] arrC = null; // try // { // string sql = "exec sp_LayHangHoaTheoMaKhachHangTraLai @MaKhachHangTraLai,@LoaiHoaDon"; // conn = new Connection(); // cn = conn.openConnection(); // cmd = new SqlCommand(sql, cn); // cmd.Parameters.Add("MaKhachHangTraLai", SqlDbType.VarChar, 20).Value = lay.Giatritruyen; // cmd.Parameters.Add("LoaiHoaDon", SqlDbType.VarChar, 20).Value = lay.Giatrithuhai; // dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // arr = new ArrayList(); // while (dr.Read()) // { // Entities.LayHangHoaTheoMaKhachHangTraLai bang = new Entities.LayHangHoaTheoMaKhachHangTraLai(); // bang.Mahanghoa = dr[0].ToString(); // bang.Tenhanghoa = dr[1].ToString(); // bang.Soluong = int.Parse(dr[2].ToString()); // bang.Giaban = dr[3].ToString(); // string phantram = "0"; // string chietkhau = "0"; // string tong = "0"; // if (Double.Parse(dr[4].ToString()) == 0) // { // tong = new Common.Utilities().FormatMoney(int.Parse(dr[2].ToString()) * Double.Parse(dr[3].ToString())); // chietkhau = tong; // } // else // { // phantram = dr[4].ToString(); // tong = new Common.Utilities().FormatMoney(int.Parse(dr[2].ToString()) * Double.Parse(dr[3].ToString())); // chietkhau = new Common.Utilities().FormatMoney(Double.Parse(tong) - ((Double.Parse(phantram) / 100 * Double.Parse(dr[3].ToString())) * int.Parse(dr[2].ToString()))); // } // bang.Phantramchietkhau = phantram; // bang.Thuegiatrigiatang = dr[5].ToString(); // bang.Chietkhau = chietkhau; // bang.Tongtien = tong; // arr.Add(bang); // } // int n = arr.Count; // if (n == 0) { arrC= null; } // arrC = new Entities.LayHangHoaTheoMaKhachHangTraLai[n]; // for (int i = 0; i < n; i++) // { // arrC[i] = (Entities.LayHangHoaTheoMaKhachHangTraLai)arr[i]; // } // } // catch (Exception ex) // { string s = ex.Message.ToString(); arrC = null; } // finally // { // cmd.Connection.Dispose(); // cn.Close(); // conn.closeConnection(); // } // return arrC; //} public Entities.LayHangHoaTheoMaKhachHangTraLai[] sp_LayHangHoaTheoMaKhachHangTraLai(Entities.TruyenGiaTri lay) { Entities.LayHangHoaTheoMaKhachHangTraLai[] arrC = null; try { string sql = "exec sp_LayHangHoaTheoMaKhachHangTraLai @MaKhachHangTraLai,@MaKhachHang,@MaHDBanHang"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("MaKhachHangTraLai", SqlDbType.VarChar, 20).Value = lay.Giatritruyen; cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar, 20).Value = lay.Giatrithuhai; cmd.Parameters.Add("MaHDBanHang", SqlDbType.VarChar, 20).Value = lay.Giatriba; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.LayHangHoaTheoMaKhachHangTraLai bang = new Entities.LayHangHoaTheoMaKhachHangTraLai(); bang.Mahanghoa = dr[0].ToString(); bang.Tenhanghoa = dr[1].ToString(); bang.Soluong = int.Parse(dr[2].ToString()); bang.Giaban = dr[3].ToString(); string phantram = "0"; string chietkhau = "0"; string tong = "0"; if (Double.Parse(dr[4].ToString()) == 0) { tong = new Common.Utilities().FormatMoney(int.Parse(dr[2].ToString()) * Double.Parse(dr[3].ToString())); chietkhau = tong; } else { phantram = dr[4].ToString(); tong = new Common.Utilities().FormatMoney(int.Parse(dr[2].ToString()) * Double.Parse(dr[3].ToString())); chietkhau = new Common.Utilities().FormatMoney(Double.Parse(tong) - ((Double.Parse(phantram) / 100 * Double.Parse(dr[3].ToString())) * int.Parse(dr[2].ToString()))); } bang.Phantramchietkhau = phantram; bang.Thuegiatrigiatang = dr[5].ToString(); bang.Chietkhau = chietkhau; bang.Tongtien = tong; arr.Add(bang); } int n = arr.Count; if (n == 0) { arrC = null; } arrC = new Entities.LayHangHoaTheoMaKhachHangTraLai[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.LayHangHoaTheoMaKhachHangTraLai)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); arrC = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return arrC; }
public bool Update(Entities.SoDuCongNo[] sdcn) { int soluong = 0; Entities.SoDuCongNo[] hienthi = Select(); // nếu obj null int year1 = 0; int month1 = 0; if (hienthi == null) { hienthi = new SoDuCongNo[0]; } else { bool k1 = false; Entities.SoDuCongNo[] sdc = new SoDuCongNo[hienthi.Length]; // kiểm tra số dư hiện tại for (int i = 0; i < sdc.Length; i++) { k1 = false; int nam1 = sdcn[0].NgayKetChuyen.Year; int thang1 = sdcn[0].NgayKetChuyen.Month; if (nam1 == hienthi[i].NgayKetChuyen.Year && thang1 == hienthi[i].NgayKetChuyen.Month && sdcn[0].LoaiDoiTuong == hienthi[i].LoaiDoiTuong) { k1 = true; break; } } if (k1 == true) { for (int i = 0; i < sdc.Length; i++) { if (sdcn[0].NgayKetChuyen.Year == hienthi[i].NgayKetChuyen.Year && sdcn[0].NgayKetChuyen.Month == hienthi[i].NgayKetChuyen.Month && sdcn[0].LoaiDoiTuong == hienthi[i].LoaiDoiTuong) { year1 = sdcn[0].NgayKetChuyen.Year; month1 = sdcn[0].NgayKetChuyen.Month; sdc[soluong] = hienthi[i]; soluong++; } } hienthi = new SoDuCongNo[soluong]; for (int i = 0; i < soluong; i++) { hienthi[i] = sdc[i]; } } else { for (int i = 0; i < sdc.Length; i++) { if (sdcn[0].NgayKetChuyen.Month != 1) { if (sdcn[0].NgayKetChuyen.Year == hienthi[i].NgayKetChuyen.Year && (sdcn[0].NgayKetChuyen.Month - 1) == hienthi[i].NgayKetChuyen.Month && sdcn[0].LoaiDoiTuong == hienthi[i].LoaiDoiTuong) { Convert.ToDateTime((hienthi[0].NgayKetChuyen.Month - 1).ToString() + "/01/" + (hienthi[0].NgayKetChuyen.Year).ToString()); year1 = hienthi[0].NgayKetChuyen.Year; month1 = hienthi[0].NgayKetChuyen.Month-1; sdc[soluong] = hienthi[i]; soluong++; } } else { if ((sdcn[0].NgayKetChuyen.Year - 1) == hienthi[i].NgayKetChuyen.Year && 12 == hienthi[i].NgayKetChuyen.Month && sdcn[0].LoaiDoiTuong == hienthi[i].LoaiDoiTuong) { year1 = hienthi[0].NgayKetChuyen.Year; month1 = 12; hienthi[i].NgayKetChuyen = Convert.ToDateTime(12.ToString() + "/01/" + year1.ToString()); sdc[soluong] = hienthi[i]; soluong++; } } } hienthi = new SoDuCongNo[soluong]; for (int i = 0; i < soluong; i++) { hienthi[i] = sdc[i]; } } } Entities.SoDuCongNo[] mangluu; int sotang = 0; // đếm số bản ghi tồn tại rồi for (int i = 0; i < hienthi.Length; i++) { if (hienthi[i].LoaiDoiTuong == sdcn[0].LoaiDoiTuong) { if (sdcn[0].MaDoiTuong != null) sotang++; } } if (hienthi.Length == 0) mangluu = new SoDuCongNo[sotang]; else mangluu = new SoDuCongNo[hienthi.Length]; sotang = 0; bool kt1 = true; // gán giá trị cho obj mangluu khởi tạo if (hienthi.Length == 0) { for (int i = 0; i < hienthi.Length; i++) { if (hienthi[i].LoaiDoiTuong == sdcn[0].LoaiDoiTuong) { mangluu[sotang] = hienthi[i]; sotang++; } } } else { for (int i = 0; i < hienthi.Length; i++) { mangluu[i] = hienthi[i]; } } bool kt = false; for (int i = 0; i < sdcn.Length; i++) { kt = false; for (int j = 0; j < mangluu.Length; j++) { if (sdcn[i].MaDoiTuong == mangluu[j].MaDoiTuong && sdcn[0].LoaiDoiTuong == mangluu[j].LoaiDoiTuong) { kt = true; break; } } string maSoDuCongNo = ""; Entities.LayID b = new LayID("", "SoDuCongNo"); b = (Entities.LayID)new BizLogic.Lay_ID().Select(b); if (b == null) { maSoDuCongNo = "SDCN_0001"; } else { maSoDuCongNo = new Common.Utilities().ProcessID(b.ID); } if (kt == true) { sdcn[i].MaSoDuCongNo = hienthi[i].MaSoDuCongNo; Update(sdcn[i]); int nam = sdcn[i].NgayKetChuyen.Year; int thang = sdcn[i].NgayKetChuyen.Month; int namhientai=0; int thanghientai=0; if (hienthi.Length == 0) { namhientai = DateTime.Now.Year; thanghientai = DateTime.Now.Month; } else { namhientai = hienthi[0].NgayKetChuyen.Year; thanghientai = hienthi[0].NgayKetChuyen.Month; } Entities.SoDuCongNo a; if (nam == namhientai && thang == thanghientai) { if (thang == 12) a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime("01/01/" + (namhientai + 1).ToString()), "0", sdcn[i].LoaiDoiTuong, false); else a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime((thang + 1).ToString() + "/01/" + namhientai.ToString()), "0", sdcn[i].LoaiDoiTuong, false); } else if (thanghientai == 12) a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime(thang.ToString() + "/01/" + (namhientai + 1).ToString()), "0", sdcn[i].LoaiDoiTuong, false); else a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, DateTime.Now, "0", sdcn[i].LoaiDoiTuong, false); Insert(a); } else { int nam = sdcn[i].NgayKetChuyen.Year; int thang = sdcn[i].NgayKetChuyen.Month; int namhientai = DateTime.Now.Year; int thanghientai = DateTime.Now.Month; Entities.SoDuCongNo a; if (sdcn[0].MaDoiTuong != null) { //a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, "0", Convert.ToDateTime(thang + "/01/" + nam), sdcn[i].SoDuCuoiKy, sdcn[i].LoaiDoiTuong, true); a = new SoDuCongNo(maSoDuCongNo, sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, "0", new DateTime(nam, thang, 1), sdcn[i].SoDuCuoiKy, sdcn[i].LoaiDoiTuong, true); Insert(a); //if (nam == namhientai && thang == thanghientai) //{ // if (thang == 12) // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime("01/01/" + (namhientai + 1).ToString()), "0", sdcn[i].LoaiDoiTuong, false); // else // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime((thang + 1).ToString() + "/01/" + namhientai.ToString()), "0", sdcn[i].LoaiDoiTuong, false); //} //else // if (thang == 12) // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, Convert.ToDateTime(thang.ToString() + "/01/" + (namhientai).ToString()), "0", sdcn[i].LoaiDoiTuong, false); // else // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, DateTime.Now, "0", sdcn[i].LoaiDoiTuong, false); a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), sdcn[i].MaDoiTuong, sdcn[i].TenDoiTuong, sdcn[i].DiaChi, sdcn[i].SoDuCuoiKy, new DateTime(nam, thang, 1).AddMonths(1), "0", sdcn[i].LoaiDoiTuong, false); Insert(a); } else {//Có rồi thì update ngày kết chuyển = DateTime.Now a = new SoDuCongNo(hienthi[i].MaSoDuCongNo, hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, "0", DateTime.Now, hienthi[i].SoDuDauKy, hienthi[i].LoaiDoiTuong, true); Update(a); //gán số dư cuối kỳ, trạng thái = 1 where mã số dư công nợ, loại đối tượng //if (nam == namhientai && thang == thanghientai) //{ // if (thang == 12) // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, Convert.ToDateTime("01/01/" + (namhientai + 1).ToString()), "0", hienthi[i].LoaiDoiTuong, false); // else // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, Convert.ToDateTime((thang + 1).ToString() + "/01/" + namhientai.ToString()), "0", hienthi[i].LoaiDoiTuong, false); //} //else // if (thang == 12) // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, Convert.ToDateTime(thang.ToString() + "/01/" + (namhientai).ToString()), "0", hienthi[i].LoaiDoiTuong, false); // else // a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, DateTime.Now, "0", hienthi[i].LoaiDoiTuong, false); a = new SoDuCongNo(new Common.Utilities().ProcessID(maSoDuCongNo), hienthi[i].MaDoiTuong, hienthi[i].TenDoiTuong, hienthi[i].DiaChi, hienthi[i].SoDuDauKy, new DateTime(nam, thang, 1).AddMonths(1), "0", hienthi[i].LoaiDoiTuong, false); Insert(a); } } } return true; }