protected void btDelete_Click(object sender, EventArgs e) { string ArrayId = ""; for (int i = 0; i < rptList.Items.Count; i++) { CheckBox chkDelete = (CheckBox)rptList.Items[i].FindControl(("chk_item")); if (chkDelete != null) { if (chkDelete.Checked) { ArrayId += chkDelete.ToolTip; ArrayId += ","; } } else { return; } } if (ArrayId.Length > 0) { ArrayId = ArrayId.Substring(0, (ArrayId.Length - 1)); } else { return; } condition = " isid in(" + ArrayId + ") "; Subitems.DeleteSubitemsCondition(condition); chk_list.Checked = false; GetListComments(); }
protected void btOK_Click(object sender, EventArgs e) { Subitems.InsertSubitems(iid, lang, app, tbName.Text, tbNoiDung.Text, "", "", tbName.Text, isid, DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), "1"); tbName.Text = ""; tbNoiDung.Text = ""; GetListReply(); }
protected void btnTest_Click(object sender, EventArgs e) { if (btnHandler != null) { btnHandler(string.Empty); } if (suc.Equals(TypePage.UpdateItem)) { GetInfoUpdate(); Subitems.DeleteSubitemsCondition(DataExtension.AndConditon(SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVskey(keysubitem), SubitemsTSql.GetSubitemsByVslang(lang))); Subitems.InsertSubitems(iid, lang, keysubitem, "", "", "", "", "", "", DateTime.Now.ToString(), "", "", "1"); } else { GetIidNew(); Subitems.InsertSubitems(iid, lang, keysubitem, "", "", "", "", "", "", "", "", "", "1"); } Response.Redirect(LinkAdmin.GoAdminCategory(CodeApplications.Tour, TypePage.Item, igid)); }
protected void btOK_Click(object sender, EventArgs e) { #region Trạng thái string trangThai = "0"; if (cbTrangThai.Checked == true) { trangThai = "1"; } #endregion if (isid != "") { string image = flAnhDaiDien.Save(true, ""); Subitems.UpdateSubitems(iid, lang, app, tbTieuDe.Text, tbMoTa.Text, image, "", tbThuTu.Text, "", DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), trangThai, isid); //ScriptManager.RegisterStartupScript(this, this.GetType(), "", //"jAlert('Đã sửa: " + tbTieuDe.Text + "','Thông báo')", true); ltrThongBao.Text = "Thông báo: đã sửa " + tbTieuDe.Text; } else { string image = flAnhDaiDien.Save(false, ""); Subitems.InsertSubitems(iid, lang, app, tbTieuDe.Text, tbMoTa.Text, image, "", tbThuTu.Text, "", DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), trangThai); //ScriptManager.RegisterStartupScript(this, this.GetType(), "", //"jAlert('Đã tạo: " + tbTieuDe.Text + "','Thông báo')", true); ltrThongBao.Text = "Thông báo: đã tạo " + tbTieuDe.Text; } ResetControls(); }
string LayLichTrinh(string iid) { string s = ""; string condition = DataExtension.AndConditon( SubitemsTSql.GetSubitemsByVskey(TatThanhJsc.TourModul.CodeApplications.TourItinerary), SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVslang(lang), SubitemsColumns.IsenableColumn + "<>2"); string order = "[dbo].[RemoveTextIfNotIsFloat](" + SubitemsColumns.VsatuthorColumn + ")"; DataTable dt = Subitems.GetSubItems("", "*", condition, order); for (int i = 0; i < dt.Rows.Count; i++) { s += @" <div class='nb-card'> <div class='nb-head'> <a href='#' class='title nb-collapse-toggle'> <span>" + StringExtension.LayChuoi(dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", 1) + @"</span> - " + StringExtension.LayChuoi(dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", 2) + @" <span class='icon-toggle'></span> </a> </div> <div class='nb-body'> <div class='wap'> " + dt.Rows[i][SubitemsColumns.VscontentColumn].ToString() + @" </div> </div> </div>"; } return(s); }
void OpenUpdatePanel(string isid) { ltrInsertUpdate.Text = "Cập nhật hình ảnh"; update = true; currentIsid.Value = isid; pnList.Visible = false; pnInsert.Visible = true; condition = SubitemsTSql.GetSubitemsByIsid(isid); DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", "*", condition, ""); if (dt.Rows.Count > 0) { try { rblColors.SelectedValue = dt.Rows[0][SubitemsColumns.VsemailColumn].ToString(); } catch { } tbName.Text = dt.Rows[0][SubitemsColumns.VstitleColumn].ToString(); tbOrder.Text = dt.Rows[0][SubitemsColumns.VsatuthorColumn].ToString(); ddlStatus.SelectedValue = dt.Rows[0][SubitemsColumns.IsenableColumn].ToString(); ltimg.Text = ImagesExtension.GetImage(pathFolderPic, dt.Rows[0][SubitemsColumns.VsimageColumn].ToString(), "", "hotelImage", false, false, ""); hd_img = dt.Rows[0][SubitemsColumns.VsimageColumn].ToString(); } }
private void Add() { Subitems.Add(new HierarchicalElementViewModel(this) { Name = "Child Element" }); }
void OpenUpdatePanel(string isid) { ltrInsertUpdate.Text = "Cập nhật loại"; update = true; currentIsid.Value = isid; pnList.Visible = false; pnInsert.Visible = true; condition = SubitemsTSql.GetSubitemsByIsid(isid); DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", "*", condition, ""); if (dt.Rows.Count > 0) { tbName.Text = dt.Rows[0][SubitemsColumns.VstitleColumn].ToString(); tbOrder.Text = dt.Rows[0][SubitemsColumns.VsatuthorColumn].ToString(); ddlStatus.SelectedValue = dt.Rows[0][SubitemsColumns.IsenableColumn].ToString(); ltimg.Text = ImagesExtension.GetImage(pathFolderPic, dt.Rows[0][SubitemsColumns.VsimageColumn].ToString(), "", "hotelImage", false, false, ""); hd_img = dt.Rows[0][SubitemsColumns.VsimageColumn].ToString(); tbMoTa.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(), "", 1); tbParam2.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(), "", 2); tbParam3.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(), "", 3); tbParam1.Text = dt.Rows[0][SubitemsColumns.VsurlColumn].ToString(); tbPrice.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VsemailColumn].ToString(), "", 1); tbPriceOld.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VsemailColumn].ToString(), "", 2); tbCreateDate.Text = dt.Rows[0][SubitemsColumns.DscreatedateColumn].ToString(); tbEnddate.Text = dt.Rows[0][SubitemsColumns.DsenddateColumn].ToString(); } }
private void GetOtherImages(string iid) { string condition = DataExtension.AndConditon( SubitemsTSql.GetSubitemsByVskey(CodeApplications.HotelPhoto), SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVslang(lang), SubitemsColumns.IsenableColumn + "<>2" ); string order = "[dbo].[RemoveTextIfNotIsFloat](" + SubitemsColumns.VsatuthorColumn + ")"; DataTable dt = Subitems.GetSubItems("", "*", condition, order); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { ltrMainImages.Text += @" <div class='item'> <a href='javascript:void(0)' class='imgc'> " + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", true, false, "", false) + @" </a> </div>"; ltrOtherImages.Text += @" <div class='item'> <a href='javascript:void(0)' class='imgc'> " + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", true, false, "", false) + @" </a> </div>"; } } }
protected void RpListNoticeBQT_ItemCommand(object source, RepeaterCommandEventArgs e) { string c = e.CommandName.Trim(); string p = e.CommandArgument.ToString().Trim(); top = ""; fields = "*"; condition = DataExtension.AndConditon(SubitemsTSql.GetSubitemsByIsid(p)); order = ""; DataTable dt = new DataTable(); dt = Subitems.GetSubItems(top, fields, condition, order); switch (c) { case "edit": PnShow.Visible = false; PnFormNotice.Visible = true; TbTtl.Text = dt.Rows[0]["VSTITLE"].ToString(); TbContent.Text = dt.Rows[0]["VSCONTENT"].ToString(); HdInsertUpdate.Value = "update"; HdIsid.Value = p; GetListMes(); break; case "del": Subitems.DeleteSubitems(p); GetListMes(); break; } }
private string GetOtherImages2(string iid) { string s = ""; string s1 = ""; string condition = DataExtension.AndConditon ( SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVskey(CodeApplications.ProductImagesOther), SubitemsTSql.GetByEnable("1") ); string pic = TatThanhJsc.ProductModul.FolderPic.Product; string orderby = SubitemsColumns.VsatuthorColumn; DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", "*", condition, orderby); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { s1 += @" <div class='list-picture__item fade-up'> <div class='img'> <a href='" + UrlExtension.WebisteUrl + pic + "/" + dt.Rows[i][SubitemsColumns.VsimageColumn] + @"' data-fancybox='gallery' class='img__crop'> " + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", true, false, "", false) + @" </a> </div> </div>"; } } return(s1); }
protected override bool IsValidSubType(IHTMLItem item) { // may appear only once and only as first element if (item is TableCaption) { if (Subitems.Count > 0) { return(false); } IHTMLItem seekItem = Subitems.Find(x => x is TableCaption); if (seekItem != null) { return(false); } return(item.IsValid()); } if (item is ColElement) { return(item.IsValid()); } if (item is ColGroup) { return(item.IsValid()); } if (item is TableBody) { IHTMLItem seekItem = Subitems.Find(x => x is TableBody); if (seekItem != null) { return(false); } seekItem = Subitems.Find(x => x is TableRow); if (seekItem != null) { return(false); } return(item.IsValid()); } if (item is TableRow) { IHTMLItem seekItem = Subitems.Find(x => x is TableBody); if (seekItem != null) { return(false); } seekItem = Subitems.Find(x => x is TableHead); if (seekItem != null) { return(false); } seekItem = Subitems.Find(x => x is TableFooter); if (seekItem != null) { return(false); } return(item.IsValid()); } return(false); }
private void LayDanhSachLichTrinh() { string s = ""; string iid = ""; if (Request["iid"] != null) { iid = StringExtension.RemoveSqlInjectionChars(Request["iid"]); } string condition = DataExtension.AndConditon( SubitemsTSql.GetSubitemsByVskey(app), SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVslang(lang), SubitemsColumns.IsenableColumn + "<>2" ); string order = "[dbo].[RemoveTextIfNotIsFloat](" + SubitemsColumns.VsatuthorColumn + ")"; DataTable dt = Subitems.GetSubItems("", "*", condition, order); if (dt.Rows.Count > 0) { s += @" <table class='formatted'> <tr> <th class='stt'>TT</th> <th>Hoạt động</th> <th>Điểm đến</th> <th>Bữa ăn</th> <th class='thuTu'>Thứ tự</th> <th class='trangThai'>Trạng thái</th> <th class='congCu'>Công cụ</th> </tr>"; for (int i = 0; i < dt.Rows.Count; i++) { s += @" <tr id='row_" + dt.Rows[i][SubitemsColumns.IsidColumn] + @"'> <td class='tac'>" + (i + 1) + @"</td> <td>" + StringExtension.LayChuoi(dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", 1) + ": " + StringExtension.LayChuoi(dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", 2) + @"<br/> " + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), "", "itiImage", false, true, dt.Rows[i][SubitemsColumns.VscontentColumn].ToString()) + @" </td> <td>" + HienThiDiemDen(dt.Rows[i][SubitemsColumns.VsurlColumn].ToString()) + @"</td> <td>" + HienThiBuaAn(dt.Rows[i][SubitemsColumns.VsemailColumn].ToString()) + @"</td> <td class='tac'>" + dt.Rows[i][SubitemsColumns.VsatuthorColumn].ToString() + @"</td> <td class='tac'><span class='EnableIcon" + dt.Rows[i][SubitemsColumns.IsenableColumn] + @"'> </span></td> <td class='tac'> <a href='javascript:EditItinerary(" + dt.Rows[i][SubitemsColumns.IsidColumn] + @")' class='iconEdit'>Sửa</a> <a href='javascript:DeleteItinerary(" + dt.Rows[i][SubitemsColumns.IsidColumn] + @")' class='iconDelete'>Xóa</a> </td> </tr>"; } s += "</table>"; } Response.Write(s); }
private void LayDanhSachLoaiPhong() { string s = ""; string iid = ""; if (Request["iid"] != null) { iid = StringExtension.RemoveSqlInjectionChars(Request["iid"]); } string condition = DataExtension.AndConditon( SubitemsTSql.GetSubitemsByVskey(app), SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVslang(lang), SubitemsColumns.IsenableColumn + "<>2" ); string order = SubitemsColumns.isOrder; DataTable dt = Subitems.GetSubItems("", "*", condition, order); if (dt.Rows.Count > 0) { s += @" <table class='formatted'> <tr> <th class='stt'>TT</th> <th>Loại phòng</th> <th>Sức chứa</th> <th>Giá</th> <th class='thuTu'>Thứ tự</th> <th class='trangThai'>Trạng thái</th> <th class='congCu'>Công cụ</th> </tr>"; for (int i = 0; i < dt.Rows.Count; i++) { s += @" <tr id='row_" + dt.Rows[i][SubitemsColumns.IsidColumn] + @"'> <td class='tac'>" + (i + 1) + @"</td> <td>" + dt.Rows[i][SubitemsColumns.VstitleColumn] + @"<br/> " + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), "", "itiImage", false, true, dt.Rows[i][SubitemsColumns.VscontentColumn].ToString()) + @" </td> <td class='tac'>" + dt.Rows[i][SubitemsColumns.isTotalSubitem] + @"</td> <td class='tac'>" + PriceExtension.HienThiGia(dt.Rows[i][SubitemsColumns.fsPrice].ToString(), dt.Rows[i][SubitemsColumns.fsSalePrice].ToString()) + @"</td> <td class='tac'>" + dt.Rows[i][SubitemsColumns.isOrder] + @"</td> <td class='tac'><span class='EnableIcon" + dt.Rows[i][SubitemsColumns.IsenableColumn] + @"'> </span></td> <td class='tac'> <a href='javascript:EditRoomType(" + dt.Rows[i][SubitemsColumns.IsidColumn] + @")' class='iconEdit'>Sửa</a> <a href='javascript:DeleteRoomType(" + dt.Rows[i][SubitemsColumns.IsidColumn] + @")' class='iconDelete'>Xóa</a> </td> </tr>"; } s += "</table>"; } Response.Write(s); }
/// <summary> /// Xoá tên trường và xoá dữ liệu trong subitems theo mã ứng dụng, mã trường này /// </summary> /// <param name="igid">igid của trường</param> void DeleteDealFields(string igid) { string condition = GroupsTSql.GetGroupsByIgid(igid); DataTable dt = new DataTable(); dt = Groups.GetGroups("", GroupsColumns.VgdescColumn, condition, ""); Subitems.DeleteSubitemsCondition(DataExtension.AndConditon(SubitemsTSql.GetSubitemsByVslang(language), SubitemsTSql.GetSubitemsByVskey(app), SubitemsTSql.GetSubitemsByVsemail(dt.Rows[0][GroupsColumns.VgdescColumn].ToString()))); Groups.DeleteGroups(GroupsTSql.GetGroupsByIgid(igid)); }
private void DeleteSubItems(string iid, string pic) { DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", SubitemsColumns.IsidColumn, SubitemsTSql.GetSubitemsByIid(iid), ""); for (int i = 0; i < dt.Rows.Count; i++) { subItemControl.DeleteSubItem(dt.Rows[i][SubitemsColumns.IsidColumn].ToString(), pic); } }
protected void btOK_Click(object sender, EventArgs e) { #region Bao gồm - included string baoGom = ""; for (int i = 0; i < cblBaoGom.Items.Count; i++) { if (cblBaoGom.Items[i].Selected) { baoGom += cblBaoGom.Items[i].Value + ","; } } if (baoGom != "") { baoGom = baoGom.Remove(baoGom.Length - ",".Length); } #endregion string chiTiet = ContentExtendtions.ProcessStringContent(tbChiTiet.Text, hdChiTiet.Value, pic); #region Trạng thái string trangThai = "0"; if (cbTrangThai.Checked == true) { trangThai = "1"; } #endregion if (isid != "") { string image = flAnhDaiDien.Save(true, chiTiet); Subitems.UpdateSubitemsFull(iid, lang, app, tbLoaiPhong.Text, chiTiet, image, baoGom, "", tbHuongPhong.Text, DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), trangThai, isid, tbGiaNiemYet.Text, tbGiaKhuyenMai.Text, "", "", "", tbSuChuaToiDa.Text, tbThuTu.Text, ddlCoTheTraPhongKhong.SelectedValue, ddlCoGomBuaSangKhong.SelectedValue, tbDienTichPhong.Text, tbLoaiGiuong.Text, DateTime.Now.ToString(), DateTime.Now.ToString()); ltrThongBao.Text = "Thông báo: đã sửa " + tbLoaiPhong.Text; } else { string image = flAnhDaiDien.Save(false, chiTiet); Subitems.InsertSubitemsFull(iid, lang, app, tbLoaiPhong.Text, chiTiet, image, baoGom, "", tbHuongPhong.Text, DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), trangThai, tbGiaNiemYet.Text, tbGiaKhuyenMai.Text, "", "", "", tbSuChuaToiDa.Text, tbThuTu.Text, ddlCoTheTraPhongKhong.SelectedValue, ddlCoGomBuaSangKhong.SelectedValue, tbDienTichPhong.Text, tbLoaiGiuong.Text, DateTime.Now.ToString(), DateTime.Now.ToString()); ltrThongBao.Text = "Thông báo: đã tạo " + tbLoaiPhong.Text; } ResetControls(); }
/// <summary> /// Đếm số hình ảnh trong một album /// </summary> /// <param name="iid"></param> /// <returns></returns> public static string CountSubItems(string iid) { string condition = DataExtension.AndConditon( SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByIsenable("1"), SubitemsTSql.GetSubitemsByVskey(TatThanhJsc.PhotoAlbumModul.CodeApplications.PhotoAlbumImagesOther)); DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", SubitemsColumns.IsidColumn, condition, ""); return(NumberExtension.FormatNumber(dt.Rows.Count.ToString())); }
private void DeletePhoto() { string isid = ""; if (Request["isid"] != null) { isid = StringExtension.RemoveSqlInjectionChars(Request["isid"]); } Subitems.UpdateSubitems(SubitemsTSql.GetSubitemsByIsenable("2"), SubitemsTSql.GetSubitemsByIsid(isid)); }
protected void UpdateTitle(object sender, EventArgs e) { TextBox textbox = sender as TextBox; string[] fields = { SubitemsColumns.VstitleColumn }; string[] values = { "N'" + textbox.Text + "'" }; string condition = SubitemsTSql.GetSubitemsByIsid(textbox.ToolTip); Subitems.UpdateSubitems(DataExtension.UpdateTransfer(fields, values), condition); //GetListDeals(""); }
/// <summary> /// Đếm comment cho một blog /// </summary> /// <param name="iid"></param> /// <returns></returns> public static string CountComment(string iid) { string app = TatThanhJsc.BlogModul.CodeApplications.BlogComment; string condition = DataExtension.AndConditon( SubitemsTSql.GetByIid(iid), SubitemsTSql.GetByApp(app), SubitemsTSql.GetByEnable("1") ); DataTable dt = Subitems.GetSubItems("", SubitemsColumns.IsidColumn, condition, ""); return(NumberExtension.FormatNumber(dt.Rows.Count.ToString())); }
void DeleteComment(string isid) { #region Xoá trả lời của comment DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", "*", DataExtension.AndConditon(SubitemsTSql.GetSubitemsByVskey(app + "Reply"), SubitemsTSql.GetSubitemsByVsurl(isid)), ""); for (int i = 0; i < dt.Rows.Count; i++) { ImagesExtension.DeleteImageWhenDeleteItem(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString()); Subitems.DeleteSubitems(dt.Rows[i][SubitemsColumns.IsidColumn].ToString()); } #endregion Subitems.DeleteSubitems(isid); }
void GetList(string iid) { DataTable dt = new DataTable(); condition = DataExtension.AndConditon( SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVskey(app) ); orderBy = SubitemsColumns.VstitleColumn; dt = Subitems.GetSubItems("", "*", condition, orderBy); rptList.DataSource = dt; rptList.DataBind(); }
public override bool IsValid() { IEnumerable <IHTMLItem> captions = Subitems.FindAll(x => x is FigCaption); foreach (var figCaption in captions) // figcaption can be only first or last element { if (figCaption != Subitems.First() && figCaption != Subitems.Last()) { return(false); } } return(true); }
void GetInfoUpdate() { condition = DataExtension.AndConditon(SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVskey(keysubitem), SubitemsTSql.GetSubitemsByVslang(lang)); DataTable dt = new DataTable(); dt = Subitems.GetSubItems("1", " isid, VSTITLE ", condition, ""); if (dt.Rows.Count > 0) { isid = dt.Rows[0][SubitemsColumns.IsidColumn].ToString(); } }
void GetList() { condition = DataExtension.AndConditon ( SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVskey(app) ); orderby = SubitemsColumns.VsemailColumn + " asc," + SubitemsColumns.VsatuthorColumn + " asc"; DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", "*", condition, orderby); rptList.DataSource = dt; rptList.DataBind(); }
void GetListComments() { condition = DataExtension.AndConditon ( SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVskey(app) ); orderby = SubitemsColumns.DscreatedateColumn + " desc "; DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", "*", condition, orderby); rptList.DataSource = dt; rptList.DataBind(); }
private void InitialControlsValue() { //Trường hợp sửa loại phòng if (isid != "") { string condition = DataExtension.AndConditon(SubitemsTSql.GetSubitemsByVskey(app), SubitemsTSql.GetSubitemsByIsid(isid)); DataTable dt = Subitems.GetSubItems("1", "*", condition, ""); if (dt.Rows.Count > 0) { tbLoaiPhong.Text = dt.Rows[0][SubitemsColumns.VstitleColumn].ToString(); tbSuChuaToiDa.Text = dt.Rows[0][SubitemsColumns.isTotalSubitem].ToString(); tbGiaNiemYet.Text = dt.Rows[0][SubitemsColumns.fsPrice].ToString(); tbGiaKhuyenMai.Text = dt.Rows[0][SubitemsColumns.fsSalePrice].ToString(); #region Bao gồm string baoGom = "," + dt.Rows[0][SubitemsColumns.VsemailColumn] + ","; for (int i = 0; i < cblBaoGom.Items.Count; i++) { if (baoGom.IndexOf("," + cblBaoGom.Items[i].Value + ",") > -1) { cblBaoGom.Items[i].Selected = true; } else { cblBaoGom.Items[i].Selected = false; } } #endregion tbChiTiet.Text = dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(); hdChiTiet.Value = dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(); flAnhDaiDien.Load(dt.Rows[0][SubitemsColumns.VsimageColumn].ToString()); ddlCoTheTraPhongKhong.SelectedValue = dt.Rows[0][SubitemsColumns.isParam1].ToString(); ddlCoGomBuaSangKhong.SelectedValue = dt.Rows[0][SubitemsColumns.isParam2].ToString(); tbDienTichPhong.Text = dt.Rows[0][SubitemsColumns.vsParam1].ToString(); tbLoaiGiuong.Text = dt.Rows[0][SubitemsColumns.vsParam2].ToString(); tbHuongPhong.Text = dt.Rows[0][SubitemsColumns.VsurlColumn].ToString(); tbThuTu.Text = dt.Rows[0][SubitemsColumns.isOrder].ToString(); cbTrangThai.Checked = (dt.Rows[0][SubitemsColumns.IsenableColumn].ToString() == "1"); } } }
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { string name = e.CommandName; string id = e.CommandArgument.ToString(); switch (name) { case "delete": Subitems.DeleteSubitems(id); GetListReply(); break; default: break; } }
protected void btnadd_Click(object sender, EventArgs e) { int[] iidArry = new int[lstnotadded.Rows + 1]; iidArry = lstnotadded.GetSelectedIndices(); if (iidArry.Length > 0) { for (int i = 0; i < iidArry.Length; i++) { Subitems.InsertSubitems(igid, language, "PIP", lstnotadded.Items[iidArry[i]].Value, "", "", "", "", "", DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), "1"); } lstnotadded.Items.Clear(); lstadded.Items.Clear(); GetProductGroups(ddl_groups.SelectedValue); } }