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