protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_FIELD_DBTYPE();
if(txtTYPE_ID.Value !="" )
condObj.Like(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Convert.ToInt32(txtTYPE_ID.Value));
if(txtTYPE_NAME.Value !="" )
condObj.Like(TF_FIELD_DBTYPE.Attribute.TYPE_NAME, Convert.ToString(txtTYPE_NAME.Value));
if(txtDB_TYPE.Value !="" )
condObj.Like(TF_FIELD_DBTYPE.Attribute.DB_TYPE, Convert.ToString(txtDB_TYPE.Value));
if(txtCTRL_TYPES.Value !="" )
condObj.Like(TF_FIELD_DBTYPE.Attribute.CTRL_TYPES, Convert.ToString(txtCTRL_TYPES.Value));
listObj = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
aspPager.RecordCount = recount;
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_FIELD_DBTYPE();
if (txtTYPE_ID.Value != "")
{
condObj.Like(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Convert.ToInt32(txtTYPE_ID.Value));
}
if (txtTYPE_NAME.Value != "")
{
condObj.Like(TF_FIELD_DBTYPE.Attribute.TYPE_NAME, Convert.ToString(txtTYPE_NAME.Value));
}
if (txtDB_TYPE.Value != "")
{
condObj.Like(TF_FIELD_DBTYPE.Attribute.DB_TYPE, Convert.ToString(txtDB_TYPE.Value));
}
if (txtCTRL_TYPES.Value != "")
{
condObj.Like(TF_FIELD_DBTYPE.Attribute.CTRL_TYPES, Convert.ToString(txtCTRL_TYPES.Value));
}
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_FIELD_DBTYPE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_FIELD_DBTYPE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void btnSetPageSize_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageSize.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_FIELD_DBTYPE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void btnSetPageSize_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageSize.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_FIELD_DBTYPE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void Page_Load(object sender, EventArgs e)
{
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelTYPE_ID"] != null)
{
int re = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).Delete(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Request["DelTYPE_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
TF_FIELD_DBTYPE cond = new TF_FIELD_DBTYPE();
cond.In(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Request["DelKeyIDS"]);
int re = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
TF_FIELD_DBTYPE val = new TF_FIELD_DBTYPE();
val.TYPE_ID = int.Parse(Request["FieldKeyID"]);
List <AttributeItem> lstCol = val.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName]))
{
val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable <TF_FIELD_DBTYPE> .Factory(conn).Update(val, TF_FIELD_DBTYPE.Attribute.TYPE_ID);
Response.Write("修改用户信息成功");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
#region//默认隐藏的列
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP1);
//hideTableColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP2);
//hideTableColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//暂时加此代码，以后框架更新将不需要
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP1);
//hideFindColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP2);
//hideFindColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_FIELD_DBTYPE roleOld = new TF_FIELD_DBTYPE();
roleOld.Where(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Request["ids"].ToString());
listObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).Select(valObj, roleOld);
for (int i = 0; i < listObj.Count; i++)
{
if (i > 0)
{
hidOld.Value += ",";
hidInitIDS.Value += ",";
}
hidOld.Value += "{ID:'" + listObj[i].TYPE_ID + "',Name:'" + listObj[i].TYPE_ID + "'}";//这里的Name用于显示在列表中，请自行重定义。
hidInitIDS.Value += listObj[i].TYPE_ID;
}
}
try
{
listObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "详细";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["TYPE_ID"]))
{
valObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Request["TYPE_ID"]);
if (valObj == null)
{
return;
}
txtTYPE_ID.Text = Convert.ToString(valObj.TYPE_ID);//Convert.ToInt32
txtTYPE_NAME.Text = Convert.ToString(valObj.TYPE_NAME);//Convert.ToString
txtDB_TYPE.Text = Convert.ToString(valObj.DB_TYPE);//Convert.ToString
txtCTRL_TYPES.Text = Convert.ToString(valObj.CTRL_TYPES);//Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
if (Request["ajax"] != null)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
//Response.ContentType = "html/text";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
divC.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelTYPE_ID"] != null)
{
int re = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).Delete(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Request["DelTYPE_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
TF_FIELD_DBTYPE cond = new TF_FIELD_DBTYPE();
cond.In(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Request["DelKeyIDS"]);
int re = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
TF_FIELD_DBTYPE val = new TF_FIELD_DBTYPE();
val.TYPE_ID = int.Parse(Request["FieldKeyID"]);
List<AttributeItem> lstCol = val.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) {
val.SetValue(lstCol[i].FieldName,Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable<TF_FIELD_DBTYPE>.Factory(conn).Update(val, TF_FIELD_DBTYPE.Attribute.TYPE_ID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "��ϸ";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["TYPE_ID"]))
{
valObj = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Request["TYPE_ID"]);
if(valObj==null) return ;
txtTYPE_ID.Text = Convert.ToString(valObj.TYPE_ID);//Convert.ToInt32
txtTYPE_NAME.Text = Convert.ToString(valObj.TYPE_NAME);//Convert.ToString
txtDB_TYPE.Text = Convert.ToString(valObj.DB_TYPE);//Convert.ToString
txtCTRL_TYPES.Text = Convert.ToString(valObj.CTRL_TYPES);//Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
if (Request["ajax"] != null)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//�����������������
//Response.ContentType = "html/text";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
divC.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
}
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_FIELD_DBTYPE>(hidCondition.Value);
}
listObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
private void BindList(TF_FIELD_DBTYPE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Order.Desc);
}
#region//数据权限条件
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_FIELD_DBTYPE>(hidCondition.Value);
}
listObj = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "±à¼";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["TYPE_ID"]))
{
keyid = Request["TYPE_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
this.txtTYPE_ID.Disabled = true;
this.txtTYPE_ID.Attributes["class"] = "dis";
try
{
if (keyid != "")
{
valObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_ID, keyid);
if (valObj == null)
{
return;
}
txtTYPE_ID.Value = Convert.ToString(valObj.TYPE_ID); //Convert.ToInt32
txtTYPE_NAME.Value = Convert.ToString(valObj.TYPE_NAME); //Convert.ToString
txtDB_TYPE.Value = Convert.ToString(valObj.DB_TYPE); //Convert.ToString
txtCTRL_TYPES.Value = Convert.ToString(valObj.CTRL_TYPES); //Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_FIELD_DBTYPE();
if (txtTYPE_ID.Value != "")
{
condObj.Like(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Convert.ToInt32(txtTYPE_ID.Value));
}
if (txtTYPE_NAME.Value != "")
{
condObj.Like(TF_FIELD_DBTYPE.Attribute.TYPE_NAME, Convert.ToString(txtTYPE_NAME.Value));
}
if (txtDB_TYPE.Value != "")
{
condObj.Like(TF_FIELD_DBTYPE.Attribute.DB_TYPE, Convert.ToString(txtDB_TYPE.Value));
}
if (txtCTRL_TYPES.Value != "")
{
condObj.Like(TF_FIELD_DBTYPE.Attribute.CTRL_TYPES, Convert.ToString(txtCTRL_TYPES.Value));
}
listObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
aspPager.RecordCount = recount;
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_FIELD_DBTYPE();
if(txtTYPE_ID.Value !="" )
condObj.Like(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Convert.ToInt32(txtTYPE_ID.Value));
if(txtTYPE_NAME.Value !="" )
condObj.Like(TF_FIELD_DBTYPE.Attribute.TYPE_NAME, Convert.ToString(txtTYPE_NAME.Value));
if(txtDB_TYPE.Value !="" )
condObj.Like(TF_FIELD_DBTYPE.Attribute.DB_TYPE, Convert.ToString(txtDB_TYPE.Value));
if(txtCTRL_TYPES.Value !="" )
condObj.Like(TF_FIELD_DBTYPE.Attribute.CTRL_TYPES, Convert.ToString(txtCTRL_TYPES.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void btnOK_Click(object sender, EventArgs e)
{
//try
//{
#region
TF_TABLE tbObj = null;
TF_TB_FIELD valObj = new TF_TB_FIELD();
if (string.IsNullOrEmpty(keyid)) //插入的时候
{
if (string.IsNullOrEmpty(tbid))
{
litWarn.Text = "请填充完整数据";
return;
}
valObj.TB_ID = int.Parse(tbid); // Convert.ToInt32(txtTB_ID.Value);
}
else //修改的时候
{
valObj.FIELD_ID = Convert.ToInt32(keyid);
if (string.IsNullOrEmpty(tbid))
{
valObj.TB_ID = Convert.ToInt32(BLLTable <TF_TB_FIELD> .Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID,
valObj.FIELD_ID, TF_TB_FIELD.Attribute.TB_ID));
}
if (valObj.TB_ID != 0) //
{
tbObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, valObj.TB_ID);
}
}
if (txtFIELD_NAME.Value != "")
{
valObj.FIELD_NAME = Convert.ToString(txtFIELD_NAME.Value);
}
else
{
litWarn.Text = "字段名为空！";
return;
}
if (ViewState["OLDNAME"].ToString().Trim() != txtFIELD_NAME.Value)
{
if (BLLTable <TF_TB_FIELD> .Exists(valObj))
{
litWarn.Text = "此字段已经存在，请重新输入！";
return;
}
}
if (txtFIELD_ID.Value != "")
{
valObj.FIELD_ID = Convert.ToInt32(txtFIELD_ID.Value);
}
if (txtFIELD_TYPE.Value != "")
{
TF_FIELD_DBTYPE typeObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_CODE, txtFIELD_TYPE.Value);
valObj.TYPE_CODE = typeObj.TYPE_CODE;
valObj.DB_TYPE = typeObj.DB_TYPE;
//valObj.TYPE_ID = Convert.ToInt32(txtFIELD_TYPE.Value);
}
//if(txtDB_TYPE.Value !="" )
// valObj.DB_TYPE = Convert.ToString(txtDB_TYPE.Value);
valObj.IS_NULL = txtIS_NULL.Checked == true ? 1 : 0;
if (txtNOTE.Value != "")
{
valObj.NOTE = Convert.ToString(txtNOTE.Value);
}
if (txtDEFAULT_VAL.Value != "")
{
valObj.DEFAULT_VAL = Convert.ToString(txtDEFAULT_VAL.Value);
}
//if (txtTB_ID.Value != "")
if (txtCTRL_TYPE.Value != "")
{
valObj.CTRL_TYPE = Convert.ToString(txtCTRL_TYPE.Value);
}
if (txtSORT_NO.Value != "")
{
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
}
#endregion
int editb = -9;
editb = AgileFrame.Common.TF_TABLEHelper.Factory(conn).InsertOrUpdateField(valObj, Convert.ToString(ViewState["OLDNAME"]), ref errMsg); //同时修改正式表和流程临时表字段
if (keyid != "")
{
if (editb > 0)
{
count = BLLTable <TF_TB_FIELD> .Factory(conn).Update(valObj, TF_TB_FIELD.Attribute.FIELD_ID);
}
else
{
//CHG START 去掉系统捕获信息显示在页面 jin-shenjian 2013/10/23
//litWarn.Text = "在数据库里修改字段信息失败！" + editb + "<a>" + errMsg + "</a>"
litWarn.Text = "在数据库里修改字段信息失败！";
//CHG END 去掉系统捕获信息显示在页面 jin-shenjian 2013/10/23
return;
}
}
else
{
//editb = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddField(valObj, ref errMsg);
if (editb > 0)
{
valObj.CREATED = ckAddToFormCol.Checked == true ? 1 : 0;
count = BLLTable <TF_TB_FIELD> .Factory(conn).Insert(valObj, TF_TB_FIELD.Attribute.FIELD_ID);
keyid = valObj.FIELD_ID.ToString();
}
else
{
litWarn.Text = "在数据库里创建字段信息失败！" + editb + ":" + errMsg;
return;
}
}
if (count > 0)
{
if (editb > 0) //物理表已修改
{
if (ckAddToFormCol.Checked == true && count > 0)
{
#region //同时新建为某个表单的栏目，前提是此表被某个表单使用中。
List <TF_FORM> lstForm = BLLTable <TF_FORM> .Factory(conn).Select(TF_FORM.Attribute.TB_ID, valObj.TB_ID);
if (lstForm != null)
{
foreach (TF_FORM f in lstForm)
{
TF_F_COLUMN valCol = new TF_F_COLUMN();
valCol.TB_ID = valObj.TB_ID;
valCol.FORM_ID = f.FORM_ID;
valCol.FIELD_ID = valObj.FIELD_ID;
if (!BLLTable <TF_F_COLUMN> .Exists(valCol))
{
valCol.SHOW_NAME = valObj.NOTE;
valCol.CTRL_TYPE = valObj.CTRL_TYPE;
valCol.MAX_VAL = 0;
valCol.IS_DEFAULT = "0";
valCol.MIN_VAL = 0;
valCol.IS_NEED = valObj.IS_NULL == 1 ? 0 : 1;
valCol.SORT_NO = valObj.SORT_NO;
valCol.SHOWIN_FORM = "1";
int count2 = BLLTable <TF_F_COLUMN> .Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID);
if (count2 <= 0)
{
"".ToString();
}
}
}
}
#endregion
}
}
#region
string gotoUrl = WebHelper.GetAppPath() + @"ok.aspx";
if (Request["tree"] != null) //父窗体有树的情况，左边
{
//if(Server.MapPath(gotoUrl))
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append(valObj.TB_ID).Append("',no:").Append(valObj.SORT_NO).Append(",sc:0,name:'");
//CHG START 点击节点选择页面条件有误 jin-shenjian 2013/10/26
//sb.Append(valObj.NOTE).Append("',ntype:'TF_F_COLUMN'}");
sb.Append(valObj.NOTE).Append("',ntype:'TF_TB_FIELD'}");
//CHG END 点击节点选择页面条件有误 jin-shenjian 2013/10/26
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
}
else //非树、子窗口的情况
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID == "btnOK") //选择的时候
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else //保存按钮的情况
{
txtFIELD_NAME.Value = "";
txtFIELD_TYPE.Value = "";
txtIS_NULL.Value = "";
txtNOTE.Value = "";
txtDEFAULT_VAL.Value = "";
AgileFrame.Core.ScriptHelper.Alert(Page, "操作成功");
}
}
#endregion
}
else
{
litWarn.Text = "修改记录没有成功！";
}
//}
//catch (Exception ex)
//{
// litWarn.Text = ex.Message;
//}
}
protected void Page_Load(object sender, EventArgs e)
{
#region//Ĭ�����ص���
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP1);
//hideTableColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP2);
//hideTableColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP1);
//hideFindColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP2);
//hideFindColumnList.Add(TF_FIELD_DBTYPE.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_FIELD_DBTYPE roleOld = new TF_FIELD_DBTYPE();
roleOld.Where(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Request["ids"].ToString());
listObj = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).Select(valObj, roleOld);
for (int i = 0; i < listObj.Count; i++)
{
if (i > 0)
{
hidOld.Value += ",";
hidInitIDS.Value += ",";
}
hidOld.Value += "{ID:'" + listObj[i].TYPE_ID + "',Name:'" + listObj[i].TYPE_ID + "'}";//�����Name������ʾ���б��У��������ض��塣
hidInitIDS.Value += listObj[i].TYPE_ID;
}
}
try
{
listObj = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_FIELD_DBTYPE valObj = new TF_FIELD_DBTYPE();
if (txtTYPE_ID.Value != "")
{
valObj.TYPE_ID = Convert.ToInt32(txtTYPE_ID.Value);
}
if (txtTYPE_NAME.Value != "")
{
valObj.TYPE_NAME = Convert.ToString(txtTYPE_NAME.Value);
}
if (txtDB_TYPE.Value != "")
{
valObj.DB_TYPE = Convert.ToString(txtDB_TYPE.Value);
}
if (txtCTRL_TYPES.Value != "")
{
valObj.CTRL_TYPES = Convert.ToString(txtCTRL_TYPES.Value);
}
if (keyid != "")
{
valObj.TYPE_ID = Convert.ToInt32(keyid);
count = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).Update(valObj, TF_FIELD_DBTYPE.Attribute.TYPE_ID);
}
else
{
count = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).Insert(valObj, TF_FIELD_DBTYPE.Attribute.TYPE_ID);
keyid = valObj.TYPE_ID.ToString();
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
txtTYPE_ID.Value = "";
txtTYPE_NAME.Value = "";
txtDB_TYPE.Value = "";
txtCTRL_TYPES.Value = "";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
private void BindList(TF_FIELD_DBTYPE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(TF_FIELD_DBTYPE.Attribute.TYPE_ID, Order.Desc);
#region//����Ȩ������
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["TYPE_ID"]))
{
keyid = Request["TYPE_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
this.txtTYPE_ID.Disabled = true;
this.txtTYPE_ID.Attributes["class"] = "dis";
try
{
if (keyid != "")
{
valObj = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_ID, keyid);
if(valObj==null) return ;
txtTYPE_ID.Value = Convert.ToString(valObj.TYPE_ID);//Convert.ToInt32
txtTYPE_NAME.Value = Convert.ToString(valObj.TYPE_NAME);//Convert.ToString
txtDB_TYPE.Value = Convert.ToString(valObj.DB_TYPE);//Convert.ToString
txtCTRL_TYPES.Value = Convert.ToString(valObj.CTRL_TYPES);//Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
//try
//{
#region
TF_TB_FIELD valObj = new TF_TB_FIELD();
valObj.TB_ID = int.Parse(tbid); // Convert.ToInt32(txtTB_ID.Value);
if (txtFIELD_NAME.Value != "")
{
valObj.FIELD_NAME = Convert.ToString(txtFIELD_NAME.Value);
}
if (ViewState["OLDNAME"].ToString() != txtFIELD_NAME.Value)
{
if (BLLTable <TF_TB_FIELD> .Exists(valObj))
{
litWarn.Text = "此字段已经存在，请重新输入！";
return;
}
}
if (txtFIELD_ID.Value != "")
{
valObj.FIELD_ID = Convert.ToInt32(txtFIELD_ID.Value);
}
if (txtFIELD_TYPE.Value != "")
{
TF_FIELD_DBTYPE typeObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_CODE, txtFIELD_TYPE.Value);
valObj.TYPE_CODE = typeObj.TYPE_CODE;
valObj.DB_TYPE = typeObj.DB_TYPE;
//valObj.TYPE_ID = Convert.ToInt32(txtFIELD_TYPE.Value);
}
//if(txtDB_TYPE.Value !="" )
// valObj.DB_TYPE = Convert.ToString(txtDB_TYPE.Value);
valObj.IS_NULL = txtIS_NULL.Checked == true ? 1 : 0;
if (txtNOTE.Value != "")
{
valObj.NOTE = Convert.ToString(txtNOTE.Value);
}
if (txtDEFAULT_VAL.Value != "")
{
valObj.DEFAULT_VAL = Convert.ToString(txtDEFAULT_VAL.Value);
}
//if (txtTB_ID.Value != "")
if (txtCTRL_TYPE.Value != "")
{
valObj.CTRL_TYPE = Convert.ToString(txtCTRL_TYPE.Value);
}
if (txtSORT_NO.Value != "")
{
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
}
#endregion
int editb = -9;
if (keyid != "")
{
valObj.FIELD_ID = Convert.ToInt32(keyid);
//TF_TB_FIELD oldObj = BLLTable<TF_TB_FIELD>.Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, keyid);
editb = new AgileFrame.Common.TF_TABLEHelper(conn).SaveOrUpdateField(valObj, ViewState["OLDNAME"].ToString(), ref errMsg); //同时修改正式表和流程临时表字段
if (editb > 0)
{
count = BLLTable <TF_TB_FIELD> .Factory(conn).Update(valObj, TF_TB_FIELD.Attribute.FIELD_ID);
}
else
{
litWarn.Text = "在数据库里修改字段信息失败！" + editb;
return;
}
}
else
{
//editb = new AgileFrame.Common.TF_TABLEHelper(conn).AddField(valObj, ref errMsg);
editb = new AgileFrame.Common.TF_TABLEHelper(conn).InsertOrUpdateField(valObj, null, ref errMsg);
if (editb > 0)
{
valObj.CREATED = ckAddToFormCol.Checked == true ? 1 : 0;
count = BLLTable <TF_TB_FIELD> .Factory(conn).Insert(valObj, TF_TB_FIELD.Attribute.FIELD_ID);
keyid = valObj.FIELD_ID.ToString();
}
else
{
litWarn.Text = "在数据库里创建字段信息失败！" + editb;
return;
}
}
if (count > 0)
{
if (editb > 0)
{
if (ckAddToFormCol.Checked == true && count > 0)
{
#region //同时新建为某个表单的栏目，前提是此表倍某个表单使用中。
List <TF_FORM> lstForm = BLLTable <TF_FORM> .Factory(conn).Select(TF_FORM.Attribute.TB_ID, valObj.TB_ID);
if (lstForm != null)
{
lstForm.ForEach(f =>
{
TF_F_COLUMN valCol = new TF_F_COLUMN();
valCol.TB_ID = valObj.TB_ID;
valCol.FORM_ID = f.FORM_ID;
valCol.FIELD_ID = valObj.FIELD_ID;
if (!BLLTable <TF_F_COLUMN> .Exists(valCol))
{
valCol.SHOW_NAME = valObj.NOTE;
valCol.CTRL_TYPE = valObj.CTRL_TYPE;
valCol.MAX_VAL = 0;
valCol.IS_DEFAULT = "0";
valCol.MIN_VAL = 0;
valCol.IS_NEED = valObj.IS_NULL == 1 ? 0 : 1;
valCol.SORT_NO = valObj.SORT_NO;
valCol.SHOWIN_FORM = "1";
BLLTable <TF_F_COLUMN> .Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID);
}
});
}
#endregion
}
}
#region
if (Request["tree"] != null)
{
string gotoUrl = "../../../../ok.aspx";
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append(valObj.TB_ID).Append("',no:").Append(valObj.SORT_NO).Append(",sc:0,name:'");
sb.Append(valObj.NOTE).Append("',ntype:'field'}");
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
}
else
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
txtFIELD_NAME.Value = "";
txtFIELD_TYPE.Value = "";
txtIS_NULL.Value = "";
txtNOTE.Value = "";
txtDEFAULT_VAL.Value = "";
}
}
#endregion
}
else
{
litWarn.Text = "修改记录没有成功！";
}
//}
//catch (Exception ex)
//{
// litWarn.Text = ex.Message;
//}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_FIELD_DBTYPE valObj = new TF_FIELD_DBTYPE();
if(txtTYPE_ID.Value !="" )
valObj.TYPE_ID = Convert.ToInt32(txtTYPE_ID.Value);
if(txtTYPE_NAME.Value !="" )
valObj.TYPE_NAME = Convert.ToString(txtTYPE_NAME.Value);
if(txtDB_TYPE.Value !="" )
valObj.DB_TYPE = Convert.ToString(txtDB_TYPE.Value);
if(txtCTRL_TYPES.Value !="" )
valObj.CTRL_TYPES = Convert.ToString(txtCTRL_TYPES.Value);
if (keyid != "")
{
valObj.TYPE_ID = Convert.ToInt32(keyid);
count = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).Update(valObj, TF_FIELD_DBTYPE.Attribute.TYPE_ID);
}
else
{
count = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).Insert(valObj, TF_FIELD_DBTYPE.Attribute.TYPE_ID);
keyid = valObj.TYPE_ID.ToString();
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List<AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
txtTYPE_ID.Value ="";
txtTYPE_NAME.Value ="";
txtDB_TYPE.Value ="";
txtCTRL_TYPES.Value ="";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
