public WorldInfo[] GetAllWorlds() { _db.Open(); List<WorldInfo> worlds = new List<WorldInfo>(); DbDataReader reader = _db.ExcecuteReader(DbNames.GETALLWORLDS_STOREDPROC, System.Data.CommandType.StoredProcedure, null); int ordinalId = reader.GetOrdinal(DbNames.WORLDINFO_ID); int ordinalName = reader.GetOrdinal(DbNames.WORLDINFO_NAME); int ordinalDesc = reader.GetOrdinal(DbNames.WORLDINFO_DESC); int ordinalIP = reader.GetOrdinal(DbNames.WORLDINFO_IP); int ordinalPort = reader.GetOrdinal(DbNames.WORLDINFO_PORT); while (reader.Read()) { WorldInfo world = new WorldInfo { WorldId = reader.GetInt32(ordinalId), WorldName = reader.GetString(ordinalName), WorldDesc = reader.GetString(ordinalDesc), IPAddress = reader.GetString(ordinalIP), Port = reader.GetInt32(ordinalPort) }; worlds.Add(world); } reader.Close(); _db.Close(); return worlds.ToArray(); }
public ChannelInfo[] GetAllChannels() { _db.Open(); List<ChannelInfo> channels = new List<ChannelInfo>(); DbDataReader reader = _db.ExcecuteReader(DbNames.GETALLCHANNELS_STOREDPROC, System.Data.CommandType.StoredProcedure, null); int ordinalId = reader.GetOrdinal(DbNames.CHANNELINFO_ID); int ordinalName = reader.GetOrdinal(DbNames.CHANNELINFO_NAME); int ordinalDesc = reader.GetOrdinal(DbNames.CHANNELINFO_DESC); int ordinalIP = reader.GetOrdinal(DbNames.CHANNELINFO_IP); int ordinalPort = reader.GetOrdinal(DbNames.CHANNELINFO_PORT); int ordinalPK = reader.GetOrdinal(DbNames.CHANNELINFO_PK); while (reader.Read()) { ChannelInfo channel = new ChannelInfo { ChannelId = reader.GetInt32(ordinalId), ChannelName = reader.GetString(ordinalName), ChannelDesc = reader.GetString(ordinalDesc), IPAddress = reader.GetString(ordinalIP), Port = reader.GetInt32(ordinalPort), PK = reader.GetBoolean(ordinalPK) }; channels.Add(channel); } reader.Close(); _db.Close(); return channels.ToArray(); }
public frmQuanLyMaVach(List<ThongTinMaVach> dsThongTinMaVach) { InitializeComponent(); IniForm(); //Gán dữ liệu dgvHangHoa.DataSource = dsThongTinMaVach.ToArray(); FixDatagridview(); }
public void CheckDataGridCongSL(DataGridView dgv, string maKho) { if (dgv.RowCount != 0) { try { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.ChiTietKhoHangTheoHoaHonNhap nv = new Entities.ChiTietKhoHangTheoHoaHonNhap("Select"); clientstrem = cl.SerializeObj(this.client1, "ChiTietKho", nv); Entities.ChiTietKhoHangTheoHoaHonNhap[] kh1 = new Entities.ChiTietKhoHangTheoHoaHonNhap[1]; kh1 = (Entities.ChiTietKhoHangTheoHoaHonNhap[])cl.DeserializeHepper1(clientstrem, kh1); List<Entities.ChiTietKhoHangTheoHoaHonNhap> ctList = new List<Entities.ChiTietKhoHangTheoHoaHonNhap>(); for (int i = 0; i < dgv.RowCount; i++) { bool retVal = false; foreach (Entities.ChiTietKhoHangTheoHoaHonNhap item in kh1) { if (dgv["MaHangHoa", i].Value.ToString().ToUpper().Equals(item.Mahanghoa.ToUpper()) && maKho.Equals(item.Makho)) { retVal = true; break; } } if (!retVal) { Entities.ChiTietKhoHangTheoHoaHonNhap ct = new Entities.ChiTietKhoHangTheoHoaHonNhap(); ct.Hanhdong = "Insert"; ct.Mahanghoa = dgv["MaHangHoa", i].Value.ToString(); ct.Makho = maKho; ct.Ngaynhap = DateServer.Date(); DateTime ngayHetHan = DateTime.Now; if (dgv["NgayHetHan", i] != null) ngayHetHan = (DateTime)dgv["NgayHetHan", i].Value; ct.Ngayhethan = ngayHetHan; ct.Soluong = int.Parse(dgv["SoLuong", i].Value.ToString()); ct.Ghichu = ""; ctList.Add(ct); } } Server_Client.Client cl1 = new Server_Client.Client(); this.client1 = cl1.Connect(Luu.IP, Luu.Ports); clientstrem = cl1.SerializeObj(this.client1, "ThemChiTietKhoHang", ctList.ToArray()); } catch (Exception) { } } }
private static void Main() { var startTime = DateTime.Now; var settings = new Settings(); var helper = new Helper(settings); var tasks = new List<Task<ImageDetails>>(); // Get the ID's var imageIds = GetImageIds(); // Create the Tasks foreach (var imageId in imageIds) { var task = new Task<ImageDetails>(() => AcquireImage(new ImageServiceClient(), imageId).Result); task.Start(); tasks.Add(task); } // wait for the tasks Task.WaitAll(tasks.ToArray()); // write out the files using (var writer = helper.GetOutputWriter()) { writer.WriteLine(Image.GetHeaderString()); foreach (var task in tasks) { helper.WriteImageFile(task.Result.ImageBytes, task.Result.Metadata.FileName); writer.WriteLine(task.Result.Metadata); } } Console.WriteLine("{0} images processed.", tasks.Count); Console.WriteLine("Creating zip file."); helper.WriteZipFile(); helper.Cleanup(); Console.WriteLine("Done."); var elapsed = DateTime.Now - startTime; Console.WriteLine("Elapsed time: {0}", elapsed); #if DEBUG Console.Write("<Enter> to quit."); Console.ReadLine(); #endif }
public CascadingDropDownNameValue[] GetAmandamentTemplates(string knownCategoryValues, string category, string contextKey) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<AmandamentTemplateEntity> list = new AmandamentTemplateMapper().ListWithAdvancedFilter("", StatusEnum.Active); foreach (AmandamentTemplateEntity entity in list) { CascadingDropDownNameValue cdnv; cdnv = new CascadingDropDownNameValue(entity.Title, entity.AmandamentTemplateId.ToString()); values.Add(cdnv); } return values.ToArray(); }
public CascadingDropDownNameValue[] GetBanks(string knownCategoryValues, string category, string contextKey) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<BankEntity> list = new BankMapper().ListWithAdvancedFilter("", StatusEnum.Active); foreach (BankEntity ent in list) { CascadingDropDownNameValue cdnv; if (ent.Title == contextKey) { cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString(), true); } else { cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString()); } values.Add(cdnv); } return values.ToArray(); }
private void txtTimKiem_TextChanged(object sender, EventArgs e) { if (rdbTen.Checked == true) { if (ctBCXH_Search == null) { BCXuatHangTheoNhomHang[] tkkt = new BCXuatHangTheoNhomHang[0]; dtgvhienthi.DataSource = tkkt; FixDatagridview(); tsslchitiet.Enabled = false; tsslExcel.Enabled = false; tsslPdf.Enabled = false; tsslWord.Enabled = false; } else if (ctBCXH_Search != null) { if (txtTimKiem.Text.Length == 0) { BCXuatHangTheoNhomHang[] tkkt = new BCXuatHangTheoNhomHang[0]; dtgvhienthi.DataSource = tkkt; FixDatagridview(); tsslchitiet.Enabled = false; tsslExcel.Enabled = false; tsslPdf.Enabled = false; tsslWord.Enabled = false; } else { int ctBCXH_Search_count = 0; for (int i = 0; i < ctBCXH_Search.Length; i++) { int index = -1; index = ctBCXH_Search[i].TenNhomHang.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower()); if (index >= 0) { ctBCXH_Search_count++; } } BCXuatHangTheoNhomHang[] ctBCXH_Search1 = new BCXuatHangTheoNhomHang[ctBCXH_Search_count]; ctBCXH_Search_count = 0; for (int i = 0; i < ctBCXH_Search.Length; i++) { int index = -1; index = ctBCXH_Search[i].TenNhomHang.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower()); if (index >= 0) { ctBCXH_Search1[ctBCXH_Search_count] = ctBCXH_Search[i]; ctBCXH_Search_count++; } } if (ctBCXH_Search_count == 0) { tsslchitiet.Enabled = false; tsslExcel.Enabled = false; tsslPdf.Enabled = false; tsslWord.Enabled = false; } else { tsslchitiet.Enabled = true; tsslExcel.Enabled = true; tsslPdf.Enabled = true; tsslWord.Enabled = true; } ///////////////////////////////MRK FIX List<Entities.BCXuatHangTheoNhomHang> tem0 = new List<BCXuatHangTheoNhomHang>(); double tong0 = 0; foreach (Entities.BCXuatHangTheoNhomHang item in ctBCXH_Search1) { tong0 += item.TongSoLuongXuat; tem0.Add(item); } Entities.BCXuatHangTheoNhomHang tem1 = new BCXuatHangTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.TongSoLuongXuat = (int)tong0; tem0.Add(tem1); ////////////////////////////////////// dtgvhienthi.DataSource = tem0.ToArray(); //dtgvhienthi.DataSource = ctBCXH_Search1; FixDatagridview(); } } } else if (rdbMa.Checked == true) { if (ctBCXH_Search == null) { BCXuatHangTheoNhomHang[] tkkt = new BCXuatHangTheoNhomHang[0]; dtgvhienthi.DataSource = tkkt; FixDatagridview(); tsslchitiet.Enabled = false; tsslExcel.Enabled = false; tsslPdf.Enabled = false; tsslWord.Enabled = false; } else if (ctBCXH_Search != null) { if (txtTimKiem.Text.Length == 0) { BCXuatHangTheoNhomHang[] tkkt = new BCXuatHangTheoNhomHang[0]; dtgvhienthi.DataSource = tkkt; FixDatagridview(); tsslchitiet.Enabled = false; tsslExcel.Enabled = false; tsslPdf.Enabled = false; tsslWord.Enabled = false; } else { int ctBCXH_Search_count = 0; for (int i = 0; i < ctBCXH_Search.Length; i++) { int index = -1; index = ctBCXH_Search[i].MaNhomHang.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower()); if (index >= 0) { ctBCXH_Search_count++; } } BCXuatHangTheoNhomHang[] ctBCXH_Search1 = new BCXuatHangTheoNhomHang[ctBCXH_Search_count]; ctBCXH_Search_count = 0; for (int i = 0; i < ctBCXH_Search.Length; i++) { int index = -1; index = ctBCXH_Search[i].MaNhomHang.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower()); if (index >= 0) { ctBCXH_Search1[ctBCXH_Search_count] = ctBCXH_Search[i]; ctBCXH_Search_count++; } } if (ctBCXH_Search_count == 0) { tsslchitiet.Enabled = false; tsslExcel.Enabled = false; tsslPdf.Enabled = false; tsslWord.Enabled = false; } else { tsslchitiet.Enabled = true; tsslExcel.Enabled = true; tsslPdf.Enabled = true; tsslWord.Enabled = true; } ///////////////////////////////MRK FIX List<Entities.BCXuatHangTheoNhomHang> tem0 = new List<BCXuatHangTheoNhomHang>(); double tong0 = 0; foreach (Entities.BCXuatHangTheoNhomHang item in ctBCXH_Search1) { tong0 += item.TongSoLuongXuat; tem0.Add(item); } Entities.BCXuatHangTheoNhomHang tem1 = new BCXuatHangTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.TongSoLuongXuat = (int)tong0; tem0.Add(tem1); ////////////////////////////////////// dtgvhienthi.DataSource = tem0.ToArray(); //dtgvhienthi.DataSource = ctBCXH_Search1; FixDatagridview(); } } } }
private void btnhienthi_Click(object sender, EventArgs e) { if (KiemTra()) { LayNhomHang(); LayNgay(); LayHangHoa(); GoiHang(); ChiTietGoiHang(); LayHDBanHang(); LayChiTiet_HDBanHang(); LayPhieuDieuChuyenKhoNoiBo(); LayChiTiet_PhieuDieuChuyenKho(); LayPhieuXuatHuy(); LayChiTiet_XuatHuy(); LayTraLaiNCC(); LayChiTiet_TraLaiNCC(); LayChiTiet_HangHoaXuat(); ArrTongHangXuat(); ///////////////////////////////MRK FIX List<Entities.BCXuatHangTheoNhomHang> tem0 = new List<BCXuatHangTheoNhomHang>(); double tong0 = 0; foreach (Entities.BCXuatHangTheoNhomHang item in ArrBCXH) { if (item == null) { continue; } tong0 += item.TongSoLuongXuat; tem0.Add(item); } Entities.BCXuatHangTheoNhomHang tem1 = new BCXuatHangTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.TongSoLuongXuat = (int)tong0; tem0.Add(tem1); ////////////////////////////////////// //dtgvhienthi.DataSource = ArrBCXH; dtgvhienthi.DataSource = tem0.ToArray(); FixDatagridview(); ctBCXH_Search = ArrBCXH; if (ArrBCXH.Length > 0) { tsslchitiet.Enabled = true; tsslPdf.Enabled = true; tsslExcel.Enabled = true; tsslWord.Enabled = true; } else { tsslchitiet.Enabled = false; tsslPdf.Enabled = false; tsslExcel.Enabled = false; tsslWord.Enabled = false; } } }
monsterManager = new MonsterManager(conString, providerName); } public Map[] GetAllMaps() { _db.Open(); DbDataReader reader = _db.ExcecuteReader(DbNames.GETALLMAPS_STOREDPROC, System.Data.CommandType.StoredProcedure, null); int ordinalId = reader.GetOrdinal(DbNames.MAP_ID); int ordinalName = reader.GetOrdinal(DbNames.MAP_NAME); int ordinalMultiplyValue = reader.GetOrdinal(DbNames.MAP_MULTIPLYVALUE); int ordinalSpawnX = reader.GetOrdinal(DbNames.MAP_SPAWNX); int ordinalSpawnY = reader.GetOrdinal(DbNames.MAP_SPAWNY); List<Map> maps = new List<Map>(); while (reader.Read()) { Map m = new Map() { MapID = reader.GetInt32(ordinalId), Name = reader.GetString(ordinalName), MultiplyValue = reader.GetInt32(ordinalMultiplyValue), SpawnX = reader.GetInt32(ordinalSpawnX), SpawnY = reader.GetInt32(ordinalSpawnY) }; maps.Add(m); } reader.Close(); _db.Close(); foreach (Map map in maps) { map.Portals = portalManager.GetPortalsByMapId(map.MapID); map.Npcs = npcManager.GetNpcsByMapId(map.MapID); map.Monsters = monsterManager.GetMonstersByMapId(map.MapID); if (map.MapID != 9 && map.MapID != 10 && map.MapID != 13 && map.MapID != 14) // maps we dont have maskes for yet.. map.WalkableTiles = GetWalkableTiles(map.Name); } return maps.ToArray(); } public Map GetMapById(int mapId) { DbParameter mapIdParameter = _db.CreateParameter(DbNames.GETMAPBYID_ID_PARAMETER, mapId); mapIdParameter.DbType = System.Data.DbType.Int32; _db.Open(); DbDataReader reader = _db.ExcecuteReader(DbNames.GETMAPBYID_STOREDPROC, System.Data.CommandType.StoredProcedure, mapIdParameter); int ordinalId = reader.GetOrdinal(DbNames.MAP_ID); int ordinalName = reader.GetOrdinal(DbNames.MAP_NAME); int ordinalMultiplyValue = reader.GetOrdinal(DbNames.MAP_MULTIPLYVALUE); int ordinalSpawnX = reader.GetOrdinal(DbNames.MAP_SPAWNX); int ordinalSpawnY = reader.GetOrdinal(DbNames.MAP_SPAWNY); Map m = null; while (reader.Read()) { m = new Map { MapID = reader.GetInt32(ordinalId), Name = reader.GetString(ordinalName), MultiplyValue = reader.GetInt32(ordinalMultiplyValue), SpawnX = reader.GetInt32(ordinalSpawnX), SpawnY = reader.GetInt32(ordinalSpawnY) }; } reader.Close(); _db.Close(); m.Portals = portalManager.GetPortalsByMapId(mapId); m.Npcs = npcManager.GetNpcsByMapId(mapId); return m; }
private void rdbTatCa_CheckedChanged(object sender, EventArgs e) { if (rdbTatCa.Checked == true) { txtTimKiem.Text = ""; if (ctBCXH_Search.Length > 0) { tsslchitiet.Enabled = true; tsslPdf.Enabled = true; tsslExcel.Enabled = true; tsslWord.Enabled = true; } else { tsslchitiet.Enabled = false; tsslPdf.Enabled = false; tsslExcel.Enabled = false; tsslWord.Enabled = false; } ///////////////////////////////MRK FIX List<Entities.BCXuatHangTheoNhomHang> tem0 = new List<BCXuatHangTheoNhomHang>(); double tong0 = 0; foreach (Entities.BCXuatHangTheoNhomHang item in ctBCXH_Search) { tong0 += item.TongSoLuongXuat; tem0.Add(item); } Entities.BCXuatHangTheoNhomHang tem1 = new BCXuatHangTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.TongSoLuongXuat = (int)tong0; tem0.Add(tem1); ////////////////////////////////////// dtgvhienthi.DataSource = tem0.ToArray(); //dtgvhienthi.DataSource = ctBCXH_Search; FixDatagridview(); } }
public CascadingDropDownNameValue[] GetOrganizationalUnits(string knownCategoryValues, string category, string contextKey) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<OrganizationalUnitView> list = new OrganizationalUnitMapper().List(""); foreach (OrganizationalUnitView ent in list) { CascadingDropDownNameValue cdnv; if (ent.TitleAndOrganizationaUnitGroup == contextKey) { cdnv = new CascadingDropDownNameValue(ent.TitleAndOrganizationaUnitGroup, ent.Id.ToString(), true); } else { cdnv = new CascadingDropDownNameValue(ent.TitleAndOrganizationaUnitGroup, ent.Id.ToString()); } values.Add(cdnv); } return values.ToArray(); }
//true:SoQuy False: CTSoQuy public frmBaoCaorpt(string LuaChon, Entities.SoQuy[] dulieu, string path, bool select) { try { InitializeComponent(); CongTy(); foreach (Entities.SoQuy item in dulieu) { item.DuDauKy = item.DuDauKy.Replace(",", ""); item.PhatSinhNo = item.PhatSinhNo.Replace(",", ""); item.PhatSinhCo = item.PhatSinhCo.Replace(",", ""); item.DuCuoiKy = item.DuCuoiKy.Replace(",", ""); } if (select) { GUI.Report.rptBCSoQuy report = new GUI.Report.rptBCSoQuy(); List<Entities.BCSoQuy> dulieu1 = new List<Entities.BCSoQuy>(); foreach (Entities.SoQuy item in dulieu) { Entities.BCSoQuy tem = new Entities.BCSoQuy(); tem.MaTK = item.MaTK; tem.TenTK = item.TenTK; tem.DuDauKy = double.Parse(item.DuDauKy); tem.PhatSinhNo = double.Parse(item.PhatSinhNo); tem.PhatSinhCo = double.Parse(item.PhatSinhCo); tem.DuCuoiKy = double.Parse(item.DuCuoiKy); //tem.NgayLap = item.NgayLap; //tem.MaPhieu = item.MaPhieu; //tem.Ton = double.Parse(item.Ton); dulieu1.Add(tem); } Entities.BCSoQuy[] view = dulieu1.ToArray(); report.SetDataSource(view); crvReport.ReportSource = report; report.SetParameterValue("TenCongTy", CT.TenCongTy); report.SetParameterValue("DiaChiCongTy", CT.DiaChi); report.SetParameterValue("DienThoai", CT.SoDienThoai); report.SetParameterValue("Web", CT.Website); report.SetParameterValue("Email", CT.Email); report.SetParameterValue("FaxCongTy", CT.Fax); report.SetParameterValue("TenBaoCao", "SỔ QUỸ"); report.SetParameterValue("NgayIn", DateServer.Date().ToString("dd/MM/yyyy")); if (LuaChon.Equals("SoQuy_In")) { crvReport.Show(); } else if (LuaChon.Equals("SoQuy_XLS")) { new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.Excel); } else if (LuaChon.Equals("SoQuy_DOC")) { new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.WordForWindows); } else if (LuaChon.Equals("SoQuy_PDF")) { new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.PortableDocFormat); } } else { GUI.Report.rptBCChiTietSoQuy report = new GUI.Report.rptBCChiTietSoQuy(); List<Entities.BCSoQuy> dulieu1 = new List<Entities.BCSoQuy>(); foreach (Entities.SoQuy item in dulieu) { Entities.BCSoQuy tem = new Entities.BCSoQuy(); tem.MaTK = item.MaTK; tem.TenTK = item.TenTK; tem.DuDauKy = double.Parse(item.DuDauKy); tem.PhatSinhNo = double.Parse(item.PhatSinhNo); tem.PhatSinhCo = double.Parse(item.PhatSinhCo); tem.DuCuoiKy = double.Parse(item.DuCuoiKy); tem.NgayLap = item.NgayLap; tem.MaPhieu = item.MaPhieu; tem.Ton = double.Parse(item.Ton); dulieu1.Add(tem); } Entities.BCSoQuy[] view = dulieu1.ToArray(); report.SetDataSource(view); crvReport.ReportSource = report; report.SetParameterValue("TenCongTy", CT.TenCongTy); report.SetParameterValue("DiaChiCongTy", CT.DiaChi); report.SetParameterValue("DienThoai", CT.SoDienThoai); report.SetParameterValue("Web", CT.Website); report.SetParameterValue("Email", CT.Email); report.SetParameterValue("FaxCongTy", CT.Fax); report.SetParameterValue("TenBaoCao", "CHI TIẾT SỔ QUỸ"); report.SetParameterValue("NgayIn", DateServer.Date().ToString("dd/MM/yyyy")); if (LuaChon.Equals("SoQuy_In")) { crvReport.Show(); } else if (LuaChon.Equals("SoQuy_XLS")) { new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.Excel); } else if (LuaChon.Equals("SoQuy_DOC")) { new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.WordForWindows); } else if (LuaChon.Equals("SoQuy_PDF")) { new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.PortableDocFormat); } } } catch { } }
private void txtTimKiem_TextChanged(object sender, EventArgs e) { try { string Search = txtTimKiem.Text; List<Entities.HangHoa> ketqua = new List<Entities.HangHoa>(); foreach (Entities.HangHoa item in MANG) { int test = -1; if (rdbMa.Checked) //Tìm Kiếm Theo Mã { test = item.MaHangHoa.ToLower().IndexOf(Search.ToLower()); } else if (rdbTen.Checked) //Tìm Kiếm Theo Tên { test = item.TenHangHoa.ToLower().IndexOf(Search.ToLower()); } if (test >= 0) { ketqua.Add(item); } } dgvQuanLyHangHoa.DataSource = ketqua.ToArray(); } catch { } }
public void CheckDataGridCongSL1(DataGridView dgv, string maKho) { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.ChiTietKhoHangTheoHoaHonNhap nv = new Entities.ChiTietKhoHangTheoHoaHonNhap("Select"); clientstrem = cl.SerializeObj(this.client1, "ChiTietKho", nv); Entities.ChiTietKhoHangTheoHoaHonNhap[] kh1 = new Entities.ChiTietKhoHangTheoHoaHonNhap[1]; kh1 = (Entities.ChiTietKhoHangTheoHoaHonNhap[])cl.DeserializeHepper1(clientstrem, kh1); List<Entities.ChiTietKhoHangTheoHoaHonNhap> ctKhoList = new List<Entities.ChiTietKhoHangTheoHoaHonNhap>(); try { if (dgv.RowCount != 0) { for (int i = 0; i < dgv.RowCount; i++) { foreach (Entities.ChiTietKhoHangTheoHoaHonNhap item in kh1) { // lay cac hang hoa da ton tai if (dgv["MaHangHoa", i].Value.ToString().ToUpper().Equals(item.Mahanghoa.ToUpper())) { Entities.ChiTietKhoHangTheoHoaHonNhap ct; ct = new Entities.ChiTietKhoHangTheoHoaHonNhap("UpdateCong", maKho, dgv["MaHangHoa", i].Value.ToString(), int.Parse(dgv["SoLuong", i].Value.ToString())); ctKhoList.Add(ct); break; } } } TruSLMang(ctKhoList.ToArray()); } } catch (Exception) { } }
public string[] GetUsersList(string prefixText, int count) { List<string> results = new List<string>(); PrincipalContext ctx = new PrincipalContext(ContextType.Domain); UserPrincipal qbeUser = new UserPrincipal(ctx); qbeUser.DisplayName = "*" + prefixText + "*"; PrincipalSearcher searcher = new PrincipalSearcher(qbeUser); foreach (var found in searcher.FindAll()) { results.Add(found.SamAccountName); } return results.ToArray(); }
public CascadingDropDownNameValue[] GetLeaveTypes(string knownCategoryValues, string category, string contextKey) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<LeaveTypeEntity> list = new LeaveTypeMapper().List(""); foreach (LeaveTypeEntity entity in list) { CascadingDropDownNameValue cdnv; cdnv = new CascadingDropDownNameValue(entity.Title, entity.Id.ToString()); values.Add(cdnv); } return values.ToArray(); }
public CascadingDropDownNameValue[] GetStepsByGradeId(string knownCategoryValues, string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); string gradeId; if (!kv.ContainsKey("Grade")) { return null; } gradeId = kv["Grade"]; List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<StepEntity> list = new StepMapper().ListByGradeId(gradeId); foreach (StepEntity ent in list) { string text = (ent.Id); CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(text, ent.Id.ToString()); values.Add(cdnv); } return values.ToArray(); }
public CascadingDropDownNameValue[] GetRoles(string knownCategoryValues, string category) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<RoleEntity> list = new RoleMapper().List(""); foreach (RoleEntity ent in list) { CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString()); values.Add(cdnv); } return values.ToArray(); }
public CascadingDropDownNameValue[] GetPaymentTypesByLeaveType(string knownCategoryValues, string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); int leaveTypelId; if (!kv.ContainsKey("LeaveTypes") || !Int32.TryParse(kv["LeaveTypes"], out leaveTypelId)) { return null; } List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<LeaveTypeLevelEntity> list = new LeaveTypeLevelMapper().List(leaveTypelId); foreach (LeaveTypeLevelEntity ent in list) { CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(ent.LeaveNameType.ToString(), ent.Id.ToString()); values.Add(cdnv); } return values.ToArray(); }
private void frmBCXuatHangTheoNhomHang_Load(object sender, EventArgs e) { try { for (int i = 0; i < cbbthang.Items.Count; i++) { if (cbbthang.Items[i].ToString() == datesv.Month.ToString()) { cbbthang.SelectedIndex = i; break; } } for (int i = 0; i < cbbnam.Items.Count; i++) { if (cbbnam.Items[i].ToString() == datesv.Year.ToString()) { cbbnam.SelectedIndex = i; break; } } LayNhomHang(); //Entities.NhomHang[] K_nhomhang = this.NhomHang; LayNgay(); DateTime K_BatDau = this.BatDau; DateTime K_KetThuc = this.KetThuc; GoiHang(); ChiTietGoiHang(); //Entities.GoiHang[] K_goihang = this.goihang; //Entities.ChiTietGoiHang[] K_chitietgoihang = this.chitietgoihang; LayHangHoa(); //Entities.HangHoa[] K_hanghoa = this.HangHoa; LayHDBanHang(); //Entities.HDBanHang[] K_HDBanHang = this.HDBanHang; LayChiTiet_HDBanHang(); //Entities.ChiTietHDBanHang[] K_ctHDBanHang = this.ctHDBanHang; LayPhieuDieuChuyenKhoNoiBo(); //Entities.PhieuDieuChuyenKhoNoiBo[] K_PDieuChuyen = this.PDieuChuyen; LayChiTiet_PhieuDieuChuyenKho(); //Entities.ChiTietPhieuDieuChuyenKho[] K_ctPDCK = this.ctPDCK; LayPhieuXuatHuy(); //Entities.PhieuXuatHuy[] K_PXuatHuy = this.PXuatHuy; LayChiTiet_XuatHuy(); //Entities.ChiTietXuatHuy[] K_ctPXuatHuy = this.ctPXuatHuy; LayTraLaiNCC(); //Entities.TraLaiNCC[] K_TraLaiNCC = this.TraLaiNCC; LayChiTiet_TraLaiNCC(); //Entities.ChiTietTraLaiNhaCungCap[] K_ctTraLaiNCC = this.ctTraLaiNCC; LayChiTiet_HangHoaXuat(); ArrTongHangXuat(); ///////////////////////////////MRK FIX List<Entities.BCXuatHangTheoNhomHang> tem0 = new List<BCXuatHangTheoNhomHang>(); double tong0 = 0; foreach (Entities.BCXuatHangTheoNhomHang item in ArrBCXH) { tong0 += item.TongSoLuongXuat; tem0.Add(item); } Entities.BCXuatHangTheoNhomHang tem1 = new BCXuatHangTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.TongSoLuongXuat = (int)tong0; tem0.Add(tem1); ////////////////////////////////////// //dtgvhienthi.DataSource = ArrBCXH; dtgvhienthi.DataSource = tem0.ToArray(); FixDatagridview(); ctBCXH_Search = ArrBCXH; if (ArrBCXH.Length > 0) { tsslchitiet.Enabled = true; tsslPdf.Enabled = true; tsslExcel.Enabled = true; tsslWord.Enabled = true; } else { tsslchitiet.Enabled = false; tsslPdf.Enabled = false; tsslExcel.Enabled = false; tsslWord.Enabled = false; } } catch { } }
public CascadingDropDownNameValue[] GetJobTitlesByOrganisationalUnit(string knownCategoryValues, string category, string contextKey) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); int organisationalId; if (!kv.ContainsKey("OrganizationalUnit") || !Int32.TryParse(kv["OrganizationalUnit"], out organisationalId)) { List<JobTitleView> list = new JobTitleMapper().ListByOrganisationalUnitId(null, "", StatusEnum.Active); foreach (JobTitleView ent in list) { CascadingDropDownNameValue cdnv; if (ent.Title == contextKey) { cdnv = new CascadingDropDownNameValue(ent.Title, ent.Code, true); values.Add(cdnv); } else { cdnv = new CascadingDropDownNameValue(ent.Title, ent.Code); values.Add(cdnv); } } } else { List<JobTitleView> list = new JobTitleMapper().ListByOrganisationalUnitId(organisationalId, "", StatusEnum.Active); foreach (JobTitleView ent in list) { CascadingDropDownNameValue cdnv; if (ent.Title == contextKey) { cdnv = new CascadingDropDownNameValue(ent.Title, ent.Code, true); values.Add(cdnv); } else { cdnv = new CascadingDropDownNameValue(ent.Title, ent.Code); values.Add(cdnv); } } } return values.ToArray(); }
public CascadingDropDownNameValue[] GetGradesByJobCode(string knownCategoryValues, string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); string jobCode; if (!kv.ContainsKey("JobTitle")) { return null; } jobCode = kv["JobTitle"]; List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<GradeEntity> list = new GradeMapper().ListByJobeCode(jobCode); foreach (GradeEntity ent in list) { string text = ent.Id; CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(text, ent.Id.ToString()); values.Add(cdnv); } return values.ToArray(); }
//Obtiene el detalle de label y entrega el dataset public static DataSet GetReportDataset(IList<Label> labelList, int quantity) { try { ReportDetailFormat detail; IList<ReportDetailFormat> detailList = new List<ReportDetailFormat>(); string notes = ""; int seq = 1; foreach (Label label in labelList) { detail = new ReportDetailFormat(); if (label.Product != null) { detail.ProductCode = label.Product.ProductCode; detail.ProductDescription = label.Product.Name; } notes = (label.Notes != null) ? label.Notes : ""; if (label.IsLogistic == true) { try { detail.Unit = notes.Split(',')[0].Trim().Replace("Default", ""); } catch { } detail.QtyOrder = label.StartQty; //Aqui guardan las logisitcas las hijas que contienen unas vez se imprimen } else { detail.Unit = label.Unit != null ? label.Unit.Name : "Default"; detail.QtyOrder = label.CurrQty; } //detail.BarcodeProduct = label.Product.ProductCode; detail.BarcodeLabel = (label.Barcode != null) ? label.Barcode : ""; detail.Lote = (label.LotCode != null) ? label.LotCode : ""; detail.Date1 = (label.ExpirationDate != null) ? label.ExpirationDate.Value.ToShortDateString() : ""; detail.Printed = DateTime.Today.ToString("MM/dd/yyyy hh:mm:ss"); detail.Serial = (label.SerialNumber != null) ? label.SerialNumber : ""; detail.Notes = notes; detail.PrintLot = (label.PrintingLot != null) ? label.PrintingLot : ""; detail.UserName = (label.CreatedBy != null) ? label.Barcode : ""; detail.LogisticNote = ""; // (label.IsLogistic == true) ? "** LOGISTIC **" : ""; //Si el Label es de tipo Custom Label, Ejecuta un proceso adicional. //JM 10 de Junio de 2009 if (label.LabelType.DocTypeID == LabelType.CustomerLabel) { //For Packages detail.DocNumber = (label.ShippingDocument != null) ? label.ShippingDocument.DocNumber : ""; //Sequence try { detail.PrintLot = seq.ToString() + " / " + labelList.Count(); } catch { } //Weight try { detail.Weight = label.DocumentPackages[0].Weight; } catch { } //Dimemsion try { detail.Dimension = label.DocumentPackages[0].Dimension; } catch { } try { detail.Pieces = label.DocumentPackages[0].Pieces; } catch { } //Shipping Address try { DocumentAddress shipAddr = (new DaoFactory()).DaoDocumentAddress().Select( new DocumentAddress { Document = label.ShippingDocument, AddressType = AddressType.Shipping }) .Where(f => f.DocumentLine == null).First(); detail.ContactPerson = shipAddr.Name; //shipAddr.ContactPerson; //detail.ShipAddress = shipAddr.Name + "\n"; detail.ShipAddress = shipAddr.AddressLine1 + " " + shipAddr.AddressLine2 + "\n"; detail.ShipAddress += shipAddr.City + ", " + shipAddr.State + " " + shipAddr.ZipCode + ", "; detail.ShipAddress += shipAddr.Country + "\n"; detail.ShipAddress += shipAddr.ContactPerson; } catch { } } seq++; detailList.Add(detail); } //Add Header to DataSet XmlSerializer xmlSerializer; StringWriter writer = new StringWriter(); DataSet dd = new DataSet("Details"); xmlSerializer = new XmlSerializer(detailList.ToArray().GetType()); // detailList.GetType() xmlSerializer.Serialize(writer, detailList.ToArray()); StringReader reader = new StringReader(writer.ToString()); dd.ReadXml(reader); dd.Tables[0].TableName = "Details"; return dd; } catch { return null; } }
public Character[] GetAllCharactersByAccountId(int accountId) { DbParameter accountIdParameter = _db.CreateParameter(DbNames.GETALLCHARACTERSBYACCOUNTID_ACCOUNTID_PARAMETER, accountId); accountIdParameter.DbType = DbType.Int32; List<Character> characters = new List<Character>(); _db.Open(); DbDataReader reader = _db.ExcecuteReader(DbNames.GETALLCHARACTERSBYACCOUNTID_STOREDPROC, CommandType.StoredProcedure, accountIdParameter); int ordinalCHARACTER_ID = reader.GetOrdinal(DbNames.CHARACTER_ID); int ordinalCHARACTER_ACCOUNTID = reader.GetOrdinal(DbNames.CHARACTER_ACCOUNTID); int ordinalCHARACTER_NAME = reader.GetOrdinal(DbNames.CHARACTER_NAME); int ordinalCHARACTER_CLASS = reader.GetOrdinal(DbNames.CHARACTER_CLASS); int ordinalCHARACTER_LEVEL = reader.GetOrdinal(DbNames.CHARACTER_LEVEL); int ordinalCHARACTER_MAPID = reader.GetOrdinal(DbNames.CHARACTER_MAPID); int ordinalCHARACTER_CURRENTHP = reader.GetOrdinal(DbNames.CHARACTER_CURRENTHP); int ordinalCHARACTER_CURRENTMANA = reader.GetOrdinal(DbNames.CHARACTER_CURRENTMANA); int ordinalCHARACTER_STRENGTH = reader.GetOrdinal(DbNames.CHARACTER_STRENGTH); int ordinalCHARACTER_STAMINA = reader.GetOrdinal(DbNames.CHARACTER_STAMINA); int ordinalCHARACTER_DEXTERITY = reader.GetOrdinal(DbNames.CHARACTER_DEXTERITY); int ordinalCHARACTER_ENERGY = reader.GetOrdinal(DbNames.CHARACTER_ENERGY); while (reader.Read()) { Character c = new Character { CharacterId = reader.GetInt32(ordinalCHARACTER_ID), AccountId = reader.GetInt32(ordinalCHARACTER_ACCOUNTID), Name = reader.GetString(ordinalCHARACTER_NAME), Class = reader.GetByte(ordinalCHARACTER_CLASS), Level = reader.GetInt16(ordinalCHARACTER_LEVEL), MapId = reader.GetInt32(ordinalCHARACTER_MAPID), CurrentHp = reader.GetInt32(ordinalCHARACTER_CURRENTHP), CurrentMana = reader.GetInt32(ordinalCHARACTER_CURRENTMANA), Strength = reader.GetInt16(ordinalCHARACTER_STRENGTH), Stamina = reader.GetInt16(ordinalCHARACTER_STAMINA), Dexterity = reader.GetInt16(ordinalCHARACTER_DEXTERITY), Energy = reader.GetInt16(ordinalCHARACTER_ENERGY) }; characters.Add(c); } reader.Close(); _db.Close(); foreach (Character c in characters) { //c.Equipments = GetAllItemsInBag(0, c.CharacterId).Cast<Equipment>().ToList(); var equips = itemDataManager.GetAllItemsInBag(0, c.CharacterId).Cast<Equipment>().ToList(); var neck = equips.Where(x => x is Necklace); var ring = equips.Where(x => x is Ring); var head = equips.Where(x => x is Head); var body = equips.Where(x => x is Body); var feet = equips.Where(x => x is Feet); var hand = equips.Where(x => x is Hand); var cape = equips.Where(x => x is Cape); var charm = equips.Where(x => x.Slot == (byte)Slot.CrystalMirror); var mirror = equips.Where(x => x.Slot == (byte)Slot.Mirror); c.Necklace = neck.Count() == 0 ? null : neck.First() as Necklace; c.Ring = ring.Count() == 0 ? null : ring.First() as Ring; c.Head = head.Count() == 0 ? null : head.First() as Head; c.Body = body.Count() == 0 ? null : body.First() as Body; c.Feet = feet.Count() == 0 ? null : feet.First() as Feet; c.Hand = hand.Count() == 0 ? null : hand.First() as Hand; c.Cape = cape.Count() == 0 ? null : cape.First() as Cape; c.Charm = charm.Count() == 0 ? null : charm.First() as Equipment; c.Mirror = mirror.Count() == 0 ? null : mirror.First() as Mirror; } return characters.ToArray(); }
public CascadingDropDownNameValue[] GetNationalities(string knownCategoryValues, string category, string contextKey) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<NationalityEntity> list = new NationalityMapper().List(""); foreach (NationalityEntity ent in list) { CascadingDropDownNameValue cdnv; if (ent.Title == contextKey) { cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString(), true); } else { cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString()); } values.Add(cdnv); } return values.ToArray(); }
private void SelectData() { List<Entities.HangHoa> listTemp = new List<Entities.HangHoa>(); int stt = 0; MANG = LayHangHoa(); MANG = OrderBy(MANG); foreach (Entities.HangHoa item in MANG) { stt++; item.Stt = stt; listTemp.Add(item); } dgvQuanLyHangHoa.DataSource = listTemp.ToArray(); fix(); }
public CascadingDropDownNameValue[] GetWorkTypes(string knownCategoryValues, string category, string contextKey) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); string[] workTypesNames = Enum.GetNames(typeof(WorkType)); Array workTypesValues = Enum.GetValues(typeof(WorkType)); CascadingDropDownNameValue cdnv; for (int i = 1; i <= workTypesNames.Length - 1; i++) { if (workTypesNames[i] == contextKey) { cdnv = new CascadingDropDownNameValue(workTypesNames[i], i.ToString(), true); } else { cdnv = new CascadingDropDownNameValue(workTypesNames[i], i.ToString()); } values.Add(cdnv); } return values.ToArray(); }
public void GiaVonBanHang(ChiTietHDBanHang[] ct) { try { List<GiaVonBanHang> gvbhArr = new List<GiaVonBanHang>(); GoiHang[] goiHang = _goihang; GiaVon[] gv = GiaVon(); bool isHangHoa = false; foreach (ChiTietHDBanHang bh in ct) { GiaVonBanHang gvbh = new GiaVonBanHang(); ChiTietHDBanHang bh1 = bh; foreach (GiaVon item in gv.Where(item => item.MaHangHoa.Equals(bh1.MaHangHoa))) { gvbh.HanhDong = "Insert"; gvbh.MaHangHoa = bh.MaHangHoa; gvbh.MaHoaDon = bh.MaHDBanHang; gvbh.GiaVon = item.Gia; gvbhArr.Add(gvbh); isHangHoa = true; break; } // neu ko phai la hang hoa thi la gia von trong goi hang if (isHangHoa) continue; gvbh = GetGvGoiHang(bh.MaHDBanHang, bh.MaHangHoa, goiHang); if (gvbh != null) gvbhArr.Add(gvbh); } cl = new Server_Client.Client(); Client1 = cl.Connect(Luu.IP, Luu.Ports); foreach (GiaVonBanHang item in gvbhArr.ToArray()) { Clientstrem = cl.SerializeObj(Client1, "GiaVonBanHang", item); } // đổ mảng đối tượng vào datagripview bool kt = false; kt = (bool)cl.DeserializeHepper(Clientstrem, kt); } catch (Exception) { } }
public CascadingDropDownNameValue[] GetContractsTemplates(string knownCategoryValues, string category) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); List<ContractTemplateEntity> list = new ContractTemplateMapper().ListWithAdvancedFilter("", StatusEnum.Active); foreach (ContractTemplateEntity ent in list) { CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString()); values.Add(cdnv); } return values.ToArray(); }