//保存列字段信息 public void SaveColumn() { NameValueCollection Params = HttpContext.Request.Form;//参数 Column column = new Column(); column.Author = User.Identity.Name; column.TablesCode = new Guid(Params["tablesCode"]); column.Owner = Params["owner"]; column.Name = Params["name"]; column.Type = Params["type"]; column.Bewrite = Params["bewrite"]; column.FieldState = int.Parse(Params["fieldState"]); column.HideAuthor = Params["hideAuthor"]; column.HideTime = DateTime.Now;//默认为空 string result = string.Empty; if (Params["code"] != null) { column.Code = new Guid(Params["code"]); result = DColumn.Update(column) != null ? "{HasError:false,msg:'列字段编辑成功!'}" : "{HasError:true,msg:'列字段编辑失败,请稍候再试!'}"; } else { column.Code = Guid.NewGuid(); result = DColumn.Add(column) != null ? "{HasError:false,msg:'列字段创建成功!'}" : "{HasError:true,msg:'列字段创建失败,请稍候再试!'}"; } Response.Write(result); Response.End(); }
/// <summary> /// 根据(副表同步主表)说明 /// </summary> /// <param name="Params">参数</param> /// <param name="tablesCode">表编码</param> /// <param name="TablesName">表名</param> /// <param name="SqlConnection">链接字符串</param> /// <param name="columnDt">主表</param> /// <param name="columnlist">附表</param> private void SynchronousChief(NameValueCollection Params, Guid tablesCode, string TablesName, string SqlConnection, DataTable columnDt, IList <Column> columnlist) { string SynchronousSQL = string.Empty; for (int i = 0; i < columnlist.Count; i++) { int columnNumber = 0;//记录主表与副表的交集数 for (int j = 0; j < columnDt.Rows.Count; j++) { //同步主表说明的SQL if (columnDt.Rows[j]["columnsName"].ToString() == columnlist[i].Name && columnlist[i].Bewrite != "" && (columnDt.Rows[j]["remark"].ToString() == "" || columnDt.Rows[j]["remark"].ToString() != columnlist[i].Bewrite)) { SynchronousSQL += string.Format("execute {4} N'MS_Description',N'{3}',N'SCHEMA',N'{0}',N'table',N'{1}',N'column',N'{2}';", columnlist[i].Owner, TablesName, columnlist[i].Name, columnlist[i].Bewrite, columnDt.Rows[j]["remark"].ToString() == "" ? "sp_addextendedproperty" : "sp_updateextendedproperty"); } //同步副表说明 if (columnDt.Rows[j]["columnsName"].ToString() == columnlist[i].Name && columnlist[i].Bewrite == "" && columnDt.Rows[j]["remark"].ToString() != "") { Column column = new Column(); column.Author = User.Identity.Name; column.TablesCode = tablesCode; column.Owner = columnlist[i].Owner; column.Name = columnlist[i].Name; column.Type = columnlist[i].Type; column.Bewrite = columnDt.Rows[j]["remark"].ToString(); column.FieldState = 1; column.HideAuthor = string.Empty; column.HideTime = DateTime.Now; column.Code = columnlist[i].Code; DColumn.Update(column); } if (columnDt.Rows[j]["columnsName"].ToString() == columnlist[i].Name) { columnNumber++; } } //附表存在作废字段 if (columnNumber == 0) { Column column = columnlist[i]; column.FieldState = 0; column.HideAuthor = User.Identity.Name; column.HideTime = DateTime.Now; DColumn.Update(column); } } if (!string.IsNullOrEmpty(SynchronousSQL)) { SQLHelper.ExecuteSql(SqlConnection, SynchronousSQL); } }