protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { ContFieldInfo contFieldInfo = e.Item.DataItem as ContFieldInfo; FieldControl fieldControl = e.Item.FindControl("field") as FieldControl; if (fieldControl != null) { fieldControl.ControlType = (FieldType)contFieldInfo.FieldType; fieldControl.ControlPath = "~/Platform/h5/FieldControls/"; fieldControl.LoadControlId = ((FieldType)contFieldInfo.FieldType).ToString(); fieldControl.FieldName = contFieldInfo.FieldName; fieldControl.FieldAlias = contFieldInfo.Alias; fieldControl.FieldId = contFieldInfo.AutoID; fieldControl.EnableNull = contFieldInfo.EnableNull; fieldControl.Settings = XmlSerializerUtils.Deserialize <SinGooCMS.Control.FieldSetting>(contFieldInfo.Setting); fieldControl.DataLength = contFieldInfo.DataLength; if (!string.IsNullOrEmpty(contFieldInfo.Value)) { fieldControl.Value = contFieldInfo.Value; } else { fieldControl.Value = contFieldInfo.DefaultValue; } } } }
protected void lnk_Delete_Click(object sender, System.EventArgs e) { if (!base.IsAuthorizedOp(ActionType.Delete.ToString())) { base.ShowAjaxMsg(this.UpdatePanel1, "Không có thẩm quyền"); } else { int @int = WebUtils.GetInt((sender as LinkButton).CommandArgument); ContFieldInfo dataById = SinGooCMS.BLL.ContField.GetDataById(@int); if (dataById == null) { base.ShowAjaxMsg(this.UpdatePanel1, "Những thông tin này không được tìm thấy, các dữ liệu không tồn tại hoặc đã bị xóa"); } else if (dataById.IsSystem) { base.ShowAjaxMsg(this.UpdatePanel1, "系统字段不能删除"); } else if (SinGooCMS.BLL.ContField.Delete(@int)) { this.BindData(); PageBase.log.AddEvent(base.LoginAccount.AccountName, "Xóa trường [" + dataById.FieldName + "] thành công"); base.ShowAjaxMsg(this.UpdatePanel1, "Xóa trường 成功"); } else { base.ShowAjaxMsg(this.UpdatePanel1, "Xóa trường 失败"); } } }
public static FieldAddState Add(ContFieldInfo field) { ContModelInfo cacheModelByID = ContModel.GetCacheModelByID(field.ModelID); FieldAddState result; if (cacheModelByID == null) { result = FieldAddState.ModelNotExists; } else { int value = BizBase.dbo.GetValue <int>(string.Concat(new object[] { "SELECT COUNT(*) FROM cms_ContField WHERE ModelID=", field.ModelID, " AND FieldName='", field.FieldName, "'" })); if (value > 0) { result = FieldAddState.FieldNameExists; } else { if (BizBase.dbo.InsertModel <ContFieldInfo>(field) > 0) { try { string text = field.DataType; if (string.Compare(text, "nvarchar", true) == 0) { object obj = text; text = string.Concat(new object[] { obj, "(", field.DataLength, ")" }); } TableManager.AddTableColumn(cacheModelByID.TableName, field.FieldName, text, true, field.DefaultValue); } catch { result = FieldAddState.CreateColumnError; return(result); } } CacheUtils.Del("JsonLeeCMS_CacheForGetContModel"); result = FieldAddState.Success; } } return(result); }
public static bool Delete(int fieldID) { ContFieldInfo dataById = ContField.GetDataById(fieldID); ContModelInfo dataById2 = ContModel.GetDataById(dataById.ModelID); if (BizBase.dbo.DeleteModel <ContFieldInfo>(dataById)) { TableManager.DropTableColumn(dataById2.TableName, dataById.FieldName); } CacheUtils.Del("JsonLeeCMS_CacheForGetContModel"); return(true); }
private System.Collections.Generic.Dictionary <string, ContFieldInfo> GetFieldDicWithValues() { System.Collections.Generic.Dictionary <string, ContFieldInfo> dictionary = new System.Collections.Generic.Dictionary <string, ContFieldInfo>(); foreach (RepeaterItem repeaterItem in this.Repeater1.Items) { FieldControl fieldControl = repeaterItem.FindControl("field") as FieldControl; if (fieldControl != null) { ContFieldInfo dataById = SinGooCMS.BLL.ContField.GetDataById(fieldControl.FieldId); if (dataById != null) { dataById.Value = fieldControl.Value; dictionary.Add(dataById.FieldName, dataById); } } } return(dictionary); }
public static bool Update(ContFieldInfo field) { ContModelInfo cacheModelByID = ContModel.GetCacheModelByID(field.ModelID); ContFieldInfo dataById = ContField.GetDataById(field.AutoID); bool result; if (BizBase.dbo.UpdateModel <ContFieldInfo>(field)) { if (!dataById.IsSystem) { try { string text = field.DataType; if (string.Compare(text, "nvarchar", true) == 0) { object obj = text; text = string.Concat(new object[] { obj, "(", field.DataLength, ")" }); } TableManager.AlterTableColumn(cacheModelByID.TableName, dataById.FieldName, field.FieldName, text, true, field.DefaultValue); } catch (Exception ex) { throw ex; } } CacheUtils.Del("JsonLeeCMS_CacheForGetContModel"); result = true; } else { result = false; } return(result); }
private void InitForModify() { ContFieldInfo dataById = SinGooCMS.BLL.ContField.GetDataById(base.OpID); if (dataById != null) { this.TextBox2.Text = dataById.FieldName; this.TextBox2.Enabled = false; this.TextBox3.Text = dataById.Alias; this.TextBox4.Text = dataById.Tip; ListItem listItem = this.DropDownList5.Items.FindByValue(((FieldType)dataById.FieldType).ToString()); if (listItem != null) { listItem.Selected = true; } if (dataById.IsSystem) { this.DropDownList5.Enabled = false; } switch (dataById.FieldType) { case 0: this.ShowGroup = "group1"; break; case 1: this.ShowGroup = "group2"; break; case 2: this.ShowGroup = "group7"; break; case 4: case 5: case 6: this.ShowGroup = "group3"; break; case 7: this.ShowGroup = "group6"; break; case 8: case 10: this.ShowGroup = "group4"; break; case 9: case 11: this.ShowGroup = "group5"; break; } this.TextBox6.Text = dataById.DefaultValue; this.CheckBox7.Checked = dataById.IsUsing; this.CheckBox9.Checked = dataById.EnableNull; this.ExtTextBox5.Text = dataById.DataLength.ToString(); if (dataById.IsSystem) { this.ExtTextBox5.Enabled = false; } SinGooCMS.Control.FieldSetting fieldSetting = XmlSerializerUtils.Deserialize <SinGooCMS.Control.FieldSetting>(dataById.Setting); if (fieldSetting != null) { this.ExtTextBox1.Text = fieldSetting.ControlWidth.ToString(); this.ExtTextBox2.Text = fieldSetting.ControlHeight.ToString(); ListItem listItem2 = this.ExtRadioButtonList3.Items.FindByValue(fieldSetting.TextMode); if (listItem2 != null) { listItem2.Selected = true; } this.ExtTextBox4.Text = fieldSetting.DataFormat; ListItem listItem3 = this.ExtDropDownList6.Items.FindByValue(fieldSetting.DataFrom); if (listItem3 != null) { listItem3.Selected = true; } string dataFrom = fieldSetting.DataFrom; if (dataFrom != null) { if (!(dataFrom == "Text")) { if (!(dataFrom == "DataDictionary")) { if (!(dataFrom == "SQLQuery")) { if (dataFrom == "AjaxData") { this.ExtTextBox11.Text = fieldSetting.DataSource; this.DataSource = "AjaxData"; } } else { this.ExtTextBox9.Text = fieldSetting.DataSource; this.DataSource = "SQLQuery"; } } else { this.ExtTextBox8.Text = fieldSetting.DataSource; this.DataSource = "DataDictionary"; } } else { this.ExtTextBox7.Text = fieldSetting.DataSource; this.DataSource = "Text"; } } } } }
protected void btnok_Click(object sender, System.EventArgs e) { if (base.Action.Equals(ActionType.Add.ToString()) && !base.IsAuthorizedOp(ActionType.Add.ToString())) { base.ShowMsg("Không có thẩm quyền"); } else if (base.Action.Equals(ActionType.Modify.ToString()) && !base.IsAuthorizedOp(ActionType.Modify.ToString())) { base.ShowMsg("Không có thẩm quyền"); } else { ContFieldInfo contFieldInfo = new ContFieldInfo(); if (base.IsEdit) { contFieldInfo = SinGooCMS.BLL.ContField.GetDataById(base.OpID); } contFieldInfo.ModelID = this.modelParent.AutoID; contFieldInfo.FieldName = WebUtils.GetString(this.TextBox2.Text); contFieldInfo.Alias = WebUtils.GetString(this.TextBox3.Text); contFieldInfo.Tip = WebUtils.GetString(this.TextBox4.Text); contFieldInfo.FieldType = (int)((FieldType)System.Enum.Parse(typeof(FieldType), this.DropDownList5.SelectedValue)); contFieldInfo.DataLength = 50; if (string.IsNullOrEmpty(contFieldInfo.FieldName) || string.IsNullOrEmpty(contFieldInfo.Alias)) { base.ShowMsg("字段名称/Tên hiển thị không thể để trống"); } else { contFieldInfo.DefaultValue = WebUtils.GetString(this.TextBox6.Text); SinGooCMS.Control.FieldSetting fieldSetting = new SinGooCMS.Control.FieldSetting(); fieldSetting.ControlWidth = WebUtils.GetInt(this.ExtTextBox1.Text); fieldSetting.ControlHeight = WebUtils.GetInt(this.ExtTextBox2.Text); fieldSetting.TextMode = this.ExtRadioButtonList3.SelectedValue; fieldSetting.IsDataType = contFieldInfo.FieldType.Equals(FieldType.DateTimeType); fieldSetting.DataFormat = WebUtils.GetString(this.ExtTextBox4.Text); FieldType fieldType = (FieldType)contFieldInfo.FieldType; if (fieldType != FieldType.MultipleHtmlType) { if (fieldType != FieldType.DateTimeType) { contFieldInfo.DataType = "nvarchar"; contFieldInfo.DataLength = WebUtils.GetInt(this.ExtTextBox5.Text, 50); } else { contFieldInfo.DataType = "datetime"; } } else { contFieldInfo.DataType = "ntext"; } fieldSetting.DataFrom = this.ExtDropDownList6.SelectedValue; string dataFrom = fieldSetting.DataFrom; if (dataFrom != null) { if (!(dataFrom == "Text")) { if (!(dataFrom == "DataDictionary")) { if (!(dataFrom == "SQLQuery")) { if (dataFrom == "AjaxData") { fieldSetting.DataSource = WebUtils.GetString(this.ExtTextBox11.Text); } } else { fieldSetting.DataSource = WebUtils.GetString(this.ExtTextBox9.Text); } } else { fieldSetting.DataSource = WebUtils.GetString(this.ExtTextBox8.Text); } } else { fieldSetting.DataSource = this.ExtTextBox7.Text; } } contFieldInfo.Setting = XmlSerializerUtils.Serialize <SinGooCMS.Control.FieldSetting>(fieldSetting); contFieldInfo.IsUsing = this.CheckBox7.Checked; contFieldInfo.EnableNull = this.CheckBox9.Checked; contFieldInfo.EnableSearch = false; if (base.Action.Equals(ActionType.Add.ToString())) { contFieldInfo.Sort = SinGooCMS.BLL.ContField.MaxSort + 1; contFieldInfo.AutoTimeStamp = System.DateTime.Now; contFieldInfo.IsSystem = false; FieldAddState fieldAddState = SinGooCMS.BLL.ContField.Add(contFieldInfo); FieldAddState fieldAddState2 = fieldAddState; switch (fieldAddState2) { case FieldAddState.Error: base.ShowMsg("Tạo trường thất bại"); break; case FieldAddState.FieldNameIsUsing: base.ShowMsg("Tên trường đã được sử dụng"); break; case FieldAddState.FieldNameExists: base.ShowMsg("Tên trường đã tồn tại"); break; case FieldAddState.ModelNotExists: base.ShowMsg("Không tìm thấy kiểu dữ liệu"); break; case FieldAddState.CreateColumnError: base.ShowMsg("Tạo cột dữ liệu thất bại"); break; default: if (fieldAddState2 != FieldAddState.Success) { base.ShowMsg("增加内容字段失败,Lỗi Unknown"); } else { PageBase.log.AddEvent(base.LoginAccount.AccountName, "增加内容字段[" + contFieldInfo.FieldName + "] thành công"); base.Response.Redirect(string.Concat(new object[] { "ContField.aspx?CatalogID=", base.CurrentCatalogID, "&Module=", base.CurrentModuleCode, "&ModelID=", this.intModelID, "&action=View" })); } break; } } if (base.Action.Equals(ActionType.Modify.ToString())) { if (SinGooCMS.BLL.ContField.Update(contFieldInfo)) { PageBase.log.AddEvent(base.LoginAccount.AccountName, "修改内容字段[" + contFieldInfo.FieldName + "] thành công"); base.Response.Redirect(string.Concat(new object[] { "ContField.aspx?CatalogID=", base.CurrentCatalogID, "&Module=", base.CurrentModuleCode, "&ModelID=", this.intModelID, "&action=View" })); } else { base.ShowMsg("修改内容字段失败"); } } } } }