private new StaticData GetStaticData() { object staticData = base.GetStaticData(); if (staticData == null) { staticData = new StaticData(); base.SetStaticData(staticData); } return (StaticData)staticData; }
public void ChampionApiTest() { var api = new StaticData<ChampionDto>(6, 4, null, null, "all"); var images = QueryExecutor.getChampionImages(); try { List<ChampionDto> list = RequestBuilder.ExecuteAndReturn(api); Assert.IsTrue(true); } catch (Exception e) { Assert.Fail(e.Message); } }
public void Start() { guiManager = GUIManager.instance; socialManager = SocialManager.instance; missionManager = MissionManager.instance; staticData = StaticData.instance; score = 0; levelCoins = 0; collisions = 0; totalCoins = PlayerPrefs.GetInt("Coins", 0); currentPowerupLevel = new int[(int)PowerUpTypes.None]; for (int i = 0; i < (int)PowerUpTypes.None; ++i) { currentPowerupLevel[i] = PlayerPrefs.GetInt(string.Format("PowerUp{0}", i), 0); if (currentPowerupLevel[i] == 0 && GameManager.instance.enableAllPowerUps) { currentPowerupLevel[i] = 1; } } // first character is always available purchaseCharacter(0); }
private void cmdOK_Click(object sender, System.EventArgs e) { try { using (var transaction = _store.TransactionManager.BeginTransaction(Guid.NewGuid().ToString())) { _entity.StaticDatum.Clear(); var dt = (System.Data.DataTable)this.dataGridView1.DataSource; var index = 1; foreach (System.Data.DataRow dr in dt.Rows) { foreach (DataColumn dc in dr.Table.Columns) { var data = new StaticData(_entity.Partition); data.OrderKey = index; data.ColumnKey = _entity.Fields.First(x => x.Name == dc.ColumnName).Id; data.Value = dr[dc.ColumnName].ToString(); _entity.StaticDatum.Add(data); } index++; } transaction.Commit(); } } catch (Exception ex) { //Do Nothing } this.DialogResult = DialogResult.OK; this.Close(); }
public static void ImportLegacyModel(nHydrateModel model, Store store, nHydrateDiagram diagram, string legacyFileName) { diagram.IsLoading = true; model.IsLoading = true; try { var addedElements = new List<ModelElement>(); using (var transaction = store.TransactionManager.BeginTransaction(Guid.NewGuid().ToString())) { //The loading assemblies have changed names, so we must manually intervene var newFile = legacyFileName + ".converting"; nHydrate.Generator.nHydrateGeneratorProject project = null; try { File.Copy(legacyFileName, newFile); var fileText = File.ReadAllText(newFile); fileText = fileText.Replace("Widgetsphere.Generator.", "nHydrate.Generator."); fileText = fileText.Replace("WidgetsphereGeneratorProject", "nHydrateGeneratorProject"); File.WriteAllText(newFile, fileText); System.Threading.Thread.Sleep(500); project = nHydrate.Generator.Common.GeneratorFramework.GeneratorHelper.OpenModel(newFile) as nHydrate.Generator.nHydrateGeneratorProject; } catch (Exception ex) { System.Windows.Forms.MessageBox.Show("An error occurred while importing the legacy modelRoot.", "Error", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); return; } finally { if (File.Exists(newFile)) File.Delete(newFile); } try { var oldModel = project.Model as nHydrate.Generator.Models.ModelRoot; model.TransformNames = oldModel.TransformNames; model.CompanyName = oldModel.CompanyName; model.ProjectName = oldModel.ProjectName; model.Copyright = oldModel.Copyright; model.CreatedByColumnName = oldModel.Database.CreatedByColumnName; model.CreatedDateColumnName = oldModel.Database.CreatedDateColumnName; model.DefaultNamespace = oldModel.DefaultNamespace; model.ModifiedByColumnName = oldModel.Database.ModifiedByColumnName; model.ModifiedDateColumnName = oldModel.Database.ModifiedDateColumnName; model.SQLServerType = (DatabaseTypeConstants)Enum.Parse(typeof(DatabaseTypeConstants), oldModel.SQLServerType.ToString()); model.StoredProcedurePrefix = oldModel.StoredProcedurePrefix; model.TenantPrefix = oldModel.TenantPrefix; model.AllowMocks = oldModel.AllowMocks; model.TimestampColumnName = oldModel.Database.TimestampColumnName; model.UseUTCTime = oldModel.UseUTCTime; model.Version = oldModel.Version; #region Load Tables foreach (var table in oldModel.Database.Tables.ToList()) { var newEntity = new Entity(model.Partition); model.Entities.Add(newEntity); addedElements.Add(newEntity); newEntity.AllowAuditTracking = table.AllowAuditTracking; newEntity.AllowCreateAudit = table.AllowCreateAudit; newEntity.AllowModifyAudit = table.AllowModifiedAudit; newEntity.AllowTimestamp = table.AllowTimestamp; newEntity.CodeFacade = table.CodeFacade; newEntity.Summary = table.Description; newEntity.Immutable = table.Immutable; newEntity.IsAssociative = table.AssociativeTable; newEntity.IsGenerated = table.Generated; newEntity.TypedEntity = (TypedEntityConstants)Enum.Parse(typeof(TypedEntityConstants), table.TypedTable.ToString(), true); newEntity.Name = table.Name; newEntity.Schema = table.DBSchema; //DO NOT IMPORT METADATA #region Load the columns var maxSortOrder = 1; foreach (var column in table.GetColumns()) { var newField = new Field(model.Partition); newEntity.Fields.Add(newField); newField.CodeFacade = column.CodeFacade; newField.Collate = column.Collate; newField.DataType = (DataTypeConstants)Enum.Parse(typeof(DataTypeConstants), column.DataType.ToString()); newField.Default = column.Default; newField.Summary = column.Description; newField.Formula = column.Formula; newField.FriendlyName = column.FriendlyName; newField.Identity = (IdentityTypeConstants)Enum.Parse(typeof(IdentityTypeConstants), column.Identity.ToString()); newField.IsCalculated = column.ComputedColumn; newField.IsGenerated = column.Generated; newField.IsPrimaryKey = column.PrimaryKey; newField.SortOrder = maxSortOrder++; //Do not reset as it creates 2 indexes with PK if (!newField.IsPrimaryKey) newField.IsIndexed = column.IsIndexed; newField.IsReadOnly = column.IsReadOnly; newField.IsUnique = column.IsUnique; newField.Length = column.Length; newField.Max = column.Max; newField.Min = column.Min; newField.Name = column.Name; newField.Nullable = column.AllowNull; newField.Scale = column.Scale; newField.IsBrowsable = column.IsBrowsable; newField.ValidationExpression = column.ValidationExpression; } #endregion #region Composites foreach (var component in table.ComponentList.ToList()) { var newComposite = new Composite(model.Partition); newEntity.Composites.Add(newComposite); addedElements.Add(newComposite); newComposite.CodeFacade = component.CodeFacade; newComposite.Summary = component.Description; newComposite.Name = component.Name; newComposite.IsGenerated = component.Generated; //Add the fields by looking them up in the new table foreach (var column in component.GetColumns()) { var checkColumn = table.GetColumns().FirstOrDefault(x => x.Key == column.Key); if (checkColumn != null) { var tableField = newEntity.Fields.FirstOrDefault(x => x.Name == checkColumn.Name); if (tableField != null) { var newField = new CompositeField(model.Partition); newComposite.Fields.Add(newField); newField.FieldId = tableField.Id; } } } } #endregion #region Load Static Data var index = 1; foreach (nHydrate.Generator.Models.RowEntry data in table.StaticData) { var isProcessed = false; foreach (nHydrate.Generator.Models.CellEntry cellEntry in data.CellEntries) { var column = cellEntry.ColumnRef.Object as nHydrate.Generator.Models.Column; if (column != null) { var newColumn = newEntity.Fields.FirstOrDefault(x => x.Name == column.Name); if (newColumn != null) { var newData = new StaticData(model.Partition); newEntity.StaticDatum.Add(newData); newData.ColumnKey = newColumn.Id; newData.Value = cellEntry.Value; newData.OrderKey = index; isProcessed = true; } } } if (isProcessed) index++; } #endregion } foreach (var table in oldModel.Database.Tables.ToList()) { if (table.ParentTable != null) { var child = model.Entities.FirstOrDefault(x => x.Name == table.Name); var parent = model.Entities.FirstOrDefault(x => x.Name == table.ParentTable.Name); child.ParentInheritedEntity = parent; } } #endregion #region Load Relations foreach (nHydrate.Generator.Models.Table table in oldModel.Database.Tables) { foreach (nHydrate.Generator.Models.Relation relation in table.GetRelations()) { var entity1 = model.Entities.First(x => x.Name == relation.ParentTable.Name); var entity2 = model.Entities.First(x => x.Name == relation.ChildTable.Name); if (entity2.ParentInheritedEntity != entity1) { entity1.ChildEntities.Add(entity2); var newRelation = entity1.RelationshipList.First(x => x.SourceEntity == entity1 && x.TargetEntity == entity2 && !x.FieldMapList().Any()); newRelation.RoleName = relation.RoleName; foreach (nHydrate.Generator.Models.ColumnRelationship relationColumn in relation.ColumnRelationships) { var column1 = entity1.Fields.First(x => x.Name == relationColumn.ParentColumn.Name); var column2 = entity2.Fields.First(x => x.Name == relationColumn.ChildColumn.Name); var newRelationField = new RelationField(model.Partition); model.RelationFields.Add(newRelationField); newRelationField.SourceFieldId = column1.Id; newRelationField.TargetFieldId = column2.Id; newRelationField.RelationID = newRelation.Id; } } } } #endregion #region Load Views foreach (nHydrate.Generator.Models.CustomView item in oldModel.Database.CustomViews) { var newitem = new nHydrate.Dsl.View(model.Partition); model.Views.Add(newitem); addedElements.Add(newitem); newitem.CodeFacade = item.CodeFacade; newitem.Summary = item.Description; newitem.IsGenerated = item.Generated; newitem.Name = item.Name; newitem.Schema = item.DBSchema; newitem.SQL = item.SQL; foreach (var column in item.GetColumns()) { var newColumn = new ViewField(model.Partition); newitem.Fields.Add(newColumn); newColumn.DataType = (DataTypeConstants)Enum.Parse(typeof(DataTypeConstants), column.DataType.ToString()); newColumn.Default = column.Default; newColumn.Summary = column.Description; newColumn.FriendlyName = column.FriendlyName; newColumn.Length = column.Length; newColumn.IsGenerated = column.Generated; //newColumn.Max = column.ma; //newColumn.Min = column.; newColumn.Name = column.Name; newColumn.Nullable = column.AllowNull; newColumn.Scale = column.Scale; } } #endregion #region Load Stored Procedures foreach (nHydrate.Generator.Models.CustomStoredProcedure item in oldModel.Database.CustomStoredProcedures) { var newitem = new StoredProcedure(model.Partition); model.StoredProcedures.Add(newitem); addedElements.Add(newitem); newitem.CodeFacade = item.CodeFacade; newitem.Summary = item.Description; newitem.IsGenerated = item.Generated; newitem.IsExisting = item.IsExisting; newitem.Name = item.Name; newitem.Schema = item.DBSchema; newitem.SQL = item.SQL; newitem.DatabaseObjectName = item.DatabaseObjectName; foreach (var parameter in item.GetParameters()) { var newParameter = new StoredProcedureParameter(model.Partition); newitem.Parameters.Add(newParameter); newParameter.Nullable = parameter.AllowNull; newParameter.DataType = (nHydrate.Dsl.DataTypeConstants)Enum.Parse(typeof(nHydrate.Dsl.DataTypeConstants), parameter.DataType.ToString()); newParameter.Default = parameter.Default; newParameter.Summary = parameter.Description; newParameter.IsGenerated = parameter.Generated; newParameter.IsOutputParameter = parameter.IsOutputParameter; newParameter.Length = parameter.Length; newParameter.Scale = parameter.Scale; newParameter.Name = parameter.Name; } foreach (var column in item.GetColumns()) { var newColumn = new StoredProcedureField(model.Partition); newitem.Fields.Add(newColumn); newColumn.DataType = (DataTypeConstants)Enum.Parse(typeof(DataTypeConstants), column.DataType.ToString()); newColumn.Default = column.Default; newColumn.Summary = column.Description; newColumn.FriendlyName = column.FriendlyName; newColumn.Length = column.Length; //newColumn.Max = column.ma; //newColumn.Min = column.; newColumn.Name = column.Name; newColumn.Nullable = column.AllowNull; newColumn.Scale = column.Scale; } } #endregion nHydrateSerializationHelper.LoadInitialIndexes(model); transaction.Commit(); } catch (Exception ex) { throw; } } using (var transaction = store.TransactionManager.BeginTransaction(Guid.NewGuid().ToString())) { diagram.AutoLayoutShapeElements( diagram.NestedChildShapes.Where(x => addedElements.Contains(x.ModelElement)).ToList(), Microsoft.VisualStudio.Modeling.Diagrams.GraphObject.VGRoutingStyle.VGRouteTreeNS, Microsoft.VisualStudio.Modeling.Diagrams.GraphObject.PlacementValueStyle.VGPlaceNS, true); transaction.Commit(); } } catch (Exception ex) { throw; } finally { diagram.IsLoading = false; model.IsLoading = false; } }
public static List<ChampionDto> getChampionImages() { var qry = new StaticData<ChampionListDto>(DEFAULT_REGION, data: "image"); var result = RequestBuilder.ExecuteAndReturn(qry).First(); return result.data.Values.ToList(); }
public void Awake() { instance = this; }
private void LoadLoaiTinTuc() { string sql = @"select * from ( SELECT ROW_NUMBER() OVER ( ORDER BY ThuTu )AS RowNumber ,* FROM tb_HinhAnhRaoVat nd "; if (sTieuDe != "") { sql += " and TieuDe like N'%" + sTieuDe + "%'"; } sql += ") as tb1 "; DataTable tbTong = Connect.GetTable(sql); int TotalRows = tbTong.Rows.Count; sql += "WHERE RowNumber BETWEEN (" + Page + " - 1) * " + PageSize + " + 1 AND (((" + Page + " - 1) * " + PageSize + " + 1) + " + PageSize + ") - 1"; DataTable table = Connect.GetTable(sql); string html = @"<center><table class='table table-bordered table-hover dataTable'> <tr> <th class='th'> STT </th> <th class='th'> Tiêu đề </th> <th class='th'> Đường dẫn </th> <th class='th'> Ảnh </th> <th class='th'> Kích hoạt </th> <th class='th'>Sửa </th> <th class='th'>Xóa </th> </tr>"; for (int i = 0; i < table.Rows.Count; i++) { string idBanner = table.Rows[i]["idBanner"].ToString(); html += " <tr>"; html += " <td style='text-align:center;vertical-align: inherit;'>" + table.Rows[i]["RowNumber"].ToString() + "</td>"; html += " <td style='text-align:center;vertical-align: inherit;'>" + table.Rows[i]["TieuDe"].ToString() + "</td>"; //html += " <td style='text-align:center;vertical-align: inherit;'>" + table.Rows[i]["ThuTu"].ToString() + "</td>"; html += " <td style='text-align:center;vertical-align: inherit;'>" + table.Rows[i]["LinkHinh"].ToString() + "</td>"; html += " <td style='text-align:center;vertical-align: inherit;'><img style='width:70px' src='" + table.Rows[i]["Link"].ToString() + "'/></td>"; html += " <td style='text-align:center;vertical-align: inherit;'><a href='" + GetRouteUrl("adminslideupdate", new { id = idBanner }) + "' title='Sửa'><i class='fa fa-pencil'></i></a></td>"; html += " <td style='text-align:center;vertical-align: inherit;'><a onclick='DeleteBanner(\"" + idBanner + "\")' style='cursor:pointer' title='Xóa'><i class='fa fa-trash'></i></a></td>"; html += " </tr>"; } html += " </table><table > <tr>"; html += " <td colspan='17' class='footertable'>"; string url = GetRouteUrl("adminslide", new { }) + "?"; if (sTieuDe != "") { url += "TieuDe=" + sTieuDe + "&"; } url += "Page="; html += StaticData.CreateHTMLPagingAdmin(Page, url, StaticData.SetPage(Page, TotalRows, PageSize)); html += " </td></tr>"; html += " </table></center>"; dvDanhSachLoaiTinTuc.InnerHtml = html; }
protected void btDangNhap_Click(object sender, EventArgs e) { string Email = txtEmail.Value.Trim(); string Password = txtPassword.Value.Trim(); if (Email == "") { msgEmail.InnerText = "Không được để trống ô"; return; } else { msgEmail.InnerText = ""; } if (Password == "") { msgPassword.InnerText = "Không được để trống mật khẩu"; return; } else { msgPassword.InnerText = ""; } //////////////////////////////////////////////////////////////// string sql = "select * from tb_User u where (u.Email = '" + StaticData.ValidParameter(Email) + "' or u.PhoneNumber = '" + StaticData.ValidParameter(Email) + "' )"; DataTable tbCheckEmail = Connect.GetTable(sql); if (tbCheckEmail.Rows.Count <= 0) { msgEmail.InnerHtml = "Email hoặc số điện thoại không đúng"; return; } sql = "select * from tb_User u where (u.Email = '" + StaticData.ValidParameter(Email) + "' or u.PhoneNumber = '" + StaticData.ValidParameter(Email) + "' ) and u.Password = '******'"; DataTable tbCheckPassword = Connect.GetTable(sql); if (tbCheckPassword == null) { msgPassword.InnerHtml = "Email hoặc mật khẩu không đúng !"; return; } else { if (tbCheckPassword.Rows.Count <= 0) { msgPassword.InnerHtml = "Email hoặc mật khẩu không đúng !"; return; } } HttpCookie cookie = new HttpCookie("Web"); cookie["CurrentUser"] = Email; Session["CurrentUser"] = Email; Session.Timeout = 600; cookie.Expires = DateTime.Now.AddDays(100); Response.Cookies.Add(cookie); object retUrl = Request.QueryString["retUrl"]; if (retUrl != null) { Response.Redirect(retUrl.ToString()); return; } Response.Redirect("/gianhang/dashboard"); }
private void loadListProduct(string sql) { if (sTenSanPham != "") { sql += " and TenSanPham like N'%" + sTenSanPham + "%'"; } if (sLoaiSanPham != "" && sLoaiSanPham != "0") { sql += " and idLoaiSanPham = '" + sLoaiSanPham + "'"; } sql += ") as tb1 "; DataTable tbTong = Connect.GetTable(sql); if (tbTong == null) { return; } int TotalRows = tbTong.Rows.Count; int count1 = 0, count2 = 0; double totalMoney = 0; for (int i = 0; i < tbTong.Rows.Count; i++) { if (!string.IsNullOrEmpty(tbTong.Rows[i]["GiaMoi"].ToString())) { totalMoney += double.Parse(tbTong.Rows[i]["GiaMoi"].ToString()); } if (tbTong.Rows[i]["KichHoat"].ToString() == "True") { count1++; } else { count2++; } } totalCol1.InnerHtml = tbTong.Rows.Count.ToString(); totalCol2.InnerHtml = totalMoney.ToString("#,##"); totalCol3.InnerHtml = count1.ToString(); totalCol4.InnerHtml = count2.ToString(); sql += "WHERE RowNumber BETWEEN (" + Page + " - 1) * " + PageSize + " + 1 AND (((" + Page + " - 1) * " + PageSize + " + 1) + " + PageSize + ") - 1"; DataTable table = Connect.GetTable(sql); string html = @""; //<th class='th'>Sửa //</th> //<th class='th'>Xóa //</th> for (int i = 0; i < table.Rows.Count; i++) { string idSanPham = table.Rows[i]["idSanPham"].ToString(); html += " <tr>"; html += " <td style='text-align:center;vertical-align: inherit;'>" + table.Rows[i]["RowNumber"].ToString() + "</td>"; html += " <td style='text-align:left;vertical-align: inherit;'><a href='" + GetRouteUrl("adminChiTietSanPham", new { id = idSanPham }) + "'>" + table.Rows[i]["MaSanPham"].ToString() + "</a></td>"; string idDonHang = table.Rows[i]["IDGianHang"].ToString(); html += " <td style='text-align:center;vertical-align: inherit;'><a href='" + GetRouteUrl("adminChiTietGianHang", new { id = idDonHang }) + "'>" + table.Rows[i]["ShopCode"].ToString() + "</a></td>"; html += " <td style='text-align:left;vertical-align: inherit;'>" + table.Rows[i]["TenSanPham"].ToString() + "</td>"; html += " <td style='text-align:center;vertical-align: inherit;'>" + StaticData.FormatDouble(table.Rows[i]["GiaCu"].ToString()) + "</td>"; html += " <td style='text-align:center;vertical-align: inherit;'>" + StaticData.FormatDouble(table.Rows[i]["GiaMoi"].ToString()) + "</td>"; string idCapCha1 = ""; string idCapCha2 = ""; string idCapCha3 = table.Rows[0]["idLoaiSanPham"].ToString(); idCapCha2 = StaticData.getField("tb_LoaiSanPham", "idCapCha", "idLoaiSanPham", idCapCha3); idCapCha1 = StaticData.getField("tb_LoaiSanPham", "idCapCha", "idLoaiSanPham", idCapCha2); string LoaiSanPham = ""; LoaiSanPham += StaticData.getField("tb_LoaiSanPham", "TenLoaiSanPham", "idLoaiSanPham", idCapCha1); LoaiSanPham += " -> " + StaticData.getField("tb_LoaiSanPham", "TenLoaiSanPham", "idLoaiSanPham", idCapCha2); LoaiSanPham += " -> " + StaticData.getField("tb_LoaiSanPham", "TenLoaiSanPham", "idLoaiSanPham", idCapCha3); html += " <td style='text-align:center;vertical-align: inherit;'>" + StaticData.DateFormat(table.Rows[i]["NgayTao"].ToString()) + "</td>"; html += " <td style='text-align:center;vertical-align: inherit;'>" + LoaiSanPham + "</td>"; //html += " <td style='text-align:center;vertical-align: inherit;'><i class='fa fa-" + (table.Rows[i]["SetHome"].ToString() == "False" ? "square" : "check") + "'></td>"; //html += " <td style='text-align:center;vertical-align: inherit;'><i class='fa fa-" + (table.Rows[i]["SetHot"].ToString() == "False" ? "square" : "check") + "'></td>"; if (table.Rows[i]["KichHoat"].ToString() == "True") { html += " <td style='text-align:center;vertical-align: inherit;'><label class='btn btn-primary'>Đã duyệt</label></td>"; } else { html += " <td style='text-align:center;vertical-align: inherit;'><label class='btn btn-danger'>Chưa duyệt</label></td>"; } html += " </tr>"; } string url = GetRouteUrl("adminSanPham", new { }) + "?"; if (sTenSanPham != "") { url += "TenSanPham=" + sTenSanPham + "&"; } if (sLoaiSanPham != "") { url += "LoaiSanPham=" + sLoaiSanPham + "&"; } url += "Page="; divPaging.InnerHtml = StaticData.CreateHTMLPagingAdmin(Page, url, StaticData.SetPage(Page, TotalRows, PageSize)); dvDanhSachLoaiTinTuc.InnerHtml = html; }
protected void btQuet_Click(object sender, EventArgs e) { HtmlWeb web = new HtmlWeb(); var url = txtUrlQuet.Value.Trim(); if (url == "") { Response.Write("<script>alert('Bạn chưa nhập link quét.')</script>"); } else { try { ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12; HtmlDocument document = web.Load(url); /*var selector = "product-info__product-info___10ne- product__product-info___3onGQ";*/ var selector = "jsx-426174879 product-info"; var resultNode = document.DocumentNode.SelectSingleNode("//div[@class=\"" + selector + "\"]"); if (resultNode == null) { Response.Write("<script>alert('Link không đúng hoặc cấu trúc html đã thay đổi.')</script>"); } var trs = resultNode.SelectNodes("h4"); var TenSP = trs[1].InnerText; var divGia = resultNode.SelectNodes("div")[0].SelectNodes("span"); var GiaCu = divGia[0].InnerText.Replace(",", "").Replace("₫", ""); var GiaMoi = divGia[1].InnerText.Replace(",", "").Replace("₫", ""); var Size = document.DocumentNode.SelectSingleNode("//div[@class=\"jsx-85280374 product-size\"]"); string listSize = ""; if (Size == null) { listSize = StaticData.getField("tb_Size", "idSize", "isDefault", "1"); } else { var buttonSize = Size.SelectNodes("div").Skip(1); foreach (var bt in buttonSize) { if (listSize != "") { listSize += "-"; } string S = bt.InnerHtml.Split(new[] { "<div" }, StringSplitOptions.None)[0]; string sqlkt = "select * from tb_Size where Size = '" + S + "'"; DataTable tbkt = Connect.GetTable(sqlkt); string idSize = ""; if (tbkt.Rows.Count > 0) { idSize = tbkt.Rows[0]["idSize"].ToString(); } else { Connect.Exec("insert tb_Size(Size,KichHoat,isDefault) values('" + S + "','1',0)"); idSize = StaticData.getField("tb_Size", "MAX(idSize)", "1", "1"); } listSize += idSize; } } // size cũ //var Size = document.DocumentNode.SelectSingleNode("//div[@class=\"product__sizes___27zL9\"]"); //string listSize = ""; //if (Size == null) // listSize = StaticData.getField("tb_Size", "idSize", "isDefault", "1"); //else //{ // var buttonSize = Size.SelectNodes("button"); // foreach (var bt in buttonSize) // { // if (listSize != "") // listSize += "-"; // string S = bt.InnerHtml.Split(new[] { "<div" }, StringSplitOptions.None)[0]; // string sqlkt = "select * from tb_Size where Size = '" + S + "'"; // DataTable tbkt = Connect.GetTable(sqlkt); // string idSize = ""; // if (tbkt.Rows.Count > 0) // { // idSize = tbkt.Rows[0]["idSize"].ToString(); // } // else // { // Connect.Exec("insert tb_Size(Size,KichHoat,isDefault) values('" + S + "','1',0)"); // idSize = StaticData.getField("tb_Size", "MAX(idSize)", "1", "1"); // } // listSize += idSize; // } //} //var Img = document.DocumentNode.SelectSingleNode("//ul[@id=\"images-container\"]"); //string listImg = ""; //var liImg = Img.SelectNodes("li"); //foreach (var img in liImg) //{ // if (listImg != "") // listImg += "|~|"; // listImg += img.SelectSingleNode("img").Attributes[2].Value.Replace("/w90/", "/w580/"); //} var Img = document.DocumentNode.SelectSingleNode("//div[@class=\"jsx-843506535 jsx-796085701 content\"]").SelectSingleNode("img").Attributes["src"].Value.Split('/'); string link = ""; for (int i = 0; i < Img.Length - 1; i++) { if (link != "") { link += "/"; } link += Img[i]; } string listImg = ""; var liImg = Img[Img.Length - 1].Split(','); foreach (var img in liImg) { if (listImg != "") { listImg += "|~|"; } listImg += link + "/" + img; } var ThongTinSP = document.DocumentNode.SelectSingleNode("//div[@class=\"jsx-3971805357 product-description\"]").SelectNodes("div")[0].SelectNodes("div")[1].SelectSingleNode("//div[@class=\"jsx-3971805357\"]").InnerHtml; var MoTa = document.DocumentNode.SelectSingleNode("//div[@class=\"jsx-2088491857 brand-info undefined\"]").InnerHtml; string LoaiSanPham = slLoaiSanPham.Value.Trim(); if (LoaiSanPham == "0") { LoaiSanPham = "null"; } string sqlInserNguoiDung = "insert into tb_SanPham(TenSanPham,GiaCu,GiaMoi,Mau, Size,MoTa,ThongTinSP,idLoaiSanPham,SetHome,SetHot,KichHoat)"; sqlInserNguoiDung += " values(N'" + TenSP + "',N'" + GiaCu + "',N'" + GiaMoi + "','" + StaticData.getField("tb_Mau", "idMau", "isDefault", "1") + "','" + listSize + "',N'" + MoTa.Replace("'", "''") + "',N'" + ThongTinSP.Replace("'", "''") + "'," + LoaiSanPham + ",'1','1','1')"; bool ktInsertNguoiDung = Connect.Exec(sqlInserNguoiDung); if (ktInsertNguoiDung) { string id = StaticData.getField("[tb_SanPham]", "Max(idSanPham)", "1", "1"); //them orderdetail string[] arrHinhAnh = listImg.Split(new string[] { "|~|" }, StringSplitOptions.None); for (int i = 0; i < arrHinhAnh.Length; i++) { if (arrHinhAnh[i].Trim() != "") { string sql = "insert into tb_HinhAnhSanPham(idSanPham,LinkHinh)"; sql += " Values (" + id + ",N'" + arrHinhAnh[i].Trim() + "')"; Connect.Exec(sql); } } Response.Redirect(GetRouteUrl("adminSanPham", new { })); } else { Response.Write("<script>alert('Lỗi !')</script>"); } } catch (Exception r) { Response.Write("<script>alert('Link không đúng hoặc cấu trúc html đã thay đổi.')</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { try { Page = int.Parse(Request.QueryString["Page"].ToString()); } catch { Page = 1; } if (!IsPostBack) { if (Request.Cookies["QuanLyCongNoAnhKiet_Login"] != null && Request.Cookies["QuanLyCongNoAnhKiet_Login"].Value.Trim() != "") { mTenDangNhap = Request.Cookies["QuanLyCongNoAnhKiet_Login"].Value.Trim(); mIdNguoiDung = StaticData.getField("tb_NguoiDung", "idNguoiDung", "TenDangNhap", mTenDangNhap); mIdKhachHang = StaticData.getField("tb_KhachHang", "idKhachHang", "TenDangNhap", mTenDangNhap); mQuyen = MyStaticData.GetMaQuyen(mTenDangNhap); if (mQuyen.ToUpper() != "ADMIN" && mQuyen.ToUpper() != "KH" && mQuyen.ToUpper() != "QTWS") { Response.Redirect("../Home/DangNhap.aspx"); } if (mQuyen.ToUpper() == "KH") { txtTenKhachHang.Disabled = true; } } LoadTinhTrang(); LoadKho(); LoadNhanVienGiao(); try { if (Request.QueryString["TuNgay"].Trim() != "") { sTuNgay = Request.QueryString["TuNgay"].Trim(); txtTuNgay.Value = sTuNgay; } } catch { } try { if (Request.QueryString["DenNgay"].Trim() != "") { sDenNgay = Request.QueryString["DenNgay"].Trim(); txtDenNgay.Value = sDenNgay; } } catch { } try { if (Request.QueryString["MaDonHang"].Trim() != "") { sMaDonHang = Request.QueryString["MaDonHang"].Trim(); txtMaDonHang.Value = sMaDonHang; } } catch { } try { if (Request.QueryString["idKho"].Trim() != "") { sIdKho = Request.QueryString["idKho"].Trim(); slKho.Value = sIdKho; } } catch { } try { if (Request.QueryString["idNguoiDung"].Trim() != "") { sIdNguoiDung = Request.QueryString["idNguoiDung"].Trim(); slNhanVienGiao.Value = sIdNguoiDung; } } catch { } try { if (Request.QueryString["MaTinhTrang"].Trim() != "") { sMaTinhTrang = Request.QueryString["MaTinhTrang"].Trim(); slTinhTrang.Value = sMaTinhTrang; } } catch { } try { if (Request.QueryString["idKhachHang"].Trim() != "") { sIdKhachHang = Request.QueryString["idKhachHang"].Trim(); hdIdKhachHang.Value = sIdKhachHang; txtTenKhachHang.Value = StaticData.getField("tb_KhachHang", "TenKhachHang", "idKhachHang", sIdKhachHang); } } catch { } LoadDonHang(); } }
private void LoadDonHang() { string sql = ""; sql += @"select * from ( SELECT ROW_NUMBER() OVER ( ORDER BY idDonHang desc )AS RowNumber ,* FROM tb_DonHang where 1 = 1 "; if (sMaDonHang != "") { sql += " and MaDonHang like N'%" + sMaDonHang + "%'"; } if (sIdKho != "" && sIdKho != "0") { sql += " and idKho = '" + sIdKho + "'"; } if (sIdNguoiDung != "" && sIdNguoiDung != "0") { sql += " and idNguoiDung = '" + sIdNguoiDung + "'"; } if (sMaTinhTrang != "" && sMaTinhTrang != "0") { sql += " and MaTinhTrang = '" + sMaTinhTrang + "'"; } if (sTuNgay != "") { sql += " and NgayLap >= '" + StaticData.ConvertDDMMtoMMDD(sTuNgay) + " 00:00:00'"; } if (sDenNgay != "") { sql += " and NgayLap <= '" + StaticData.ConvertDDMMtoMMDD(sDenNgay) + " 23:59:59'"; } if (mQuyen.ToUpper() == "KH") { sql += " and idKhachHang = '" + mIdKhachHang + "'"; } if (sIdKhachHang != "" && sIdKhachHang != "") { sql += " and idKhachHang='" + sIdKhachHang + "'"; } sql += ") as tb1 WHERE RowNumber BETWEEN (" + Page + " - 1) * " + PageSize + " + 1 AND (((" + Page + " - 1) * " + PageSize + " + 1) + " + PageSize + ") - 1"; DataTable table = Connect.GetTable(sql); //txtNoiDung.InnerHtml = table.Rows[0]["NoiDung"].ToString(); SetPage(); string html = @"<center><table class='table table-bordered table-hover dataTable'> <tr> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> STT </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Mã đơn hàng </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Ngày lập </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Khách hàng </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Người nhận </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Địa chỉ người nhận </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Nhân viên giao hàng </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Số điện thoại </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Tổng số lượng </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Tổng tiền hàng </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Tổng tiền cước </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Tình trạng </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> </th> </tr>"; for (int i = 0; i < table.Rows.Count; i++) { string sqlCTDH = "select TongSoLuong=sum(isnull(SoLuong,0)),TongTienHang=sum(isnull(TienHang,0)),TongTienCuoc=sum(isnull(TienCuoc,0)) from tb_ChiTietDonHang where idDonHang='" + table.Rows[i]["idDonHang"].ToString() + "'"; DataTable tbCTDH = Connect.GetTable(sqlCTDH); html += " <tr>"; html += " <td>" + (((Page - 1) * PageSize) + i + 1).ToString() + "</td>"; html += " <td>" + table.Rows[i]["MaDonHang"].ToString() + "</td>"; if (table.Rows[i]["NgayLap"].ToString() != "") { html += " <td>" + DateTime.Parse(table.Rows[i]["NgayLap"].ToString()).ToString("dd/MM/yyyy") + "</td>"; } else { html += " <td></td>"; } html += " <td>" + StaticData.getField("tb_KhachHang", "TenKhachHang", "idKhachHang", table.Rows[i]["idKhachHang"].ToString()) + "</td>"; html += " <td>" + table.Rows[i]["NguoiNhan"].ToString() + "</td>"; //if (table.Rows[i]["ThoiDiemDuKienGiao"].ToString() != "") // html += "<td>" + DateTime.Parse(table.Rows[i]["ThoiDiemDuKienGiao"].ToString()).ToString("dd/MM/yyyy hh:mm") + "</td>"; //else // html += "<td></td>"; //html += " <td>" + StaticData.getField("tb_Kho", "TenKho", "idKho", table.Rows[i]["idKho"].ToString()) + "</td>"; html += " <td>" + table.Rows[i]["DiaChiNguoiNhan"].ToString() + "</td>"; html += " <td>" + StaticData.getField("tb_NguoiDung", "HoTen", "idNguoiDung", table.Rows[i]["idNguoiDung"].ToString()) + "</td>"; html += " <td>" + StaticData.getField("tb_NguoiDung", "SoDienThoai", "idNguoiDung", table.Rows[i]["idNguoiDung"].ToString()) + "</td>"; if (tbCTDH.Rows.Count > 0) { if (tbCTDH.Rows[0]["TongSoLuong"].ToString() != "") { html += "<td>" + tbCTDH.Rows[0]["TongSoLuong"].ToString() + "</td>"; TongSoLuong += int.Parse(tbCTDH.Rows[0]["TongSoLuong"].ToString()); } else { html += "<td>0</td>"; } if (tbCTDH.Rows[0]["TongTienHang"].ToString() != "") { html += "<td>" + double.Parse(tbCTDH.Rows[0]["TongTienHang"].ToString()).ToString("#,##").Replace(",", ".") + "</td>"; TongTienHang += double.Parse(tbCTDH.Rows[0]["TongTienHang"].ToString()); } else { html += "<td>0</td>"; } if (tbCTDH.Rows[0]["TongTienCuoc"].ToString() != "") { html += "<td>" + double.Parse(tbCTDH.Rows[0]["TongTienCuoc"].ToString()).ToString("#,##").Replace(",", ".") + "</td>"; TongTienCuoc += double.Parse(tbCTDH.Rows[0]["TongTienCuoc"].ToString()); } else { html += "<td>0</td>"; } } else { html += "<td></td>"; html += "<td></td>"; html += "<td></td>"; } html += " <td>" + StaticData.getField("tb_TinhTrang", "TenTinhTrang", "MaTinhTrang", table.Rows[i]["MaTinhTrang"].ToString()) + "</td>"; html += " <td><a style='cursor:pointer' onclick='XemChiTietDonHang(\"" + table.Rows[i]["idDonHang"].ToString() + "\")'>Xem chi tiết</a></td>"; html += " </tr>"; } html += " </table><table > <tr>"; html += " <td colspan='21' class='footertable'>"; string url = "ThongKeDonHang.aspx?"; if (sMaDonHang != "") { url += "MaDonHang=" + sMaDonHang + "&"; } if (sIdKho != "" && sIdKho != "0") { url += "idKho=" + sIdKho + "&"; } if (sIdNguoiDung != "" && sIdNguoiDung != "0") { url += "idNguoiDung=" + sIdNguoiDung + "&"; } if (sMaTinhTrang != "" && sMaTinhTrang != "0") { url += "MaTinhTrang=" + sMaTinhTrang + "&"; } if (sTuNgay != "") { url += "TuNgay=" + sTuNgay + "&"; } if (sDenNgay != "") { url += "DenNgay=" + sDenNgay + "&"; } if (sIdKhachHang != "" && sIdKhachHang != "0") { url += "idKhachHang=" + sIdKhachHang; } url += "Page="; html += StaticData.PhanTrang(url, txtFistPage, txtPage1, txtPage2, txtPage3, txtPage4, txtPage5, txtLastPage, Page); html += " </td></tr><tr><td colspan='17'> </td></tr>"; html += " </table></center>"; html += "<div style='text-align:right;font-size: 20px;'><b>Tổng số hóa đơn:</b> " + SoHoaDon.ToString() + "</div>"; html += "<div style='text-align:right;font-size: 20px;'><b>Tổng tiền hàng:</b> " + TongTienHang.ToString("#,##").Replace(",", ".") + "</div>"; html += "<div style='text-align:right;font-size: 20px;'><b>Tổng tiền cước:</b> " + TongTienCuoc.ToString("#,##").Replace(",", ".") + "</div>"; dvDanhSachDonHang.InnerHtml = html; }
private void SetPage() { string sql = "select count(idDonHang) from tb_DonHang where '1'='1'"; if (sMaDonHang != "") { sql += " and MaDonHang like N'%" + sMaDonHang + "%'"; } if (sIdKho != "" && sIdKho != "0") { sql += " and idKho = '" + sIdKho + "'"; } if (sIdNguoiDung != "" && sIdNguoiDung != "0") { sql += " and idNguoiDung = '" + sIdNguoiDung + "'"; } if (sMaTinhTrang != "" && sMaTinhTrang != "0") { sql += " and MaTinhTrang = '" + sMaTinhTrang + "'"; } if (sTuNgay != "") { sql += " and NgayLap >= '" + StaticData.ConvertDDMMtoMMDD(sTuNgay) + " 00:00:00'"; } if (sDenNgay != "") { sql += " and NgayLap <= '" + StaticData.ConvertDDMMtoMMDD(sDenNgay) + " 23:59:59'"; } if (mQuyen.ToUpper() == "KH") { sql += " and idKhachHang = '" + mIdKhachHang + "'"; } if (sIdKhachHang != "" && sIdKhachHang != "") { sql += " and idKhachHang='" + sIdKhachHang + "'"; } DataTable tbTotalRows = Connect.GetTable(sql); int TotalRows = int.Parse(tbTotalRows.Rows[0][0].ToString()); SoHoaDon = TotalRows; if (TotalRows % PageSize == 0) { MaxPage = TotalRows / PageSize; } else { MaxPage = TotalRows / PageSize + 1; } txtLastPage = MaxPage.ToString(); if (Page == 1) { for (int i = 1; i <= MaxPage; i++) { if (i <= 5) { switch (i) { case 1: txtPage1 = i.ToString(); break; case 2: txtPage2 = i.ToString(); break; case 3: txtPage3 = i.ToString(); break; case 4: txtPage4 = i.ToString(); break; case 5: txtPage5 = i.ToString(); break; } } else { return; } } } else { if (Page == 2) { for (int i = 1; i <= MaxPage; i++) { if (i == 1) { txtPage1 = "1"; } if (i <= 5) { switch (i) { case 2: txtPage2 = i.ToString(); break; case 3: txtPage3 = i.ToString(); break; case 4: txtPage4 = i.ToString(); break; case 5: txtPage5 = i.ToString(); break; } } else { return; } } } else { int Cout = 1; if (Page <= MaxPage) { for (int i = Page; i <= MaxPage; i++) { if (i == Page) { txtPage1 = (Page - 2).ToString(); txtPage2 = (Page - 1).ToString(); } if (Cout <= 3) { if (i == Page) { txtPage3 = i.ToString(); } if (i == (Page + 1)) { txtPage4 = i.ToString(); } if (i == (Page + 2)) { txtPage5 = i.ToString(); } Cout++; } else { return; } } } else { //Page = MaxPage; SetPage(); } } } }
public ActionResult Index(string DistId = "", string username = "", string Search = "", int Pagesize = 10) { var UserType = ApplicationUtilities.GetSessionValue("UserType").ToString(); string SubDistId = ""; if (UserType.ToUpper() == "SUB-DISTRIBUTOR") { DistId = Session["ParentId"].ToString(); SubDistId = Session["AgentId"].ToString(); } else { DistId = DistId.DecryptParameter(); if (string.IsNullOrEmpty(DistId)) { return(RedirectToAction("Index", "Distributor")); } } if (string.IsNullOrEmpty(username)) { username = Session["UserName"].ToString(); } string IsPrimary = ApplicationUtilities.GetSessionValue("IsPrimaryUser").ToString(); var lst = ISD.GetSubDistributorsList(username, DistId, SubDistId); foreach (var item in lst) { item.Action = StaticData.GetActions("Subdistributor", item.AgentID.ToString().EncryptParameter(), this, "", "", ""); //item.kycstatus = "<img src='/Content/assets/images/service logos/" + item.ProductLogo + "' height='50' width='50' />"; item.AgentStatus = "<span class='badge badge-" + (item.AgentStatus.Trim().ToUpper() == "Y" ? "success" : "danger") + "'>" + (item.AgentStatus.Trim().ToUpper() == "Y" ? "Enable" : "Disable") + "</span>"; if (item.kycstatus.ToUpper().Equals("PENDING")) { item.kycstatus = "<span class='badge badge-warning'>Pending</span>"; } else if (item.kycstatus.ToUpper().Equals("APPROVED")) { item.kycstatus = "<span class='badge badge-success'>Approved</span>"; } else { item.kycstatus = "<span class='badge badge-danger'>Rejected</span>"; } } IDictionary <string, string> param = new Dictionary <string, string>(); //param.Add("ProductId", "Product Id"); // param.Add("ProductLogo", "Product Logo"); param.Add("AgentName", "Agent Name"); param.Add("AgentOperationType", "Operation Type"); param.Add("AgentMobileNumber", "Contact Number"); param.Add("AgentStatus", "Agent Status"); param.Add("kycstatus", "Kyc Status"); param.Add("Action", "Action"); ProjectGrid.column = param; var grid = ProjectGrid.MakeGrid(lst, "Sub-Distributor", Search, Pagesize, true, "", "", "Home", "Sub-Distributor", "/Admin/subdistributor", String.IsNullOrEmpty(IsPrimary) == false && IsPrimary.ToUpper().Trim() == "Y" ?"/Admin/subdistributor/Manage?parentid=" + DistId.EncryptParameter():""); ViewData["grid"] = grid; return(View()); }
private string getUrlImageByID(string id) { return(StaticData.validImage(StaticData.getField("tb_HinhAnhRaoVat", "LinkHinh", "idSanPham", id))); }
private void LoadDuAn() { string sql = ""; sql += @"select * from( SELECT ROW_NUMBER() OVER(ORDER BY ChiTietPhieuXuat.NgayXuatChiTiet desc)AS RowNumber,KhachHang.TenKhachHang,ChiTietPhieuXuat.GhiChu,ChiTietPhieuXuat.NgayXuatChiTiet,PhieuXuat.MaPhieuXuat,HangHoa.TenHangHoa,HangHoa.MaHangHoa,ChiTietPhieuXuat.SoLuong,ChiTietPhieuXuat.DonGiaXuat from ChiTietPhieuXuat left join KhachHang on ChiTietPhieuXuat.IDKhachHang = KhachHang.IDKhachHang left join HangHoa on ChiTietPhieuXuat.IDHangHoa = HangHoa.IDHangHoa left join PhieuXuat on ChiTietPhieuXuat.IDPhieuXuat = PhieuXuat.IDPhieuXuat where '1'='1' and ChiTietPhieuXuat.TinhTrang = N'Còn nợ' "; if (pTenSanPham != "") { sql += " and HangHoa.TenHangHoa like N'%" + pTenSanPham + "%'"; } if (pTenKhachHang != "") { sql += " and KhachHang.TenKhachHang like N'%" + pTenKhachHang + "%'"; } if (pMaPhieuXuat != "") { sql += " and PhieuXuat.MaPhieuXuat like N'%" + pMaPhieuXuat + "%'"; } if (pTuNgayBan != "") { sql += " and ChiTietPhieuXuat.NgayXuatChiTiet >='" + StaticData.ConvertDDMMtoMMDD(pTuNgayBan) + " 00:00:00'"; } if (pDenNgayBan != "") { sql += " and ChiTietPhieuXuat.NgayXuatChiTiet <='" + StaticData.ConvertDDMMtoMMDD(pDenNgayBan) + " 00:00:00'"; } sql += " ) as tb1"; DataTable Tong = Connect.GetTable("select isnull(SUM(tab2.SoLuong * tab2.DonGiaXuat),0) as 'Tong',isnull(SUM(tab2.SoLuong),0) as 'sl',isnull(sum(tab2.DonGiaXuat),0) as 'dgx' from (" + sql + ") as tab2"); sql += " WHERE RowNumber BETWEEN (" + Page + " - 1) * " + PageSize + " + 1 AND (((" + Page + " - 1) * " + PageSize + " + 1) + " + PageSize + ") - 1"; DataTable table = Connect.GetTable(sql); SetPage(); string html = @" <table class='table table-bordered table-striped'> <tr> <th class='th'> STT </th> <th class='th'> Ngày xuất </th> <th class='th'> Mã phiếu xuất </th> <th class='th'> Mã hàng hóa </th> <th class='th'> Tên hàng hóa </th> <th class='th'> Số lượng </th> <th class='th'> Đơn giá xuất </th> <th class='th'> Thành tiền </th> <th class='th'> Tên khách hàng </th> <th class='th'> Ghi chú </th> </tr>"; // double SoTienPhaiThu = 0; for (int i = 0; i < table.Rows.Count; i++) { html += " <tr>"; html += " <td>" + (((Page - 1) * PageSize) + i + 1).ToString() + "</td>"; html += " <td>" + DateTime.Parse(table.Rows[i]["NgayXuatChiTiet"].ToString()).ToString("dd/MM/yyyy") + "</td>"; html += " <td>" + table.Rows[i]["MaPhieuXuat"].ToString() + "</td>"; html += " <td>" + table.Rows[i]["MaHangHoa"].ToString() + "</td>"; html += " <td>" + table.Rows[i]["TenHangHoa"].ToString() + "</td>"; double r = double.Parse(table.Rows[i]["SoLuong"].ToString()); html += " <td>" + r.ToString("#,##").Replace(",", ".") + "</td>"; double r2 = double.Parse(table.Rows[i]["DonGiaXuat"].ToString()); // html += " <td>" + table.Rows[i]["DonGiaNhap"].ToString() + "</td>"; html += " <td>" + r2.ToString("#,##").Replace(",", ".") + "</td>"; double tong = r * r2; html += " <td>" + tong.ToString("#,##").Replace(",", ".") + "</td>"; html += " <td>" + table.Rows[i]["TenKhachHang"].ToString() + "</td>"; html += " <td>" + table.Rows[i]["GhiChu"].ToString().Trim() + "</td>"; // html += " <td style='text-align:center;font-size: 100%;'><a href='#' onclick='window.location=\"DanhMucHangHoa-CapNhat.aspx?Page=" + Page.ToString() + "&IDHangHoa=" + table.Rows[i]["IDHangHoa"].ToString() + "\"'><img title='Sửa' class='imgCommand' src='../Images/edit.png' onclick='window.location=\"DanhMucHangHoa-CapNhat.aspx?Page=" + Page.ToString() + "&IDHangHoa=" + table.Rows[i]["IDHangHoa"].ToString() + "\"' /> Sửa </a></td>"; // html += " <td style='text-align:center;font-size: 100%;'><a href='#' onclick='DeleteHangHoa(\"" + table.Rows[i]["IDHangHoa"].ToString() + "\")'><img title='Xóa' class='imgCommand' src='../Images/delete.png' onclick='DeleteHangHoa(\"" + table.Rows[i]["IDHangHoa"].ToString() + "\")' />Xóa</a></td>"; html += " </tr>"; } html += "<tr style='background-color: #00ff00;'>"; html += "<td colspan='5' style='text-align: right;'><b>Tổng:</b></td>"; double a = double.Parse(Tong.Rows[0]["sl"].ToString()); double a2 = double.Parse(Tong.Rows[0]["dgx"].ToString()); double a3 = double.Parse(Tong.Rows[0]["Tong"].ToString()); html += "<td><b>" + a.ToString("#,##").Replace(",", ".") + "</b></td>"; html += "<td><b>" + a2.ToString("#,##").Replace(",", ".") + "</b></td>"; html += "<td><b>" + a3.ToString("#,##").Replace(",", ".") + "</b></td>"; html += "<td colspan='2'> </td>"; html += "</tr>"; html += " <tr>"; html += " <td colspan='10' class='footertable'>"; string url = "CongNo.aspx?"; if (pTenSanPham != "") { url += "TenSanPham=" + pTenSanPham + "&"; } if (pTuNgayBan != "") { url += "TuNgayBan=" + pTuNgayBan + "&"; } if (pDenNgayBan != "") { url += "DenNgayBan=" + pDenNgayBan + "&"; } if (pTenKhachHang != "") { url += "TenKhachHang=" + pTenKhachHang + "&"; } if (pMaPhieuXuat != "") { url += "MaPhieuXuat=" + pMaPhieuXuat + "&"; } url += "Page="; html += " <a class='notepaging' id='page_fist' href='" + url + txtFistPage + "' /><<</a>"; //Page 1 if (txtPage1 != "") { if (Page.ToString() == txtPage1) { html += " <a id='page_1' class='notepagingactive' href='" + url + txtPage1 + "' />" + txtPage1 + "</a>"; } else { html += " <a id='page_1' class='notepaging' href='" + url + txtPage1 + "' />" + txtPage1 + "</a>"; } } else { html += " <a id='page_1' class='notepagingnone' href='" + url + txtPage1 + "' />" + txtPage1 + "</a>"; } //Page 2 if (txtPage2 != "") { if (Page.ToString() == txtPage2) { html += " <a id='page_2' class='notepagingactive' href='" + url + txtPage2 + "' />" + txtPage2 + "</a>"; } else { html += " <a id='page_2' class='notepaging' href='" + url + txtPage2 + "' />" + txtPage2 + "</a>"; } } else { html += " <a id='page_2' class='notepagingnone' href='" + url + txtPage2 + "' />" + txtPage2 + "</a>"; } //Page 3 if (txtPage3 != "") { if (Page.ToString() == txtPage3) { html += " <a id='page_3' class='notepagingactive' href='" + url + txtPage3 + "' />" + txtPage3 + "</a>"; } else { html += " <a id='page_3' class='notepaging' href='" + url + txtPage3 + "' />" + txtPage3 + "</a>"; } } else { html += " <a id='page_3' class='notepagingnone' href='" + url + txtPage3 + "' />" + txtPage3 + "</a>"; } //Page 4 if (txtPage4 != "") { if (Page.ToString() == txtPage4) { html += " <a id='page_4' class='notepagingactive' href='" + url + txtPage4 + "' />" + txtPage4 + "</a>"; } else { html += " <a id='page_4' class='notepaging' href='" + url + txtPage4 + "' />" + txtPage4 + "</a>"; } } else { html += " <a id='page_4' class='notepagingnone' href='" + url + txtPage4 + "' />" + txtPage4 + "</a>"; } //Page 5 if (txtPage5 != "") { if (Page.ToString() == txtPage5) { html += " <a id='page_5' class='notepagingactive' href='" + url + txtPage5 + "' />" + txtPage5 + "</a>"; } else { html += " <a id='page_5' class='notepaging' href='" + url + txtPage5 + "' />" + txtPage5 + "</a>"; } } else { html += " <a id='page_5' class='notepagingnone' href='" + url + txtPage5 + "' />" + txtPage5 + "</a>"; } html += " <a id='page_last' class='notepaging' href='" + url + txtLastPage + "' />>></a>"; html += " </td>"; html += "</tr>"; /**/ html += " </table>"; dvNguoiDung.InnerHtml = html; }
protected void btnsearch_Click(object sender, EventArgs e) { String separator = ""; String monthsearch = ""; String divsearch = ""; string areasearch = ""; string empsearch = ""; foreach (ListItem itm in src_month4m.Items) { if (itm.Selected) { monthsearch = monthsearch + separator + "'" + itm.Value + "'"; separator = ","; } } separator = ""; foreach (ListItem itm in src_div.Items) { if (itm.Selected) { divsearch = divsearch + separator + "'" + itm.Value + "'"; separator = ","; } } separator = ""; foreach (ListItem itm in src_area.Items) { if (itm.Selected) { areasearch = areasearch + separator + "'" + itm.Value + "'"; separator = ","; } } separator = ""; foreach (ListItem itm in src_employee.Items) { if (itm.Selected) { empsearch = empsearch + separator + "'" + itm.Value + "'"; separator = ","; } } SearchReportCommon itmsearch = new SearchReportCommon(); itmsearch.months = monthsearch; itmsearch.divs = divsearch; itmsearch.areas = areasearch; itmsearch.emps = empsearch; itmsearch.yr = src_year.SelectedValue; FetchReportdata(itmsearch, 0); String curyear = DateTime.Now.Year.ToString(); StaticData itmstat = (new RptDocChemMapDL()).GetDropdownData(monthsearch, curyear); src_area.DataSource = itmstat.lstarea; src_area.DataBind(); src_employee.DataSource = itmstat.lstemployee; src_employee.DataBind(); }
//private void SetPage() //{ // string sql = "select cout "; // //if (sTenLoai != "") // // sql += " and TenLoaiCuoc like N'%" + sTenLoai + "%'"; // //if (Tuyen != "") // sql += " and tg.TenTuyen like N'%" + Tuyen + "%'"; // DataTable tbTotalRows = Connect.GetTable(sql); // int TotalRows = int.Parse(tbTotalRows.Rows[0][0].ToString()); // if (TotalRows % PageSize == 0) // MaxPage = TotalRows / PageSize; // else // MaxPage = TotalRows / PageSize + 1; // txtLastPage = MaxPage.ToString(); // if (Page == 1) // { // for (int i = 1; i <= MaxPage; i++) // { // if (i <= 5) // { // switch (i) // { // case 1: txtPage1 = i.ToString(); break; // case 2: txtPage2 = i.ToString(); break; // case 3: txtPage3 = i.ToString(); break; // case 4: txtPage4 = i.ToString(); break; // case 5: txtPage5 = i.ToString(); break; // } // } // else // return; // } // } // else // { // if (Page == 2) // { // for (int i = 1; i <= MaxPage; i++) // { // if (i == 1) // txtPage1 = "1"; // if (i <= 5) // { // switch (i) // { // case 2: txtPage2 = i.ToString(); break; // case 3: txtPage3 = i.ToString(); break; // case 4: txtPage4 = i.ToString(); break; // case 5: txtPage5 = i.ToString(); break; // } // } // else // return; // } // } // else // { // int Cout = 1; // if (Page <= MaxPage) // { // for (int i = Page; i <= MaxPage; i++) // { // if (i == Page) // { // txtPage1 = (Page - 2).ToString(); // txtPage2 = (Page - 1).ToString(); // } // if (Cout <= 3) // { // if (i == Page) // txtPage3 = i.ToString(); // if (i == (Page + 1)) // txtPage4 = i.ToString(); // if (i == (Page + 2)) // txtPage5 = i.ToString(); // Cout++; // } // else // return; // } // } // else // { // //Page = MaxPage; // SetPage(); // } // } // } //} #endregion private void LoadLoaiSanPham() { string sql = "select lc.MaLoaiCuoc as MaLoaiCuoc,tg.TenTuyen as TuyenGD , tg.MTGiaoDich as MaTuyen, g.Duoi200 as Duoi200 , g.Tu200to3000 as Duoi3000,g.Tu3000to8000 as Duoi8000,g.Tren8000 as Tren8000"; sql += " from tb_TuyenGiaoDich tg,tb_LoaiCuoc lc, tb_GiaCuoc g where tg.MTGiaoDich = lc.MTGiaoDich"; sql += " and g.MaLoaiTuyen = tg.MTGiaoDich"; // sql += @"select * from // ( // SELECT ROW_NUMBER() OVER // ( // ORDER BY TenLoaiCuoc // )AS RowNumber // ,* // FROM tb_LoaiCuoc where 1 = 1 // "; // if (sTenLoai != "") // sql += " and TenLoaiCuoc like N'%" + sTenLoai + "%'"; // if (sMaLoai != "") // sql += " and MaLoaiCuoc like N'%" + sMaLoai + "%'"; // sql += ") as tb1 WHERE RowNumber BETWEEN (" + Page + " - 1) * " + PageSize + " + 1 AND (((" + Page + " - 1) * " + PageSize + " + 1) + " + PageSize + ") - 1"; if (Tuyen != "") { sql += " and tg.TenTuyen like N'%" + Tuyen + "%'"; } DataTable table = Connect.GetTable(sql); //txtNoiDung.InnerHtml = table.Rows[0]["NoiDung"].ToString(); //SetPage(); string html = @"<center><table class='table table-bordered table-striped' style='width:100%;radius:2px;'> <tr> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> STT </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;text-align:left'> Tuyến Giao Nhận </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;text-align:left'> Giá Cước < 200 kg </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;text-align:left'> Giá Cước 200 - <3000 kg </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;text-align:left'> Giá Cước 3000 - <8000 kg </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;text-align:left'> Giá Cước >8000 kg </th> <th class='th' style='background-color:#1c9c13;font-size:15px;color:white;'> Sửa Giá Cước </th> </tr>"; for (int i = 0; i < table.Rows.Count; i++) { html += " <tr>"; html += " <td style='text-align:center;vertical-align: inherit;'>" + (((Page - 1) * PageSize) + i + 1).ToString() + "</td>"; html += " <td>" + table.Rows[i]["TuyenGD"].ToString() + "</td>"; html += " <td>" + double.Parse(table.Rows[i]["Duoi200"].ToString()).ToString("N0").Replace(",", ".") + "</td>"; html += " <td>" + double.Parse(table.Rows[i]["Duoi3000"].ToString()).ToString("N0").Replace(",", ".") + "</td>"; html += " <td>" + double.Parse(table.Rows[i]["Duoi8000"].ToString()).ToString("N0").Replace(",", ".") + "</td>"; html += " <td>" + double.Parse(table.Rows[i]["Tren8000"].ToString()).ToString("N0").Replace(",", ".") + "</td>"; //html += " <td><a style='cursor:pointer' href='#' onclick ='MoPopup(\"" + table.Rows[i]["MaTuyen"].ToString()+"\")' >Giá Cước</a></td>"; //html += " <td style='text-align:center;vertical-align: inherit;'>" + (table.Rows[i]["GiaCuoc"].ToString() == "" ? "" : double.Parse(table.Rows[i]["GiaCuoc"].ToString()).ToString("N0").Replace(",", ".")) + "</td>"; html += " <td style='text-align:center;vertical-align: inherit;font-size:20px;white-space: nowrap;'>"; html += " <a style='cursor:pointer' href='#' onclick ='MoPopup(\"" + table.Rows[i]["MaTuyen"].ToString() + "\")'<i class='fa fa-edit'></i></a>"; //html += " <a href='#' onclick='DeleteKho(\"" + table.Rows[i]["MaLoaiCuoc"].ToString() + "\")'> <i class='fa fa-trash'></i></a>"; html += " </td>"; html += " </tr>"; } html += " </table><table > <tr>"; html += " <td colspan='17' class='footertable'>"; string url = "DanhMucLoaiCuoc.aspx?"; //if (sTenLoai != "") // url += "TenLoai=" + sTenLoai + "&"; if (Tuyen != "") { url += "Tuyen=" + Tuyen + "&"; } url += "Page="; html += StaticData.PhanTrang(url, txtFistPage, txtPage1, txtPage2, txtPage3, txtPage4, txtPage5, txtLastPage, Page); html += " </td></tr><tr><td colspan='17'> </td></tr>"; html += " </table></center>"; dvDanhSachKho.InnerHtml = html; }
protected void btLuu_Click(object sender, EventArgs e) { string NgayChi = ""; string NoiDung = ""; string SoTien = ""; //Ngày chi if (txtNgayChi.Value.Trim() != "") { NgayChi = StaticData.ConvertDDMMtoMMDD(txtNgayChi.Value.Trim()); } else { Response.Write("<script>alert('Bạn chưa nhập ngày chi!')</script>"); return; } //Nội dung if (txtNoiDung.Value.Trim() != "") { NoiDung = txtNoiDung.Value.Trim(); } else { Response.Write("<script>alert('Bạn chưa nhập nội dung!')</script>"); return; } //Số tiền if (txtSoTien.Value.Trim().Replace(",", "").Replace(".", "") != "") { SoTien = txtSoTien.Value.Trim().Replace(",", "").Replace(".", ""); } else { Response.Write("<script>alert('Bạn chưa nhập số tiền!')</script>"); return; } ////////// if (sIdChiTieu == "") { string sqlInsertChiTieu = "insert into tb_ChiTieu(NgayChi,NoiDung,SoTien)"; sqlInsertChiTieu += " values('" + NgayChi + "',N'" + NoiDung + "','" + SoTien + "')"; bool ktInsertChiTieu = Connect.Exec(sqlInsertChiTieu); if (ktInsertChiTieu) { Response.Redirect("QuanLyChiTieu.aspx"); } else { Response.Write("<script>alert('Lỗi thêm chi tiêu!')</script>"); } } else { string sqlUpdateChiTieu = ""; sqlUpdateChiTieu += "update tb_ChiTieu set"; sqlUpdateChiTieu += " NgayChi = '" + NgayChi + "'"; sqlUpdateChiTieu += " ,NoiDung = N'" + NoiDung + "'"; sqlUpdateChiTieu += " ,SoTien = '" + SoTien + "'"; sqlUpdateChiTieu += " where idChiTieu ='" + sIdChiTieu + "'"; bool ktUpdateChiTieu = Connect.Exec(sqlUpdateChiTieu); if (ktUpdateChiTieu) { if (Page != "") { Response.Redirect("QuanLyChiTieu.aspx?Page=" + Page); } else { Response.Redirect("QuanLyChiTieu.aspx"); } } else { Response.Write("<script>alert('Lỗi !')</script>"); } } }
public static ChampionDto getChampionAllById(int champId) { var qry = new StaticData<ChampionDto>(DEFAULT_REGION, champId, null, null, "all"); var list = RequestBuilder.ExecuteAndReturn(qry); return list.First(); }
private void gvThucDonTuan_ThucDonTuan_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column.Name == "colTenThucDon_ThucDonTuan_ThucDonTuan") { string tenThucDon = e.Value.ToString(); if (tenThucDon != "") { gvThucDonTuan_ThucDonTuan.SetRowCellValue(e.RowHandle, colBuaSang_ThucDonTuan_ThucDonTuan, StaticData.getField("ThucDon", "buasang", "tenthucdon", e.Value.ToString())); gvThucDonTuan_ThucDonTuan.SetRowCellValue(e.RowHandle, colBuaTrua_ThucDonTuan_ThucDonTuan, StaticData.getField("ThucDon", "buatrua", "tenthucdon", e.Value.ToString())); gvThucDonTuan_ThucDonTuan.SetRowCellValue(e.RowHandle, gvThucDonTuan_ThucDonTuan.Columns["Bửa xế"], StaticData.getField("ThucDon", "buaxe", "tenthucdon", e.Value.ToString())); gvThucDonTuan_ThucDonTuan.SetRowCellValue(e.RowHandle, gvThucDonTuan_ThucDonTuan.Columns["Bửa phụ"], StaticData.getField("ThucDon", "buaphu", "tenthucdon", e.Value.ToString())); gvThucDonTuan_ThucDonTuan.SetRowCellValue(e.RowHandle, colMonTrangMieng_ThucDonTuan_ThucDonTuan, StaticData.getField("ThucDon", "MonTrangMieng", "tenthucdon", e.Value.ToString())); } } }
public static List<ChampionDto> getChampions() { var qry = new StaticData<ChampionDto>(DEFAULT_REGION); return RequestBuilder.ExecuteAndReturn(qry); }
private void LoadDuAn() { string sql = ""; sql += @"select * from( SELECT ROW_NUMBER() OVER(ORDER BY KhachHang.IDKhachHang desc)AS RowNumber,* from KhachHang where '1'='1' "; if (pMaPhieuNhap != "") { sql += " and KhachHang.TenKhachHang like N'%" + pMaPhieuNhap + "%'"; } //if (pMaPhieuNhap != "") // sql += " and PhieuNhap.MaPhieuNhap like N'%" + pMaPhieuNhap + "%'"; //if (pTuNgayNhap != "") // sql += " and ChiTietPhieuNhap.NgayNhapChiTiet >='" + StaticData.ConvertDDMMtoMMDD(pTuNgayNhap) + " 00:00:00'"; //if (pDenNgayNhap != "") // sql += " and ChiTietPhieuNhap.NgayNhapChiTiet <='" + StaticData.ConvertDDMMtoMMDD(pDenNgayNhap) + " 00:00:00'"; sql += " ) as tb1"; string chuoi = @" select isnull(sum(tb4.SoTienDaMua),0) as 'SoTienDaMua',isnull(sum(tb4.DaTra),0) as 'DaTra',isnull(sum(tb4.ConLai),0) as 'ConLai' from ( select tb3.IDKhachHang,tb3.SoTienDaMua,tb3.TienThanhToan+tb3.SoTien as 'DaTra' ,tb3.SoTienDaMua-(tb3.TienThanhToan+tb3.SoTien) as 'ConLai' from ( select tb2.IDKhachHang,(select isnull(sum(ChiTietPhieuXuat.SoLuong*ChiTietPhieuXuat.DonGiaXuat),0) from PhieuXuat,ChiTietPhieuXuat where PhieuXuat.MaPhieuXuat not like N'%-XB' and PhieuXuat.IDPhieuXuat = ChiTietPhieuXuat.IDPhieuXuat and PhieuXuat.IDKhachHang = tb2.IDKhachHang) as 'SoTienDaMua', (select isnull(sum(TienThanhToan),0) from PhieuXuat where PhieuXuat.MaPhieuXuat not like N'%-XB' and IDKhachHang=tb2.IDKhachHang) as 'TienThanhToan', (select isnull(sum(SoTien),0) from PhieuTraNo where IDKhachHang=tb2.IDKhachHang) as 'SoTien' from (" + sql + @") as tb2) as tb3 ) as tb4 "; DataTable showTien = Connect.GetTable(chuoi); sql += " WHERE RowNumber BETWEEN (" + Page + " - 1) * " + PageSize + " + 1 AND (((" + Page + " - 1) * " + PageSize + " + 1) + " + PageSize + ") - 1"; Label1.Text = @"select * from(select tb3.IDKhachHang,tb3.SoTienDaMua,tb3.TienThanhToan+tb3.SoTien as 'DaTra' ,tb3.SoTienDaMua-(tb3.TienThanhToan+tb3.SoTien) as 'ConLai' from ( select tb2.IDKhachHang,(select isnull(sum(ChiTietPhieuXuat.SoLuong*ChiTietPhieuXuat.DonGiaXuat),0) from PhieuXuat,ChiTietPhieuXuat where PhieuXuat.MaPhieuXuat not like N'%-XB' and PhieuXuat.IDPhieuXuat = ChiTietPhieuXuat.IDPhieuXuat and PhieuXuat.IDKhachHang = tb2.IDKhachHang) as 'SoTienDaMua', (select isnull(sum(TienThanhToan),0) from PhieuXuat where PhieuXuat.MaPhieuXuat not like N'%-XB' and IDKhachHang=tb2.IDKhachHang) as 'TienThanhToan', (select isnull(sum(SoTien),0) from PhieuTraNo where IDKhachHang=tb2.IDKhachHang) as 'SoTien' from (" + sql + @") as tb2) as tb3) as tb4 order by tb4.ConLai desc"; sql = Label1.Text; DataTable table = Connect.GetTable(sql); SetPage(); string html = @" <table class='table table-bordered table-striped'> <tr> <th class='th'> STT </th> <th class='th'> Mã khách hàng </th> <th class='th'> Tên khách hàng </th> <th class='th'> Số tiền đã mua </th> <th class='th'> Đã trả </th> <th class='th'> Còn lại </th> <th class='th'> </th> </tr>"; //double[] mang = new double[table.Rows.Count]; //for (int i = 0; i < table.Rows.Count; i++) //{ // double ConLai = MyStaticData.TongTienTrenPhieuXuatCuaKhach(table.Rows[i]["IDKhachHang"].ToString()) - MyStaticData.TongDaTraCuaKhach(table.Rows[i]["IDKhachHang"].ToString()); // mang[i] = ConLai; //} // for (int i = 0; i < mang.Length; i++) // { // for (int j = 0; j < mang.Length; j++) // { // if(mang[i] > mang[j]) // { // double temp = mang[i]; // mang[i] = mang[j]; // mang[j] = temp; // } // } // } // for (int i = 0; i < table.Rows.Count; i++) { double ConLai = MyStaticData.TongTienTrenPhieuXuatCuaKhach(table.Rows[i]["IDKhachHang"].ToString()) - MyStaticData.TongDaTraCuaKhach(table.Rows[i]["IDKhachHang"].ToString()); html += " <tr>"; html += " <td>" + (((Page - 1) * PageSize) + i + 1).ToString() + "</td>"; html += " <td>" + StaticData.getField("KhachHang", "MaKhachHang", "IDKhachHang", table.Rows[i]["IDKhachHang"].ToString()) + "</td>"; html += " <td><a href='PhieuTraNoKhachHang.aspx?TenKhachHang=" + StaticData.getField("KhachHang", "TenKhachHang", "IDKhachHang", table.Rows[i]["IDKhachHang"].ToString()) + "&'>" + StaticData.getField("KhachHang", "TenKhachHang", "IDKhachHang", table.Rows[i]["IDKhachHang"].ToString()) + "</a></td>"; if (table.Rows[i]["SoTienDaMua"].ToString().Trim() == "0") { html += " <td>0</td>"; } else { html += "<td>" + double.Parse(table.Rows[i]["SoTienDaMua"].ToString()).ToString("#,##").Replace(",", ".") + "</td>"; } if (table.Rows[i]["DaTra"].ToString().Trim() == "0") { html += " <td>0</td>"; } else { html += "<td>" + double.Parse(table.Rows[i]["DaTra"].ToString()).ToString("#,##").Replace(",", ".") + "</td>"; } if (table.Rows[i]["ConLai"].ToString().Trim() == "0") { html += " <td>0</td>"; } else { html += "<td>" + double.Parse(table.Rows[i]["ConLai"].ToString()).ToString("#,##").Replace(",", ".") + "</td>"; } //if (MyStaticData.GetNoKhachHang(table.Rows[i]["IDKhachHang"].ToString()) == 0) //{ // html += "<td>0</td>"; html += "<td>0</td>"; //} //else ////{ //if (MyStaticData.TongDaTraCuaKhach(table.Rows[i]["IDKhachHang"].ToString()) == 0) // html += "<td>0</td>"; //else html += "<td>" + MyStaticData.TongDaTraCuaKhach(table.Rows[i]["IDKhachHang"].ToString()).ToString("#,##").Replace(",", ".") + "</td>"; // double ConLai = MyStaticData.TongTienTrenPhieuXuatCuaKhach(table.Rows[i]["IDKhachHang"].ToString()) - MyStaticData.TongDaTraCuaKhach(table.Rows[i]["IDKhachHang"].ToString()); //if (ConLai == 0) //{ // html += "<td>0</td>"; //} //else html += "<td>" + ConLai.ToString("#,##").Replace(",", ".") + "</td>"; // } html += " <td style='text-align:center;font-size: 100%;'><a href='#' onclick='window.location=\"PhieuTraNoKhachHang-CapNhat.aspx?IDKhachHang=" + table.Rows[i]["IDKhachHang"].ToString() + "\"'>Thu nợ </a></td>"; // html += " <td style='text-align:center;font-size: 100%;'><a href='#' onclick='DeleteHangHoa(\"" + table.Rows[i]["IDHangHoa"].ToString() + "\")'><img title='Xóa' class='imgCommand' src='../Images/delete.png' onclick='DeleteHangHoa(\"" + table.Rows[i]["IDHangHoa"].ToString() + "\")' />Xóa</a></td>"; html += " </tr>"; } html += " <tr>"; html += " <td colspan='9' class='footertable'>"; string url = "NoKhachHang.aspx?"; if (pTenHangHoa != "") { url += "TenHangHoa=" + pTenHangHoa + "&"; } if (pMaPhieuNhap != "") { url += "MaPhieuNhap=" + pMaPhieuNhap + "&"; } if (pTuNgayNhap != "") { url += "TuNgayNhap=" + pTuNgayNhap + "&"; } if (pDenNgayNhap != "") { url += "DenNgayNhap=" + pDenNgayNhap + "&"; } url += "Page="; html += " <a class='notepaging' id='page_fist' href='" + url + txtFistPage + "' /><<</a>"; //Page 1 if (txtPage1 != "") { if (Page.ToString() == txtPage1) { html += " <a id='page_1' class='notepagingactive' href='" + url + txtPage1 + "' />" + txtPage1 + "</a>"; } else { html += " <a id='page_1' class='notepaging' href='" + url + txtPage1 + "' />" + txtPage1 + "</a>"; } } else { html += " <a id='page_1' class='notepagingnone' href='" + url + txtPage1 + "' />" + txtPage1 + "</a>"; } //Page 2 if (txtPage2 != "") { if (Page.ToString() == txtPage2) { html += " <a id='page_2' class='notepagingactive' href='" + url + txtPage2 + "' />" + txtPage2 + "</a>"; } else { html += " <a id='page_2' class='notepaging' href='" + url + txtPage2 + "' />" + txtPage2 + "</a>"; } } else { html += " <a id='page_2' class='notepagingnone' href='" + url + txtPage2 + "' />" + txtPage2 + "</a>"; } //Page 3 if (txtPage3 != "") { if (Page.ToString() == txtPage3) { html += " <a id='page_3' class='notepagingactive' href='" + url + txtPage3 + "' />" + txtPage3 + "</a>"; } else { html += " <a id='page_3' class='notepaging' href='" + url + txtPage3 + "' />" + txtPage3 + "</a>"; } } else { html += " <a id='page_3' class='notepagingnone' href='" + url + txtPage3 + "' />" + txtPage3 + "</a>"; } //Page 4 if (txtPage4 != "") { if (Page.ToString() == txtPage4) { html += " <a id='page_4' class='notepagingactive' href='" + url + txtPage4 + "' />" + txtPage4 + "</a>"; } else { html += " <a id='page_4' class='notepaging' href='" + url + txtPage4 + "' />" + txtPage4 + "</a>"; } } else { html += " <a id='page_4' class='notepagingnone' href='" + url + txtPage4 + "' />" + txtPage4 + "</a>"; } //Page 5 if (txtPage5 != "") { if (Page.ToString() == txtPage5) { html += " <a id='page_5' class='notepagingactive' href='" + url + txtPage5 + "' />" + txtPage5 + "</a>"; } else { html += " <a id='page_5' class='notepaging' href='" + url + txtPage5 + "' />" + txtPage5 + "</a>"; } } else { html += " <a id='page_5' class='notepagingnone' href='" + url + txtPage5 + "' />" + txtPage5 + "</a>"; } html += " <a id='page_last' class='notepaging' href='" + url + txtLastPage + "' />>></a>"; html += " </td>"; html += "</tr>"; html += "<tr style='background-color:yellow;font-weight: bold;'>"; html += "<td colspan='3' style='text-align:right;'><b>Tổng cộng</b></td>"; if (showTien.Rows[0]["SoTienDaMua"].ToString().Trim() == "0") { html += "<td>" + showTien.Rows[0]["SoTienDaMua"].ToString() + "</td>"; } else { html += "<td>" + double.Parse(showTien.Rows[0]["SoTienDaMua"].ToString()).ToString("#,##").Replace(",", ".") + "</td>"; } if (showTien.Rows[0]["DaTra"].ToString().Trim() == "0") { html += "<td>" + showTien.Rows[0]["DaTra"].ToString() + "</td>"; } else { html += "<td>" + double.Parse(showTien.Rows[0]["DaTra"].ToString()).ToString("#,##").Replace(",", ".") + "</td>"; } if (showTien.Rows[0]["ConLai"].ToString().Trim() == "0") { html += "<td>" + showTien.Rows[0]["ConLai"].ToString() + "</td>"; } else { html += "<td>" + double.Parse(showTien.Rows[0]["ConLai"].ToString()).ToString("#,##").Replace(",", ".") + "</td>"; } html += "<td> </td>"; html += "</tr>"; html += " </table>"; dvNguoiDung.InnerHtml = html; }
/// <summary> /// Marks the skill as completed /// </summary> internal void MarkAsCompleted() { m_known = true; m_level++; SkillPoints = StaticData.GetPointsRequiredForLevel(Math.Min(m_level, 5)); }
/// <summary> /// Calculates the cumulative points required to reach the given level of this skill, starting from the current SP. /// </summary> /// <remarks>For a result starting from 0 SP, use the equivalent method on <see cref="StaticSkill"/>.</remarks> /// <param name="level">The level.</param> /// <returns>The required nr. of points.</returns> public Int64 GetLeftPointsRequiredToLevel(Int64 level) { Int64 result = StaticData.GetPointsRequiredForLevel(level) - SkillPoints; return(result < 0 ? 0 : result); }
private static void LoadEntityStaticData(string folder, Entity entity) { XmlDocument document = null; var fileName = Path.Combine(folder, entity.Name + ".staticdata.xml"); if (!File.Exists(fileName)) return; try { document = new XmlDocument(); document.Load(fileName); } catch (Exception ex) { //Do Nothing MessageBox.Show("The file '" + fileName + "' is not valid and could not be loaded!", "Load Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } foreach (XmlNode n in document.DocumentElement) { var newData = new StaticData(entity.Partition); entity.StaticDatum.Add(newData); newData.OrderKey = XmlHelper.GetAttributeValue(n, "orderkey", newData.OrderKey); newData.Value = XmlHelper.GetAttributeValue(n, "value", newData.Value); newData.ColumnKey = XmlHelper.GetAttributeValue(n, "columnkey", newData.ColumnKey); } }
/* private void LoadQuyen() * { * string strSql = "select * from DuAn"; * slQuyen.DataSource = Connect.GetTable(strSql); * slQuyen.DataTextField = "TenQuyen"; * slQuyen.DataValueField = "MaQuyen"; * slQuyen.DataBind(); * //slQuyen.Items.Add(new ListItem("-- Tất cả --", "0")); * // slQuyen.Items.FindByText("-- Tất cả --").Selected = true; * }*/ #region paging private void SetPage() { string sql = ""; sql += "select count(*) from ChiTietPhieuXuat left join KhachHang on ChiTietPhieuXuat.IDKhachHang = KhachHang.IDKhachHang left join HangHoa on ChiTietPhieuXuat.IDHangHoa = HangHoa.IDHangHoa left join PhieuXuat on ChiTietPhieuXuat.IDPhieuXuat = PhieuXuat.IDPhieuXuat where '1'='1' and ChiTietPhieuXuat.TinhTrang = N'Còn nợ'"; if (pTenSanPham != "") { sql += " and HangHoa.TenHangHoa like N'%" + pTenSanPham + "%'"; } if (pTenKhachHang != "") { sql += " and KhachHang.TenKhachHang like N'%" + pTenKhachHang + "%'"; } if (pMaPhieuXuat != "") { sql += " and PhieuXuat.MaPhieuXuat like N'%" + pMaPhieuXuat + "%'"; } if (pTuNgayBan != "") { sql += " and ChiTietPhieuXuat.NgayXuatChiTiet >='" + StaticData.ConvertDDMMtoMMDD(pTuNgayBan) + " 00:00:00'"; } if (pDenNgayBan != "") { sql += " and ChiTietPhieuXuat.NgayXuatChiTiet <='" + StaticData.ConvertDDMMtoMMDD(pDenNgayBan) + " 00:00:00'"; } DataTable tbTotalRows = Connect.GetTable(sql); // Response.Write("<script>alert('"+tbTotalRows.Rows[0][0].ToString()+"')</script>"); int TotalRows = int.Parse(tbTotalRows.Rows[0][0].ToString()); if (TotalRows % PageSize == 0) { MaxPage = TotalRows / PageSize; } else { MaxPage = TotalRows / PageSize + 1; } txtLastPage = MaxPage.ToString(); if (Page == 1) { for (int i = 1; i <= MaxPage; i++) { if (i <= 5) { switch (i) { case 1: txtPage1 = i.ToString(); break; case 2: txtPage2 = i.ToString(); break; case 3: txtPage3 = i.ToString(); break; case 4: txtPage4 = i.ToString(); break; case 5: txtPage5 = i.ToString(); break; } } else { return; } } } else { if (Page == 2) { for (int i = 1; i <= MaxPage; i++) { if (i == 1) { txtPage1 = "1"; } if (i <= 5) { switch (i) { case 2: txtPage2 = i.ToString(); break; case 3: txtPage3 = i.ToString(); break; case 4: txtPage4 = i.ToString(); break; case 5: txtPage5 = i.ToString(); break; } } else { return; } } } else { int Cout = 1; if (Page <= MaxPage) { for (int i = Page; i <= MaxPage; i++) { if (i == Page) { txtPage1 = (Page - 2).ToString(); txtPage2 = (Page - 1).ToString(); } if (Cout <= 3) { if (i == Page) { txtPage3 = i.ToString(); } if (i == (Page + 1)) { txtPage4 = i.ToString(); } if (i == (Page + 2)) { txtPage5 = i.ToString(); } Cout++; } else { return; } } } else { //Page = MaxPage; SetPage(); } } } }
void Start() { staticData = GameObject.FindGameObjectWithTag ("Gamedata").GetComponent<StaticData>(); playerCount = 1; }
protected void Page_Load(object sender, EventArgs e) { /* if (Session["QuanLyNhapXuatHang_Login"] != null && Session["QuanLyNhapXuatHang_Login"].ToString() != "") * { * if (Session["QuanLyNhapXuatHang_Quyen"] != null && Session["QuanLyNhapXuatHang_Quyen"].ToString() != "") * { * string Quyen = Session["QuanLyNhapXuatHang_Quyen"].ToString().Trim(); * if (Quyen.CompareTo("Admin") == 0) * { * * } * else * { * Response.Redirect("../Home/Default.aspx"); * } * } * }*/ if (Request.Cookies["QuanLyNhapXuatHang_Login"] != null && Request.Cookies["QuanLyNhapXuatHang_Login"].Value.Trim() != "") { if (Request.Cookies["QuanLyNhapXuatHang_Quyen"] != null && Request.Cookies["QuanLyNhapXuatHang_Quyen"].Value.Trim() != "") { string Quyen = Request.Cookies["QuanLyNhapXuatHang_Quyen"].Value.Trim(); if (Quyen.CompareTo("Admin") == 0) { } else { Response.Redirect("../Home/Default.aspx"); } } } else { Response.Redirect("../Home/DangNhap.aspx"); } try { Page = int.Parse(Request.QueryString["Page"].ToString()); } catch { Page = 1; } if (!IsPostBack) { try { if (Request.QueryString["TenKhachHang"].Trim() != "") { pTenKhachHang = StaticData.ValidParameter(Request.QueryString["TenKhachHang"].Trim()); txtTenKhachHang.Value = pTenKhachHang; } } catch { } try { if (Request.QueryString["TenSanPham"].Trim() != "") { pTenSanPham = StaticData.ValidParameter(Request.QueryString["TenSanPham"].Trim()); txtTenSanPham.Value = pTenSanPham; } } catch { } try { if (Request.QueryString["MaPhieuXuat"].Trim() != "") { pMaPhieuXuat = StaticData.ValidParameter(Request.QueryString["MaPhieuXuat"].Trim()); txtMaPhieuXuat.Value = pMaPhieuXuat; } } catch { } try { if (Request.QueryString["TuNgayBan"].Trim() != "") { pTuNgayBan = StaticData.ValidParameter(Request.QueryString["TuNgayBan"].Trim()); txtTuNgayBan.Value = pTuNgayBan; } } catch { } try { if (Request.QueryString["DenNgayBan"].Trim() != "") { pDenNgayBan = StaticData.ValidParameter(Request.QueryString["DenNgayBan"].Trim()); txtDenNgayBan.Value = pDenNgayBan; } } catch { } LoadDuAn(); } }
public ChampionDataModel(int champId) { var qry = new StaticData<ChampionDto>(6, champId, null, null, "all"); var list = RequestBuilder.ExecuteAndReturn(qry); champ = list.First(); }
private void LoadDanhSach(string sql) { DataTable tbTong = Connect.GetTable(sql); int numb = tbTong.Rows.Count; int pageNumb = numb / pageSize + 1; string htmlPaging = "<ul class='pagination'>"; if (page > 1) { htmlPaging += "<li class='page-item'><a class='page-link' href='" + GetRouteUrl("timkiem", new { page = (page - 1) }) + "'><i class='fa fa-angle-double-left'></i></a></li>"; } else { htmlPaging += "<li class='page-item disabled'><a class='page-link' ><i class='fa fa-angle-double-left'></i></a></li>"; } for (int i = 0; i < pageNumb; i++) { if ((i + 1) == page) { htmlPaging += "<li class='page-item active'><a class='page-link ' href=" + GetRouteUrl("timkiem", new { page = (i + 1) }) + "> " + (i + 1).ToString() + "</a></li>"; } else { htmlPaging += "<li class='page-item'><a class='page-link' href=" + GetRouteUrl("timkiem", new { page = (i + 1) }) + "> " + (i + 1).ToString() + "</a></li>"; } } if ((page) < pageNumb) { htmlPaging += "<li class='page-item'><a class='page-link' href='" + GetRouteUrl("timkiem", new { page = (page + 1) }) + "'><i class='fa fa-angle-double-right'></i></a></li>"; } else { htmlPaging += "<li class='page-item disabled'><a class='page-link'><i class='fa fa-angle-double-right'></i></a></li>"; } htmlPaging += "</ul>"; idPaging.InnerHtml = htmlPaging; /////////////////////////////////////////////////////////////////////////////////////////////////////////////// sql += " WHERE RowNumber BETWEEN (" + page + " - 1) * " + pageSize + " + 1 AND (((" + page + " - 1) * " + pageSize + " + 1) + " + pageSize + ") - 1"; DataTable data = Connect.GetTable(sql); if (data == null) { dsTinDang.InnerHtml = ""; idPaging.Visible = false; msgMessage.InnerHtml = "Không tìm thấy sản phẩm !"; msgMessage.Visible = true; return; } string html = ""; if (data.Rows.Count > 0) { data = Connect.GetTable(sql); foreach (DataRow row in data.Rows) { string id = row["idRaoVat"].ToString(); string tieude = row["TieuDe"].ToString(); CultureInfo cul = CultureInfo.GetCultureInfo("vi-VN"); string gia = double.Parse(row["Gia"].ToString()).ToString("#,###", cul.NumberFormat); string ngayTao = StaticData.DateFormat(row["NgayTao"].ToString()); html += "<a class='card card-items item-ads' href='" + GetRouteUrl("chitiet", new { id = id }) + "'>"; html += " <div class='col-sm-3'>"; html += " <img class='card-img' src='" + getUrlImageByID(id) + "' alt='" + tieude + "' />"; html += " </div>"; html += " <div class='col-sm-9'>"; html += " <div class='card-body'>"; html += " <h5 class='card-title'>" + tieude + "</h5>"; html += " <p class='card-text'>Giá : <span class='price'>" + gia + " đ</span></p>"; html += " <p>Ngày : " + ngayTao + "</p>"; html += " </div>"; html += " </div><div style='clear:both;'></div>"; html += "</a>"; } } else { dsTinDang.InnerHtml = ""; idPaging.Visible = false; msgMessage.InnerHtml = "Không tìm thấy sản phẩm !"; msgMessage.Visible = true; return; } dsTinDang.InnerHtml = html; }