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