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;
}
