void UpdateOrder() { string[] fieldsDelGroup = { "IGORDER" }; string[] valuesDelGroup = { igorder }; condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByIgid(igid)); Groups.UpdateGroupsCondition(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); }
private void EditValue(string iLanguageKeyId) { //Nếu key language chưa có giá trị if (SetCountItem(iLanguageKeyId).Equals("0")) { for (int i = 0; i <= RpListLanguageNationals.Items.Count - 1; i++) { TextBox tbTitle = (TextBox)RpListLanguageNationals.Items[i].FindControl(("TbLanguageWord")); string value = tbTitle.Text.Replace("'", "''"); if (tbTitle.ToolTip.Equals(iLanguageKeyId)) { LanguageItem.InsertLanguageItem(language, iLanguageKeyId, value, "", ""); } } } else //Nếu key language có giá trị rồi { for (int i = 0; i <= RpListLanguageNationals.Items.Count - 1; i++) { TextBox tbTitle = (TextBox)RpListLanguageNationals.Items[i].FindControl(("TbLanguageWord")); string value = tbTitle.Text.Replace("'", "''"); if (tbTitle.ToolTip.Equals(iLanguageKeyId)) { string[] fields = { "nLanguageItemTitle" }; string[] values = { "N'" + value + "'" }; string condition = DataExtension.AndConditon(LanguageItemTSql.GetByiLanguageKeyId(iLanguageKeyId), LanguageItemTSql.GetByiLanguageNationalId(language)); LanguageItem.UpdateLanguageItem(DataExtension.UpdateTransfer(fields, values), condition); } } } }
//Loại bỏ thuộc tính ra khỏi danh mục protected void btRemove_Click(object sender, EventArgs e) { string listFilterProperties = GetListFilterProperties(); int[] iidArry = lstbAdded.GetSelectedIndices(); if (iidArry.Length > 0) { for (int i = 0; i < iidArry.Length; i++) { listFilterProperties = listFilterProperties.Replace(parramSplitString + lstbAdded.Items[iidArry[i]].Value + parramSplitString, parramSplitString); } //Cap nhat lai danh sach thuoc tinh string[] fieldsEditStatus = { TatThanhJsc.Columns.GroupsColumns.VgparamsColumn }; string[] valuesEditStatus = { "'" + listFilterProperties + "'" }; if (cbApplyToSubCategory.Checked == true) { TatThanhJsc.Database.Groups.UpdateGroupsCondition(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), "charindex(','+cast(" + igid + " as varchar(10))+','," + TatThanhJsc.Columns.GroupsColumns.IgparentsidColumn + ") >0"); } else { TatThanhJsc.Database.Groups.UpdateGroupsCondition(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), TatThanhJsc.TSql.GroupsTSql.GetGroupsByIgid(igid)); } //Lấy lại danh sách các thuộc tính GetListAdded(); GetListNotAdded(); } }
protected void RpListMembers_ItemCommand(object source, RepeaterCommandEventArgs e) { string c = e.CommandName.Trim(); string p = e.CommandArgument.ToString().Trim(); top = ""; fields = "*"; condition = MembersTSql.GetMembersByImid(p); order = ""; DataTable dt = new DataTable(); dt = Members.GetMembersCondition(top, fields, condition, order); switch (c) { #region Delete case "delete": Members.DeleteMembersByIMID(p); GetListMembers(); #region Logs string logAuthor = CookieExtension.GetCookies("LoginSetting"); string logCreateDate = DateTime.Now.ToString(); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", dt.Rows[0][MembersColumns.vMemberAccount].ToString(), logAuthor, "", logCreateDate + ": " + logAuthor + " xóa thành viên " + dt.Rows[0][MembersColumns.vMemberAccount].ToString()); #endregion break; #endregion #region Edit Status case "lock": string[] fieldsEditStatus = { "iMemberIsLockedOut" }; string[] valuesEditStatus = { "" }; if (dt.Rows[0]["iMemberIsLockedOut"].ToString().Equals("0")) { valuesEditStatus[0] = "1"; Members.UpdateMembersCondition(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition); } else { valuesEditStatus[0] = "0"; Members.UpdateMembersCondition(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition); } GetListMembers(); #region Logs logAuthor = CookieExtension.GetCookies("LoginSetting"); logCreateDate = DateTime.Now.ToString(); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", dt.Rows[0][MembersColumns.vMemberAccount].ToString(), logAuthor, "", logCreateDate + ": " + logAuthor + " cập nhật trạng thái thành viên " + dt.Rows[0][MembersColumns.vMemberAccount].ToString()); #endregion break; #endregion #region edit case "edit": Response.Redirect(LinkAdmin.GoAdminItem(CodeApplications.Member, TypePage.UpdateItem, p)); break; #endregion } }
protected void LbDelFlagCurrent_Click(object sender, EventArgs e) { string[] fields = { "nLanguageNationalFlag" }; string[] values = { "''" }; string condition = LanguageNationalTSql.GetByiLanguageNationalId(iLanguageNationalId); LanguageNational.UpdateLanguageNational(DataExtension.UpdateTransfer(fields, values), condition); ImagesExtension.DeleteImageWhenDeleteItem(pic, HdFlagNational.Value); }
protected void TextChanged(object sender, EventArgs e) { TextBox textbox = sender as TextBox; string[] fields = { "IORDER" }; string[] values = { textbox.Text }; string condition = " IGIID = '" + textbox.ToolTip + "' "; GroupsItems.UpdateGroupsItemsCondition(DataExtension.UpdateTransfer(fields, values), condition); GetQA(""); }
protected void rp_mn_users_ItemCommand(object source, RepeaterCommandEventArgs e) { string c = e.CommandName.Trim(); string p = e.CommandArgument.ToString().Trim(); fields = "*"; condition = ItemsTSql.GetItemsCondition(p, app); DataTable dt = new DataTable(); dt = GroupsItems.GetAllData(top, fields, condition, orderBy); switch (c) { #region Delete case "delete": TatThanhJsc.Database.Items.DeleteItems(ItemsTSql.GetItemsByIid(p)); break; #endregion #region Edit Enable case "EditEnable": string[] fieldsEnable = { "IIENABLE" }; string[] valuesEnable = { "" }; if (dt.Rows[0]["IIENABLE"].ToString().Equals("0")) { valuesEnable[0] = "1"; TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } else { valuesEnable[0] = "0"; TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } GetVotes(); break; #endregion #region Edit case "edit": pnList.Visible = false; pnShorcut.Visible = true; hdInsertUpdate.Value = "update"; HdId.Value = dt.Rows[0]["IID"].ToString(); TbRep.Text = dt.Rows[0]["VITITLE"].ToString(); if (dt.Rows[0]["IIENABLE"].ToString().Equals("1")) { cbEnable.Checked = true; } else { cbEnable.Checked = false; } break; #endregion } }
protected void TextChanged(object sender, EventArgs e) { TextBox textbox = sender as TextBox; string[] fields = { "nLanguageNationalDesc" }; string[] values = { textbox.Text }; string condition = LanguageNationalTSql.GetByiLanguageNationalId(textbox.ToolTip); LanguageNational.UpdateLanguageNational(DataExtension.UpdateTransfer(fields, values), condition); GetListLanguageNationals(); }
protected void UpdateTitle(object sender, EventArgs e) { TextBox textbox = sender as TextBox; string[] fields = { ItemsColumns.VititleColumn }; string[] values = { "N'" + textbox.Text + "'" }; string condition = ItemsTSql.GetItemsByIid(textbox.ToolTip); TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fields, values), condition); //GetListWebsites(""); }
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(""); }
void RestoreItem() { string[] fieldsDelGroup = { "IIENABLE" }; string[] valuesDelGroup = { "1" }; condition = " IID = '" + iid + "' "; TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); #region Logs string logAuthor = CookieExtension.GetCookies("LoginSetting"); string logCreateDate = DateTime.Now.ToString(); string title = GetTitle(iid); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", title, logAuthor, "", logCreateDate + ": " + logAuthor + " khôi phục " + title + " (id: " + iid + ")"); #endregion }
void RestoreCate() { string[] fieldsDelGroup = { "IGENABLE", GroupsColumns.DgupdateColumn }; string[] valuesDelGroup = { "1", "'" + DateTime.Now.ToString() + "'" }; condition = " CHARINDEX('," + igid + ",',IGPARENTSID) > 0 "; Groups.UpdateGroupsCondition(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); #region Logs string logAuthor = CookieExtension.GetCookies("LoginSetting"); string logCreateDate = DateTime.Now.ToString(); string title = GetTitle(igid); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", title, logAuthor, "", logCreateDate + ": " + logAuthor + " khôi phục " + title + " (id: " + igid + ")"); #endregion }
protected void rp_mn_users_ItemCommand(object source, RepeaterCommandEventArgs e) { string c = e.CommandName.Trim(); string p = e.CommandArgument.ToString().Trim(); fields = "*"; condition = ItemsTSql.GetItemsCondition(p, app); switch (c) { #region Delete case "delete": string[] fieldsDelItem = { "IIENABLE", ItemsColumns.DiupdateColumn }; string[] valuesDelItem = { "2", "'" + DateTime.Now.ToString() + "'" }; Items.UpdateItems(DataExtension.UpdateTransfer(fieldsDelItem, valuesDelItem), condition); GetService(""); break; #endregion #region Edit Enable case "EditEnable": DataTable dt = new DataTable(); dt = GroupsItems.GetAllData(top, fields, condition, orderBy); string[] fieldsEnable = { "IIENABLE" }; string[] valuesEnable = { "" }; if (dt.Rows[0]["IIENABLE"].ToString().Equals("0")) { valuesEnable[0] = "1"; Items.UpdateItems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } else { valuesEnable[0] = "0"; Items.UpdateItems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } GetService(""); break; #endregion #region Edit case "edit": Response.Redirect(LinkUpdate(p)); break; #endregion } }
protected void btOKChangeInfo_Click(object sender, EventArgs e) { string userId = CookieExtension.GetCookies("UserId"); string condition = UsersTSql.GetUsersByUserid(userId); string[] fields = { UsersColumns.UserfirstnameColumn, UsersColumns.UserlastnameColumn, UsersColumns.UseraddressColumn, UsersColumns.UserphonenumberColumn, UsersColumns.UseridentitycardColumn }; string[] value = { "N'" + tbHo.Text + "'", "N'" + tbTen.Text + "'", "N'" + tbDiaChi.Text + "'", "N'" + tbDienThoai.Text + "'", "N'" + tbSoCMND.Text + "'" }; Users.UpdateUsers(DataExtension.UpdateTransfer(fields, value), condition); ScriptManager.RegisterStartupScript(this, this.GetType(), "", "ThongBao(3000,'Cập nhật thông tin thành công');", true); pnChangeInfo.Visible = false; pnInfo.Visible = true; GetInfoUser(); }
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { string c = e.CommandName.Trim(); string p = e.CommandArgument.ToString().Trim(); fields = "*"; condition = SubitemsTSql.GetSubitemsByIsid(p); DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", "*", condition, ""); switch (c) { #region Delete case "delete": ImagesExtension.DeleteImageWhenDeleteItem(pathFolderPic, dt.Rows[0][SubitemsColumns.VsimageColumn].ToString()); Subitems.DeleteSubitems(p); GetList(); break; #endregion #region Edit Enable case "EditEnable": string[] fieldsEnable = { SubitemsColumns.IsenableColumn }; string[] valuesEnable = { "" }; if (dt.Rows[0][SubitemsColumns.IsenableColumn].ToString().Equals("0")) { valuesEnable[0] = "1"; Subitems.UpdateSubitems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } else { valuesEnable[0] = "0"; Subitems.UpdateSubitems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } GetList(); break; #endregion #region Edit case "edit": //OpenUpdatePanel(p); Response.Redirect(UrlExtension.WebisteUrl + "cms/admin/Moduls/Deal/Item/PopUp/AddVideoToItems.aspx?iid=" + iid + "&isid=" + p); break; #endregion } }
void UpdateEnable() { string valueUpdate = ""; if (isenable.Equals("0")) { valueUpdate = "1"; } else { valueUpdate = "0"; } string[] fieldsDelGroup = { "ISENABLE" }; string[] valuesDelGroup = { valueUpdate }; condition = " ISID = '" + isid + "' "; Subitems.UpdateSubitems(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); }
protected void rp_mn_users_ItemCommand(object source, RepeaterCommandEventArgs e) { string c = e.CommandName.Trim(); string p = e.CommandArgument.ToString().Trim(); fields = "*"; DataTable dt = new DataTable(); dt = Members.GetMembersCondition("", MembersColumns.ImemberisapprovedColumn, MembersTSql.GetMembersByImid(p), ""); switch (c) { #region Delete case "delete": Members.DeleteMembersByIMID(p); GetCategories(""); break; #endregion #region Edit Status case "EditStatus": string[] fieldsEditStatus = { "iMemberIsLockedOut" }; string[] valuesEditStatus = { "" }; if (dt.Rows[0]["iMemberIsLockedOut"].ToString().Equals("0")) { valuesEditStatus[0] = "1"; Members.UpdateMembersCondition(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition); } else { valuesEditStatus[0] = "0"; Members.UpdateMembersCondition(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition); } GetCategories(""); break; #endregion #region edit case "editPassword": Response.Redirect(LinkAdmin.GoAdminItem(CodeApplications.Member, TypePage.UpdateItem, p)); break; #endregion } }
void DeleteListItem() { string[] arrigid = listigid.Split(Convert.ToChar(",")); for (int i = 0; i < arrigid.Length - 1; i++) { string[] fieldsDelGroup = { "IIENABLE" }; string[] valuesDelGroup = { "2" }; condition = " IID = '" + arrigid[i] + "' "; TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); #region Logs string logAuthor = CookieExtension.GetCookies("LoginSetting"); string logCreateDate = DateTime.Now.ToString(); string title = GetTitle(arrigid[i]); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", title, logAuthor, "", logCreateDate + ": " + logAuthor + " xóa " + title + " (id: " + arrigid[i] + ")"); #endregion } }
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { string c = e.CommandName.Trim(); string p = e.CommandArgument.ToString().Trim(); fields = "*"; condition = GroupsTSql.GetGroupsByIgid(p); DataTable dt = new DataTable(); dt = Groups.GetGroups("", fields, condition, ""); switch (c) { #region Delete case "delete": DeleteDealFields(p); GetList(); break; #endregion #region Edit Enable case "EditEnable": string[] fieldsEnable = { GroupsColumns.IgenableColumn }; string[] valuesEnable = { "" }; if (dt.Rows[0][GroupsColumns.IgenableColumn].ToString().Equals("0")) { valuesEnable[0] = "1"; Groups.UpdateGroupsCondition(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } else { valuesEnable[0] = "0"; Groups.UpdateGroupsCondition(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } GetList(); break; #endregion #region Edit case "edit": OpenUpdatePanel(p); break; #endregion } }
protected void TextChanged(object sender, EventArgs e) { TextBox textbox = sender as TextBox; if (SetCountItem(textbox.ToolTip).Equals("0")) //Nếu key language chưa có giá trị, insert mới { string value = textbox.Text.Replace("'", "''"); LanguageItem.InsertLanguageItem(language, textbox.ToolTip, value, "", ""); } else//Nếu key language có giá trị rồi, update { string value = textbox.Text.Replace("'", "''"); string[] fields = { "nLanguageItemTitle" }; string[] values = { "N'" + value + "'" }; string condition = DataExtension.AndConditon(LanguageItemTSql.GetByiLanguageKeyId(textbox.ToolTip), LanguageItemTSql.GetByiLanguageNationalId(language)); LanguageItem.UpdateLanguageItem(DataExtension.UpdateTransfer(fields, values), condition); } }
protected void btOK_Click(object sender, EventArgs e) { #region Image string vimg = ""; if (flimg.FileName.Length > 0 && flimg.PostedFile.ContentLength > 0) { string filename = ""; filename = System.IO.Path.GetFileName(flimg.PostedFile.FileName); string fileex = ""; fileex = System.IO.Path.GetExtension(filename).ToLower(); if (fileex == ".jpg" || fileex == ".jpeg" || fileex == ".gif" || fileex == ".png" || fileex == ".bmp" || fileex == ".JPG" || fileex == ".JPEG" || fileex == ".GIF" || fileex == ".PNG" || fileex == ".BMP") { string fileNotEx = System.IO.Path.GetFileNameWithoutExtension(flimg.PostedFile.FileName); vimg = StringExtension.ReplateTitle(fileNotEx) + DateTime.Now.Ticks.ToString() + fileex; flimg.SaveAs(Request.PhysicalApplicationPath + "/" + folderpic + "/" + vimg); } } #endregion if (hdUpdate.Value == "1")//Cập nhật { if (vimg.Length > 0) { string[] fields = { TatThanhJsc.Columns.LanguageItemColumns.nLanguageItemParams }; string[] values = { "N'" + vimg + "'" }; string condition = DataExtension.AndConditon(LanguageItemTSql.GetByiLanguageKeyId(iLanguageKeyId), LanguageItemTSql.GetByiLanguageNationalId(language)); LanguageItem.UpdateLanguageItem(DataExtension.UpdateTransfer(fields, values), condition); //Xoá ảnh cũ ImagesExtension.DeleteImageWhenDeleteItem(folderpic, hdOldImage.Value); } else { vimg = hdOldImage.Value; } } else//Thêm mới { LanguageItem.InsertLanguageItem(language, iLanguageKeyId, "", "", vimg); } ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('Cập nhật thành công');ChangeImage('img" + iLanguageKeyId + "','" + UrlExtension.WebisteUrl + folderpic + "/" + vimg + "');window.close();", true); }
void DeleteCate() { string[] arrigid = listigid.Split(Convert.ToChar(",")); for (int i = 0; i < arrigid.Length - 1; i++) { string[] fieldsDelGroup = { "IGENABLE", GroupsColumns.DgupdateColumn }; string[] valuesDelGroup = { "2", "'" + DateTime.Now.ToString() + "'" }; condition = " CHARINDEX('," + arrigid[i] + ",',IGPARENTSID) > 0 "; Groups.UpdateGroupsCondition(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); #region Logs string logAuthor = CookieExtension.GetCookies("LoginSetting"); string logCreateDate = DateTime.Now.ToString(); string title = GetTitle(arrigid[i]); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", title, logAuthor, "", logCreateDate + ": " + logAuthor + " xóa " + title + " (id: " + arrigid[i] + ")"); #endregion } }
protected void lnk_delete_user_checked_Click(object sender, EventArgs e) { for (int i = 0; i <= rp_mn_users.Items.Count - 1; i++) { CheckBox chkDelete = (CheckBox)rp_mn_users.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 = " IID in(" + ArrayId + ") "; //Đoàn sửa char[] splitItem = { ',' }; foreach (string itemID in ArrayId.Split(splitItem, StringSplitOptions.RemoveEmptyEntries)) { string[] fieldsDelItem = { "IIENABLE", ItemsColumns.DiupdateColumn }; string[] valuesDelItem = { "2", "'" + DateTime.Now.ToString() + "'" }; Items.UpdateItems(DataExtension.UpdateTransfer(fieldsDelItem, valuesDelItem), ItemsTSql.GetItemsByIid(itemID)); } GetService(""); }
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { string c = e.CommandName.Trim(); string p = e.CommandArgument.ToString().Trim(); fields = "*"; condition = SubitemsTSql.GetSubitemsByIsid(p); switch (c) { #region Delete case "delete": DeleteComment(p); GetListComments(); break; #endregion #region Edit Enable case "EditEnable": DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", SubitemsColumns.IsenableColumn, condition, ""); string[] fieldsEnable = { SubitemsColumns.IsenableColumn }; string[] valuesEnable = { "" }; if (dt.Rows[0][SubitemsColumns.IsenableColumn].ToString().Equals("0")) { valuesEnable[0] = "1"; Subitems.UpdateSubitems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } else { valuesEnable[0] = "0"; Subitems.UpdateSubitems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition); } GetListComments(); break; #endregion } }
void Session_Start(object sender, EventArgs e) { //Code that runs when a new session is started DataTable dt = new DataTable(); dt = Settings.GetSettingsCondition("", "*", DataExtension.AndConditon( SettingsTSql.GetSettingsByVskey(SettingsExtension.KeyTotalView), SettingsTSql.GetSettingsByVslang(TatThanhJsc.LanguageModul.Cookie.GetLanguageValueAdmin())), ""); if (dt.Rows.Count > 0) { string[] fields = { "VSVALUE" }; string[] values = { "VSVALUE + 1" }; string condition = DataExtension.AndConditon( SettingsTSql.GetSettingsByVskey(SettingsExtension.KeyTotalView), SettingsTSql.GetSettingsByVslang(TatThanhJsc.LanguageModul.Cookie.GetLanguageValueAdmin())); Settings.UpdateSettings(DataExtension.UpdateTransfer(fields, values), condition); } else { Settings.InsertSettings(SettingsExtension.KeyTotalView, "", "0", TatThanhJsc.LanguageModul.Cookie.GetLanguageValueAdmin()); } }
void UpdateEnable() { string valueUpdate = ""; if (igenable.Equals("0")) { valueUpdate = "1"; } else { valueUpdate = "0"; } string[] fieldsDelGroup = { "IGENABLE", GroupsColumns.DgupdateColumn }; string[] valuesDelGroup = { valueUpdate, "'" + DateTime.Now.ToString() + "'" }; condition = " CHARINDEX('," + igid + ",',IGPARENTSID) > 0 "; Groups.UpdateGroupsCondition(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); #region Logs string logAuthor = CookieExtension.GetCookies("LoginSetting"); string logCreateDate = DateTime.Now.ToString(); string title = GetTitle(igid); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", title, logAuthor, "", logCreateDate + ": " + logAuthor + " thay đổi trạng thái " + title + " (id: " + igid + ")"); #endregion }
void UpdateEnable() { string valueUpdate = ""; if (iienable.Equals("0")) { valueUpdate = "1"; } else { valueUpdate = "0"; } string[] fieldsDelGroup = { "IIENABLE" }; string[] valuesDelGroup = { valueUpdate }; condition = " IID = '" + iid + "' "; TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); #region Logs string logAuthor = CookieExtension.GetCookies("LoginSetting"); string logCreateDate = DateTime.Now.ToString(); string title = GetTitle(iid); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", title, logAuthor, "", logCreateDate + ": " + logAuthor + " thay đổi trạng thái " + title + " (id: " + iid + ")"); #endregion }
void UpdateEnable() { string valueUpdate = ""; if (igenable.Equals("0")) { valueUpdate = "1"; } else { valueUpdate = "0"; } string[] fieldsDelGroup = { "vgparams", GroupsColumns.DgupdateColumn }; string[] valuesDelGroup = { "'*!<=*ParamsSpilitItems*=>*!" + valueUpdate + "' + SUBSTRING(vgparams,len('*!<=*ParamsSpilitItems*=>*!0')+1,LEN(vgparams)-len('*!<=*ParamsSpilitItems*=>*!0'))", "'" + DateTime.Now.ToString() + "'" }; condition = " CHARINDEX('," + igid + ",',IGPARENTSID) > 0 "; Groups.UpdateGroupsCondition(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); #region Logs string logAuthor = CookieExtension.GetCookies("LoginSetting"); string logCreateDate = DateTime.Now.ToString(); string title = GetTitle(igid); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", title, logAuthor, "", logCreateDate + ": " + logAuthor + " thay đổi loại menu " + title + " (id: " + igid + ")"); #endregion }
private void UpdateTotalView(string iid) { string[] fields = { "IITOTALVIEW" }; string[] values = { "IITOTALVIEW + 1" }; Items.UpdateItems(DataExtension.UpdateTransfer(fields, values), ItemsTSql.GetItemsByIid(iid)); }
void HuyBai() { #region Lấy tiêu đề bài viết string postTitle = ""; string condition2 = ItemsTSql.GetById(iid); string fields = DataExtension.GetListColumns(ItemsColumns.VititleColumn, ItemsColumns.VISEOMETAPARAMSColumn); string orderby = GroupsColumns.IgorderColumn; DataTable dt = new DataTable(); dt = GroupsItems.GetAllData("1", fields, condition2, orderby); if (dt.Rows.Count > 0) { postTitle = dt.Rows[0][ItemsColumns.VititleColumn].ToString(); } #endregion #region Lấy info người đăng bài string tenNguoiDangBai = ""; string emailNguoiDangBai = ""; DataTable dtUserDangBai = Users.GetUsersByUserId(userid); if (dtUserDangBai.Rows.Count > 0) { tenNguoiDangBai = dtUserDangBai.Rows[0][UsersColumns.UserfirstnameColumn].ToString() + " " + dtUserDangBai.Rows[0][UsersColumns.UserlastnameColumn].ToString(); emailNguoiDangBai = dtUserDangBai.Rows[0][UsersColumns.UseremailColumn].ToString(); } #endregion #region Lấy info người hủy bài DataTable dtUserHuyBai = Users.GetUsersByUserId(CookieExtension.GetCookies("UserId")); string tenNguoiHuyBai = ""; if (dtUserHuyBai.Rows.Count > 0) { tenNguoiHuyBai = dtUserHuyBai.Rows[0][UsersColumns.UserfirstnameColumn].ToString() + " " + dtUserHuyBai.Rows[0][UsersColumns.UserlastnameColumn].ToString(); } #endregion #region Đổi trạng thái hiển thị của item string[] fieldsDelGroup = { "IIENABLE" }; string[] valuesDelGroup = { "3" }; string condition = " IID = '" + iid + "' "; TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsDelGroup, valuesDelGroup), condition); #endregion #region Thêm thông tin ("", người hủy, thời gian hủy, nội dung hủy) string data = StringExtension.GhepChuoi("", tenNguoiHuyBai, content); string[] fieldsDelGroup2 = { "VISEOMETACANONICAL" }; string[] valuesDelGroup2 = { "N'" + data + "'" }; string[] fieldsDelGroup3 = { "VISEOMETALANG" }; string[] valuesDelGroup3 = { "'" + DateTime.Now.ToString() + "'" }; condition = " IID = '" + iid + "' "; TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsDelGroup2, valuesDelGroup2), condition); TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsDelGroup3, valuesDelGroup3), condition); #endregion #region Gửi mail tới thành viên string link = "", contentEmail = ""; link = UrlExtension.WebisteUrl + "admin.aspx?uc=" + uc + "&suc=QuanLyBaiVietBiHuy"; contentEmail = @" <div style='color:#333'> <div>" + LanguageItemExtension.GetnLanguageItemTitleByName("Xin chào") + @" " + tenNguoiDangBai + @"!</div> <br/> <div>" + LanguageItemExtension.GetnLanguageItemTitleByName("Bài viết") + " <b>" + postTitle + @"</b> " + LanguageItemExtension.GetnLanguageItemTitleByName("của bạn đã bị hủy bỏ bởi") + @" <span style='color: blue'>" + tenNguoiHuyBai + @"</span> " + LanguageItemExtension.GetnLanguageItemTitleByName("với lời nhắn") + @":</div> <br /> <div>""" + content + @"""</div> <br /> <div>" + LanguageItemExtension.GetnLanguageItemTitleByName("Để xem danh sách các bài viết bị hủy, vui lòng click vào") + @" <a href='" + link + @"'>" + LanguageItemExtension.GetnLanguageItemTitleByName("đây") + @"</a>.</div> </div>" ; EmailExtension.SendEmail(emailNguoiDangBai, "Thông báo hủy bài viết từ " + UrlExtension.WebisteUrl, contentEmail); #endregion }