protected void Page_Load(object sender, EventArgs e)
{
#region//默认隐藏的列
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_CTRL_TYPE.Attribute.EXP1);
//hideTableColumnList.Add(TF_CTRL_TYPE.Attribute.EXP2);
//hideTableColumnList.Add(TF_CTRL_TYPE.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//暂时加此代码，以后框架更新将不需要
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_CTRL_TYPE.Attribute.EXP1);
//hideFindColumnList.Add(TF_CTRL_TYPE.Attribute.EXP2);
//hideFindColumnList.Add(TF_CTRL_TYPE.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_CTRL_TYPE roleOld = new TF_CTRL_TYPE();
roleOld.Where(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Request["ids"].ToString());
listObj = BLLTable <TF_CTRL_TYPE> .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].CTRL_TYPE + "',Name:'" + listObj[i].CTRL_TYPE + "'}";//这里的Name用于显示在列表中，请自行重定义。
hidInitIDS.Value += listObj[i].CTRL_TYPE;
}
}
try
{
listObj = BLLTable <TF_CTRL_TYPE> .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 (!string.IsNullOrEmpty(Request["COLUMN_ID"]))
{
keyid = Request["COLUMN_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["edit"]) && Request["ntype"]=="TF_F_COLUMN")
{
keyid = Request["id"];
}
if (Request["ntype"] == "TF_FORM" || Request["ntype"] == "TF_FORM-mx")
{
formid = Request["id"];
txtFORM_ID.Value = formid;
}
if (!string.IsNullOrEmpty(Request["formid"]))
{
formid = Request["formid"];
txtFORM_ID.Value = formid;
}
if (!IsPostBack)
{
dlCAL_FORMULA.Style.Value="display:none";//.Visible = false;
dlSUM_FIELD_ID.Style.Value="display:none";//.Visible = false;
//try
//{
ViewState["txtFIELD_ID"] = "";
if (keyid != "")
{
valObj = BLLTable<TF_F_COLUMN>.Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, keyid);
if (valObj == null) return;
txtCOLUMN_ID.Value = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32
formid = valObj.FORM_ID.ToString();
txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
txtTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
hidFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32
txtFIELD_ID.Value = BLLTable<TF_TB_FIELD>.Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID, TF_TB_FIELD.Attribute.NOTE);
ViewState["txtFIELD_ID"] = txtFIELD_ID.Value;
ViewState["hidFIELD_ID"] = hidFIELD_ID.Value;
txtSHOW_NAME.Value = Convert.ToString(valObj.SHOW_NAME);//Convert.ToString
//txtCTRL_TYPE.Value = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString
txtMAX_VAL.Value = Convert.ToString(valObj.MAX_VAL);//Convert.ToInt32
txtMIN_VAL.Value = Convert.ToString(valObj.MIN_VAL);//Convert.ToInt32
txtDEFAULT_VAL.Value = Convert.ToString(valObj.DEFAULT_VAL);//Convert.ToString
txtIS_NEED.Checked = valObj.IS_NEED == 1 ? true : false;//Convert.ToInt32
//txtCAL_FORMULA.Value = Convert.ToString(valObj.CAL_FORMULA);//Convert.ToString
txtSUM_FIELD_ID.Value = Convert.ToString(valObj.SUM_FIELD_ID);//Convert.ToString
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtCAL_FORMULA.Value = valObj.CAL_FORMULA;
if (valObj.SHOWIN_HEADER == "1")
{
txtSHOWIN_HEADR.Checked = true;
}
else {
txtSHOWIN_HEADR.Checked = false;
}
txtSHOWIN_FORM.Checked = valObj.SHOWIN_FORM == "1" ? true : false;
TF_TB_FIELD fieldObj = BLLTable<TF_TB_FIELD>.Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID);
if (fieldObj != null)
{
if (fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Decimal.ToString() ||
fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Number.ToString())
{
//dlCAL_FORMULA.Style.Value = "display:block";//.Visible = true;
}
else
{
dlCAL_FORMULA.Visible = false;
dlSUM_FIELD_ID.Visible = false;
}
}
else {
litWarn.Text = "��Ӧ�ֶι�������ȷ��";
}
// Response.Write(fieldObj.TYPE_CODE);
}
if (txtFORM_ID.Value != "")
{
#region//��ʼ�����ڱ�д��ʽ�Ŀ�ѡ�ֶ��б�
TF_FORM formObj = BLLTable<TF_FORM>.Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, txtFORM_ID.Value);
if (formObj != null)
txtTB_ID.Value = formObj.TB_ID.ToString();
if (formObj.M_FORM_ID > 0)
{
TF_TB_FIELD numccc = new TF_TB_FIELD();
numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString());
numccc.TB_ID = formObj.TB_ID;
List<TF_TB_FIELD> fieldList = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), numccc);
if (fieldList != null && fieldList.Count > 0)
{
StringBuilder sbnumcols = new StringBuilder();
fieldList.ForEach(f =>
{
sbnumcols.Append("<a data='" + f.FIELD_NAME + "' onclick='selColToCalInput(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>");
});
litNumberFields.Text = sbnumcols.ToString();
if (keyid != "")
{
dlCAL_FORMULA.Style.Value = "display:block";//.Visible = true;
}
//dlCAL_FORMULA.Visible = true;
}
#endregion
#region//��ʼ���ۺϿ���������Ϊ����ij���ֶε�ֵ���ֶ��б�,��Щ�ֶ�������ϸ��
formObj = BLLTable<TF_FORM>.Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, formObj.M_FORM_ID);
if (formObj != null)
{
numccc = new TF_TB_FIELD();
numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString());
numccc.TB_ID = formObj.TB_ID;
TF_TABLE tbObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, formObj.TB_ID);
fieldList = new List<TF_TB_FIELD>();
fieldList = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), numccc);
if (fieldList != null && fieldList.Count > 0)
{
StringBuilder sbnumcols = new StringBuilder();
fieldList.ForEach(f =>
{
sbnumcols.Append("<a class='cansel' data='" + tbObj.TB_NAME + "." + f.FIELD_NAME + "' onclick='selColToSum(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>");
});
litSUM_FIELD_ID.Text = sbnumcols.ToString();
if (keyid != "")
{
dlSUM_FIELD_ID.Style.Value = "display:block";//.Visible = true;
}
//dlSUM_FIELD_ID.Visible = true;
}
}
}
#endregion
}
#region//��ʼ���ؼ�����
TF_CTRL_TYPE ctrlCond = new TF_CTRL_TYPE();
ctrlCond.OrderBy(TF_CTRL_TYPE.Attribute.SORT_NO, Order.Asc);
DataTable dtCtrl = BLLTable<TF_CTRL_TYPE>.SelectForDataTable(new TF_CTRL_TYPE(), ctrlCond);
ViewState["CTRL_TYPE"] = valObj.CTRL_TYPE;
DataView dv1 = new DataView();
dv1.Table = dtCtrl;
dv1.RowFilter = "P_CTRL_TYPE='0'";
dv1.Sort = "SORT_NO asc";
for (int i = 0; i < dv1.Count; i++)
{
litCTRL_TYPE.Text += "<optgroup label='" + dv1[i]["CTRL_NAME"].ToString() + "'>";
DataView dv2 = new DataView();
dv2.Table = dtCtrl;
dv2.RowFilter = "P_CTRL_TYPE='" + dv1[i]["CTRL_TYPE"].ToString() + "'";
dv2.Sort = "SORT_NO asc";
for (int a = 0; a < dv2.Count; a++)
{
if (valObj != null && valObj.CTRL_TYPE == dv2[a]["CTRL_TYPE"].ToString())
{
litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "' selected='selected'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>";
}
else
{
litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>";
}
}
litCTRL_TYPE.Text += "</optgroup>";
}
#endregion
//}
//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["COLUMN_ID"]))
{
keyid = Request["COLUMN_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["edit"]) && Request["ntype"] == "formcol")
{
keyid = Request["id"];
}
if (Request["ntype"] == "form" || Request["ntype"] == "form-mx")
{
formid = Request["id"];
txtFORM_ID.Value = formid;
}
if (!string.IsNullOrEmpty(Request["formid"]))
{
formid = Request["formid"];
txtFORM_ID.Value = formid;
}
if (!IsPostBack)
{
dlCAL_FORMULA.Style.Value = "display:none"; //.Visible = false;
dlSUM_FIELD_ID.Style.Value = "display:none"; //.Visible = false;
//try
//{
ViewState["txtFIELD_ID"] = "";
if (keyid != "")
{
valObj = BLLTable <TF_F_COLUMN> .Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, keyid);
if (valObj == null)
{
return;
}
txtCOLUMN_ID.Value = Convert.ToString(valObj.COLUMN_ID); //Convert.ToInt32
formid = valObj.FORM_ID.ToString();
txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID); //Convert.ToInt32
txtTB_ID.Value = Convert.ToString(valObj.TB_ID); //Convert.ToInt32
hidFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID); //Convert.ToInt32
txtFIELD_ID.Value = BLLTable <TF_TB_FIELD> .Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID, TF_TB_FIELD.Attribute.NOTE);
ViewState["txtFIELD_ID"] = txtFIELD_ID.Value;
txtSHOW_NAME.Value = Convert.ToString(valObj.SHOW_NAME);//Convert.ToString
//txtCTRL_TYPE.Value = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString
txtMAX_VAL.Value = Convert.ToString(valObj.MAX_VAL); //Convert.ToInt32
txtMIN_VAL.Value = Convert.ToString(valObj.MIN_VAL); //Convert.ToInt32
txtIS_NEED.Checked = valObj.IS_NEED == 1 ? true : false; //Convert.ToInt32
//txtCAL_FORMULA.Value = Convert.ToString(valObj.CAL_FORMULA);//Convert.ToString
txtSUM_FIELD_ID.Value = Convert.ToString(valObj.SUM_FIELD_ID); //Convert.ToString
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO); //Convert.ToInt32
txtCAL_FORMULA.Value = valObj.CAL_FORMULA;
if (valObj.SHOWIN_HEADER == "1")
{
txtSHOWIN_HEADR.Checked = true;
}
else
{
txtSHOWIN_HEADR.Checked = false;
}
txtSHOWIN_FORM.Checked = valObj.SHOWIN_FORM == "1" ? true : false;
TF_TB_FIELD fieldObj = BLLTable <TF_TB_FIELD> .Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID);
if (fieldObj != null)
{
if (fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Decimal.ToString() ||
fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Number.ToString())
{
//dlCAL_FORMULA.Style.Value = "display:block";//.Visible = true;
}
else
{
dlCAL_FORMULA.Visible = false;
dlSUM_FIELD_ID.Visible = false;
}
}
else
{
litWarn.Text = "对应字段关联不正确。";
}
// Response.Write(fieldObj.TYPE_CODE);
}
if (txtFORM_ID.Value != "")
{
#region //初始化用于编写公式的可选字段列表
TF_FORM formObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, txtFORM_ID.Value);
if (formObj != null && formObj.M_FORM_ID > 0)
{
TF_TB_FIELD numccc = new TF_TB_FIELD();
numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString());
numccc.TB_ID = formObj.TB_ID;
List <TF_TB_FIELD> fieldList = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), numccc);
if (fieldList != null && fieldList.Count > 0)
{
StringBuilder sbnumcols = new StringBuilder();
fieldList.ForEach(f => {
sbnumcols.Append("<a data='" + f.FIELD_NAME + "' onclick='selColToCalInput(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>");
});
litNumberFields.Text = sbnumcols.ToString();
if (keyid != "")
{
dlCAL_FORMULA.Style.Value = "display:block"; //.Visible = true;
}
//dlCAL_FORMULA.Visible = true;
}
}
#endregion
#region //初始化综合可以用于作为主表某个字段的值的字段列表,这些字段来自明细表
if (formObj != null && formObj.M_FORM_ID > 0)
{
formObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, formObj.M_FORM_ID);
if (formObj != null)
{
TF_TB_FIELD numccc = new TF_TB_FIELD();
numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString());
numccc.TB_ID = formObj.TB_ID;
TF_TABLE tbObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, formObj.TB_ID);
List <TF_TB_FIELD> fieldList = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), numccc);
if (fieldList != null && fieldList.Count > 0)
{
StringBuilder sbnumcols = new StringBuilder();
fieldList.ForEach(f =>
{
sbnumcols.Append("<a class='cansel' data='" + tbObj.TB_NAME + "." + f.FIELD_NAME + "' onclick='selColToSum(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>");
});
litSUM_FIELD_ID.Text = sbnumcols.ToString();
if (keyid != "")
{
dlSUM_FIELD_ID.Style.Value = "display:block"; //.Visible = true;
}
//dlSUM_FIELD_ID.Visible = true;
}
}
}
#endregion
}
#region //初始化控件类型
TF_CTRL_TYPE ctrlCond = new TF_CTRL_TYPE();
ctrlCond.OrderBy(TF_CTRL_TYPE.Attribute.SORT_NO, Order.Asc);
DataTable dtCtrl = BLLTable <TF_CTRL_TYPE> .SelectForDataTable(new TF_CTRL_TYPE(), ctrlCond);
ViewState["CTRL_TYPE"] = valObj.CTRL_TYPE;
DataView dv1 = new DataView();
dv1.Table = dtCtrl;
dv1.RowFilter = "P_CTRL_TYPE='0'";
dv1.Sort = "SORT_NO asc";
for (int i = 0; i < dv1.Count; i++)
{
litCTRL_TYPE.Text += "<optgroup label='" + dv1[i]["CTRL_NAME"].ToString() + "'>";
DataView dv2 = new DataView();
dv2.Table = dtCtrl;
dv2.RowFilter = "P_CTRL_TYPE='" + dv1[i]["CTRL_TYPE"].ToString() + "'";
dv2.Sort = "SORT_NO asc";
for (int a = 0; a < dv2.Count; a++)
{
if (valObj != null && valObj.CTRL_TYPE == dv2[a]["CTRL_TYPE"].ToString())
{
litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "' selected='selected'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>";
}
else
{
litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>";
}
}
litCTRL_TYPE.Text += "</optgroup>";
}
#endregion
//}
//catch (Exception ex)
//{
// litWarn.Text = ex.Message;
//}
}
}
