protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<V_SYS_BILL_COL_SYN>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelCOL_SYNID"] != null)
{
int re = BLLTable<V_SYS_BILL_COL_SYN>.Factory(conn).Delete(V_SYS_BILL_COL_SYN.Attribute.COL_SYNID, Request["DelCOL_SYNID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
V_SYS_BILL_COL_SYN cond = new V_SYS_BILL_COL_SYN();
cond.In(V_SYS_BILL_COL_SYN.Attribute.COL_SYNID, Request["DelKeyIDS"]);
int re = BLLTable<V_SYS_BILL_COL_SYN>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
V_SYS_BILL_COL_SYN val = new V_SYS_BILL_COL_SYN();
val.COL_SYNID = 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<V_SYS_BILL_COL_SYN>.Factory(conn).Update(val, V_SYS_BILL_COL_SYN.Attribute.COL_SYNID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["COL_SYNID"]))
{
keyid = Request["COL_SYNID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
txtADDTIME.Value = (DateTime.Now).ToString("yyyy-MM-dd");
txtEDITIME.Value = (DateTime.Now).ToString("yyyy-MM-dd");
this.txtCOL_SYNID.Disabled = true; this.txtCOL_SYNID.Value = "0";
this.txtCOL_SYNID.Attributes["class"] = "dis";
try
{
if (keyid != "")
{
valObj = BLLTable<V_SYS_BILL_COL_SYN>.Factory(conn).GetRowData(V_SYS_BILL_COL_SYN.Attribute.COL_SYNID, keyid);
if(valObj==null) return ;
txtCOL_SYNID.Value = Convert.ToString(valObj.COL_SYNID);//Convert.ToInt32
txtBILL_ID.Value = Convert.ToString(valObj.BILL_ID);//Convert.ToInt32
txtCOL_ID.Value = Convert.ToString(valObj.COL_ID);//Convert.ToInt32
txtDB_SRC.Value = Convert.ToString(valObj.DB_SRC);//Convert.ToString
txtTABLE_NAME.Value = Convert.ToString(valObj.TABLE_NAME);//Convert.ToString
txtCOL_NAME.Value = Convert.ToString(valObj.COL_NAME);//Convert.ToString
txtCOL_NOTE.Value = Convert.ToString(valObj.COL_NOTE);//Convert.ToString
txtDATA_TYPE.Value = Convert.ToString(valObj.DATA_TYPE);//Convert.ToString
txtDATA_LEN.Value = Convert.ToString(valObj.DATA_LEN);//Convert.ToInt32
txtDATA_ACC.Value = Convert.ToString(valObj.DATA_ACC);//Convert.ToInt32
txtIS_AUTO.Value = Convert.ToString(valObj.IS_AUTO);//Convert.ToString
txtISPK.Value = Convert.ToString(valObj.ISPK);//Convert.ToString
txtDVAL.Value = Convert.ToString(valObj.DVAL);//Convert.ToString
txtPK_VALCODE.Value = Convert.ToString(valObj.PK_VALCODE);//Convert.ToString
txtISFK.Value = Convert.ToString(valObj.ISFK);//Convert.ToString
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtFK_NAME.Value = Convert.ToString(valObj.FK_NAME);//Convert.ToString
txtFK_SHOW.Value = Convert.ToString(valObj.FK_SHOW);//Convert.ToString
txtDISPLAY_NAME.Value = Convert.ToString(valObj.DISPLAY_NAME);//Convert.ToString
txtTITLE.Value = Convert.ToString(valObj.TITLE);//Convert.ToString
txtBILL_ROW_FORMULAR.Value = Convert.ToString(valObj.BILL_ROW_FORMULAR);//Convert.ToString
txtBILL_COL_FORMULAR.Value = Convert.ToString(valObj.BILL_COL_FORMULAR);//Convert.ToString
txtBILL_ISHEADER.Value = Convert.ToString(valObj.BILL_ISHEADER);//Convert.ToString
txtBILL_HERDERWIDTH.Value = Convert.ToString(valObj.BILL_HERDERWIDTH);//Convert.ToInt32
txtFORM_CHECKTYPE.Value = Convert.ToString(valObj.FORM_CHECKTYPE);//Convert.ToString
txtBILL_AFTREDTL.Value = Convert.ToString(valObj.BILL_AFTREDTL);//Convert.ToString
txtFORM_CTRL_ID.Value = Convert.ToString(valObj.FORM_CTRL_ID);//Convert.ToInt32
txtFORM_SHOW.Value = Convert.ToString(valObj.FORM_SHOW);//Convert.ToString
txtFORM_NEED.Value = Convert.ToString(valObj.FORM_NEED);//Convert.ToString
txtFORM_MIN.Value = Convert.ToString(valObj.FORM_MIN);//Convert.ToString
txtFORM_MAX.Value = Convert.ToString(valObj.FORM_MAX);//Convert.ToString
txtFORM_ONEROW.Value = Convert.ToString(valObj.FORM_ONEROW);//Convert.ToString
txtSEARCH_INBILL.Value = Convert.ToString(valObj.SEARCH_INBILL);//Convert.ToString
txtFORM_CTRLWIDTH.Value = Convert.ToString(valObj.FORM_CTRLWIDTH);//Convert.ToInt32
txtSEARCH_TYPE.Value = Convert.ToString(valObj.SEARCH_TYPE);//Convert.ToString
txtSEARCH_FORMULAR.Value = Convert.ToString(valObj.SEARCH_FORMULAR);//Convert.ToString
txtSTATUS.Value = Convert.ToString(valObj.STATUS);//Convert.ToString
txtSEL_TB_COL.Value = Convert.ToString(valObj.SEL_TB_COL);//Convert.ToString
txtIS_COL_EXISTS.Value = Convert.ToString(valObj.IS_COL_EXISTS);//Convert.ToString
txtBILL_NAME.Value = Convert.ToString(valObj.BILL_NAME);//Convert.ToString
txtBILL_TYPE.Value = Convert.ToString(valObj.BILL_TYPE);//Convert.ToString
txtBILL_SQL.Value = Convert.ToString(valObj.BILL_SQL);//Convert.ToString
txtADDTIME.Value = (valObj.ADDTIME == DateTime.MinValue) ? "" : valObj.ADDTIME.ToString("yyyy-MM-dd");
txtEDITIME.Value = (valObj.EDITIME == DateTime.MinValue) ? "" : valObj.EDITIME.ToString("yyyy-MM-dd");
txtADDER.Value = Convert.ToString(valObj.ADDER);//Convert.ToString
txtExpr1.Value = Convert.ToString(valObj.Expr1);//Convert.ToString
txtP_BILL_ID.Value = Convert.ToString(valObj.P_BILL_ID);//Convert.ToInt32
txtBILL_STATUS.Value = Convert.ToString(valObj.BILL_STATUS);//Convert.ToString
txtCONN_SOURCE.Value = Convert.ToString(valObj.CONN_SOURCE);//Convert.ToString
txtIS_TABLE_EXISTS.Value = Convert.ToString(valObj.IS_TABLE_EXISTS);//Convert.ToString
txtKEYS.Value = Convert.ToString(valObj.KEYS);//Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
V_SYS_BILL_COL_SYN valObj = new V_SYS_BILL_COL_SYN();
if(txtCOL_SYNID.Value !="" )
valObj.COL_SYNID = Convert.ToInt32(txtCOL_SYNID.Value);
if(txtBILL_ID.Value !="" )
valObj.BILL_ID = Convert.ToInt32(txtBILL_ID.Value);
if(txtCOL_ID.Value !="" )
valObj.COL_ID = Convert.ToInt32(txtCOL_ID.Value);
if(txtDB_SRC.Value !="" )
valObj.DB_SRC = Convert.ToString(txtDB_SRC.Value);
if(txtTABLE_NAME.Value !="" )
valObj.TABLE_NAME = Convert.ToString(txtTABLE_NAME.Value);
if(txtCOL_NAME.Value !="" )
valObj.COL_NAME = Convert.ToString(txtCOL_NAME.Value);
if(txtCOL_NOTE.Value !="" )
valObj.COL_NOTE = Convert.ToString(txtCOL_NOTE.Value);
if(txtDATA_TYPE.Value !="" )
valObj.DATA_TYPE = Convert.ToString(txtDATA_TYPE.Value);
if(txtDATA_LEN.Value !="" )
valObj.DATA_LEN = Convert.ToInt32(txtDATA_LEN.Value);
if(txtDATA_ACC.Value !="" )
valObj.DATA_ACC = Convert.ToInt32(txtDATA_ACC.Value);
if(txtIS_AUTO.Value !="" )
valObj.IS_AUTO = Convert.ToString(txtIS_AUTO.Value);
if(txtISPK.Value !="" )
valObj.ISPK = Convert.ToString(txtISPK.Value);
if(txtDVAL.Value !="" )
valObj.DVAL = Convert.ToString(txtDVAL.Value);
if(txtPK_VALCODE.Value !="" )
valObj.PK_VALCODE = Convert.ToString(txtPK_VALCODE.Value);
if(txtISFK.Value !="" )
valObj.ISFK = Convert.ToString(txtISFK.Value);
if(txtSORT_NO.Value !="" )
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
if(txtFK_NAME.Value !="" )
valObj.FK_NAME = Convert.ToString(txtFK_NAME.Value);
if(txtFK_SHOW.Value !="" )
valObj.FK_SHOW = Convert.ToString(txtFK_SHOW.Value);
if(txtDISPLAY_NAME.Value !="" )
valObj.DISPLAY_NAME = Convert.ToString(txtDISPLAY_NAME.Value);
if(txtTITLE.Value !="" )
valObj.TITLE = Convert.ToString(txtTITLE.Value);
if(txtBILL_ROW_FORMULAR.Value !="" )
valObj.BILL_ROW_FORMULAR = Convert.ToString(txtBILL_ROW_FORMULAR.Value);
if(txtBILL_COL_FORMULAR.Value !="" )
valObj.BILL_COL_FORMULAR = Convert.ToString(txtBILL_COL_FORMULAR.Value);
if(txtBILL_ISHEADER.Value !="" )
valObj.BILL_ISHEADER = Convert.ToString(txtBILL_ISHEADER.Value);
if(txtBILL_HERDERWIDTH.Value !="" )
valObj.BILL_HERDERWIDTH = Convert.ToInt32(txtBILL_HERDERWIDTH.Value);
if(txtFORM_CHECKTYPE.Value !="" )
valObj.FORM_CHECKTYPE = Convert.ToString(txtFORM_CHECKTYPE.Value);
if(txtBILL_AFTREDTL.Value !="" )
valObj.BILL_AFTREDTL = Convert.ToString(txtBILL_AFTREDTL.Value);
if(txtFORM_CTRL_ID.Value !="" )
valObj.FORM_CTRL_ID = Convert.ToInt32(txtFORM_CTRL_ID.Value);
if(txtFORM_SHOW.Value !="" )
valObj.FORM_SHOW = Convert.ToString(txtFORM_SHOW.Value);
if(txtFORM_NEED.Value !="" )
valObj.FORM_NEED = Convert.ToString(txtFORM_NEED.Value);
if(txtFORM_MIN.Value !="" )
valObj.FORM_MIN = Convert.ToString(txtFORM_MIN.Value);
if(txtFORM_MAX.Value !="" )
valObj.FORM_MAX = Convert.ToString(txtFORM_MAX.Value);
if(txtFORM_ONEROW.Value !="" )
valObj.FORM_ONEROW = Convert.ToString(txtFORM_ONEROW.Value);
if(txtSEARCH_INBILL.Value !="" )
valObj.SEARCH_INBILL = Convert.ToString(txtSEARCH_INBILL.Value);
if(txtFORM_CTRLWIDTH.Value !="" )
valObj.FORM_CTRLWIDTH = Convert.ToInt32(txtFORM_CTRLWIDTH.Value);
if(txtSEARCH_TYPE.Value !="" )
valObj.SEARCH_TYPE = Convert.ToString(txtSEARCH_TYPE.Value);
if(txtSEARCH_FORMULAR.Value !="" )
valObj.SEARCH_FORMULAR = Convert.ToString(txtSEARCH_FORMULAR.Value);
if(txtSTATUS.Value !="" )
valObj.STATUS = Convert.ToString(txtSTATUS.Value);
if(txtSEL_TB_COL.Value !="" )
valObj.SEL_TB_COL = Convert.ToString(txtSEL_TB_COL.Value);
if(txtIS_COL_EXISTS.Value !="" )
valObj.IS_COL_EXISTS = Convert.ToString(txtIS_COL_EXISTS.Value);
if(txtBILL_NAME.Value !="" )
valObj.BILL_NAME = Convert.ToString(txtBILL_NAME.Value);
if(txtBILL_TYPE.Value !="" )
valObj.BILL_TYPE = Convert.ToString(txtBILL_TYPE.Value);
if(txtBILL_SQL.Value !="" )
valObj.BILL_SQL = Convert.ToString(txtBILL_SQL.Value);
if(txtADDTIME.Value !="" )
valObj.ADDTIME = Convert.ToDateTime(txtADDTIME.Value);
if(txtEDITIME.Value !="" )
valObj.EDITIME = Convert.ToDateTime(txtEDITIME.Value);
if(txtADDER.Value !="" )
valObj.ADDER = Convert.ToString(txtADDER.Value);
if(txtExpr1.Value !="" )
valObj.Expr1 = Convert.ToString(txtExpr1.Value);
if(txtP_BILL_ID.Value !="" )
valObj.P_BILL_ID = Convert.ToInt32(txtP_BILL_ID.Value);
if(txtBILL_STATUS.Value !="" )
valObj.BILL_STATUS = Convert.ToString(txtBILL_STATUS.Value);
if(txtCONN_SOURCE.Value !="" )
valObj.CONN_SOURCE = Convert.ToString(txtCONN_SOURCE.Value);
if(txtIS_TABLE_EXISTS.Value !="" )
valObj.IS_TABLE_EXISTS = Convert.ToString(txtIS_TABLE_EXISTS.Value);
if(txtKEYS.Value !="" )
valObj.KEYS = Convert.ToString(txtKEYS.Value);
if (keyid != "")
{
valObj.COL_SYNID = Convert.ToInt32(keyid);
count = BLLTable<V_SYS_BILL_COL_SYN>.Factory(conn).Update(valObj, V_SYS_BILL_COL_SYN.Attribute.COL_SYNID);
}
else
{
count = BLLTable<V_SYS_BILL_COL_SYN>.Factory(conn).Insert(valObj, V_SYS_BILL_COL_SYN.Attribute.COL_SYNID);
keyid = valObj.COL_SYNID.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("}");
if (ViewState["sbData"] == null)
{
ViewState["sbData"] = sbData.ToString();
}
else {
ViewState["sbData"] += ","+sbData.ToString();
}
Button btn = (Button)sender;
if (btn.ID.IndexOf("btnOK")!=-1)
{
if (ViewState["sbData"] == null)
{
string dataStr = "[" + ViewState["sbData"] .ToString()+ "]";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}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
{
txtCOL_SYNID.Value ="";
txtBILL_ID.Value ="";
txtCOL_ID.Value ="";
txtDB_SRC.Value ="";
txtTABLE_NAME.Value ="";
txtCOL_NAME.Value ="";
txtCOL_NOTE.Value ="";
txtDATA_TYPE.Value ="";
txtDATA_LEN.Value ="";
txtDATA_ACC.Value ="";
txtIS_AUTO.Value ="";
txtISPK.Value ="";
txtDVAL.Value ="";
txtPK_VALCODE.Value ="";
txtISFK.Value ="";
txtSORT_NO.Value ="";
txtFK_NAME.Value ="";
txtFK_SHOW.Value ="";
txtDISPLAY_NAME.Value ="";
txtTITLE.Value ="";
txtBILL_ROW_FORMULAR.Value ="";
txtBILL_COL_FORMULAR.Value ="";
txtBILL_ISHEADER.Value ="";
txtBILL_HERDERWIDTH.Value ="";
txtFORM_CHECKTYPE.Value ="";
txtBILL_AFTREDTL.Value ="";
txtFORM_CTRL_ID.Value ="";
txtFORM_SHOW.Value ="";
txtFORM_NEED.Value ="";
txtFORM_MIN.Value ="";
txtFORM_MAX.Value ="";
txtFORM_ONEROW.Value ="";
txtSEARCH_INBILL.Value ="";
txtFORM_CTRLWIDTH.Value ="";
txtSEARCH_TYPE.Value ="";
txtSEARCH_FORMULAR.Value ="";
txtSTATUS.Value ="";
txtSEL_TB_COL.Value ="";
txtIS_COL_EXISTS.Value ="";
txtBILL_NAME.Value ="";
txtBILL_TYPE.Value ="";
txtBILL_SQL.Value ="";
txtADDTIME.Value ="";
txtEDITIME.Value ="";
txtADDER.Value ="";
txtExpr1.Value ="";
txtP_BILL_ID.Value ="";
txtBILL_STATUS.Value ="";
txtCONN_SOURCE.Value ="";
txtIS_TABLE_EXISTS.Value ="";
txtKEYS.Value ="";
}
}
}
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["COL_SYNID"]))
{
valObj = BLLTable<V_SYS_BILL_COL_SYN>.Factory(conn).GetRowData(V_SYS_BILL_COL_SYN.Attribute.COL_SYNID, Request["COL_SYNID"]);
if(valObj==null) return ;
txtCOL_SYNID.Text = Convert.ToString(valObj.COL_SYNID);//Convert.ToInt32
txtBILL_ID.Text = Convert.ToString(valObj.BILL_ID);//Convert.ToInt32
txtCOL_ID.Text = Convert.ToString(valObj.COL_ID);//Convert.ToInt32
txtDB_SRC.Text = Convert.ToString(valObj.DB_SRC);//Convert.ToString
txtTABLE_NAME.Text = Convert.ToString(valObj.TABLE_NAME);//Convert.ToString
txtCOL_NAME.Text = Convert.ToString(valObj.COL_NAME);//Convert.ToString
txtCOL_NOTE.Text = Convert.ToString(valObj.COL_NOTE);//Convert.ToString
txtDATA_TYPE.Text = Convert.ToString(valObj.DATA_TYPE);//Convert.ToString
txtDATA_LEN.Text = Convert.ToString(valObj.DATA_LEN);//Convert.ToInt32
txtDATA_ACC.Text = Convert.ToString(valObj.DATA_ACC);//Convert.ToInt32
txtIS_AUTO.Text = Convert.ToString(valObj.IS_AUTO);//Convert.ToString
txtISPK.Text = Convert.ToString(valObj.ISPK);//Convert.ToString
txtDVAL.Text = Convert.ToString(valObj.DVAL);//Convert.ToString
txtPK_VALCODE.Text = Convert.ToString(valObj.PK_VALCODE);//Convert.ToString
txtISFK.Text = Convert.ToString(valObj.ISFK);//Convert.ToString
txtSORT_NO.Text = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtFK_NAME.Text = Convert.ToString(valObj.FK_NAME);//Convert.ToString
txtFK_SHOW.Text = Convert.ToString(valObj.FK_SHOW);//Convert.ToString
txtDISPLAY_NAME.Text = Convert.ToString(valObj.DISPLAY_NAME);//Convert.ToString
txtTITLE.Text = Convert.ToString(valObj.TITLE);//Convert.ToString
txtBILL_ROW_FORMULAR.Text = Convert.ToString(valObj.BILL_ROW_FORMULAR);//Convert.ToString
txtBILL_COL_FORMULAR.Text = Convert.ToString(valObj.BILL_COL_FORMULAR);//Convert.ToString
txtBILL_ISHEADER.Text = Convert.ToString(valObj.BILL_ISHEADER);//Convert.ToString
txtBILL_HERDERWIDTH.Text = Convert.ToString(valObj.BILL_HERDERWIDTH);//Convert.ToInt32
txtFORM_CHECKTYPE.Text = Convert.ToString(valObj.FORM_CHECKTYPE);//Convert.ToString
txtBILL_AFTREDTL.Text = Convert.ToString(valObj.BILL_AFTREDTL);//Convert.ToString
txtFORM_CTRL_ID.Text = Convert.ToString(valObj.FORM_CTRL_ID);//Convert.ToInt32
txtFORM_SHOW.Text = Convert.ToString(valObj.FORM_SHOW);//Convert.ToString
txtFORM_NEED.Text = Convert.ToString(valObj.FORM_NEED);//Convert.ToString
txtFORM_MIN.Text = Convert.ToString(valObj.FORM_MIN);//Convert.ToString
txtFORM_MAX.Text = Convert.ToString(valObj.FORM_MAX);//Convert.ToString
txtFORM_ONEROW.Text = Convert.ToString(valObj.FORM_ONEROW);//Convert.ToString
txtSEARCH_INBILL.Text = Convert.ToString(valObj.SEARCH_INBILL);//Convert.ToString
txtFORM_CTRLWIDTH.Text = Convert.ToString(valObj.FORM_CTRLWIDTH);//Convert.ToInt32
txtSEARCH_TYPE.Text = Convert.ToString(valObj.SEARCH_TYPE);//Convert.ToString
txtSEARCH_FORMULAR.Text = Convert.ToString(valObj.SEARCH_FORMULAR);//Convert.ToString
txtSTATUS.Text = Convert.ToString(valObj.STATUS);//Convert.ToString
txtSEL_TB_COL.Text = Convert.ToString(valObj.SEL_TB_COL);//Convert.ToString
txtIS_COL_EXISTS.Text = Convert.ToString(valObj.IS_COL_EXISTS);//Convert.ToString
txtBILL_NAME.Text = Convert.ToString(valObj.BILL_NAME);//Convert.ToString
txtBILL_TYPE.Text = Convert.ToString(valObj.BILL_TYPE);//Convert.ToString
txtBILL_SQL.Text = Convert.ToString(valObj.BILL_SQL);//Convert.ToString
txtADDTIME.Text = (valObj.ADDTIME == DateTime.MinValue) ? "" : valObj.ADDTIME.ToString("yyyy-MM-dd HH:mm");
txtEDITIME.Text = (valObj.EDITIME == DateTime.MinValue) ? "" : valObj.EDITIME.ToString("yyyy-MM-dd HH:mm");
txtADDER.Text = Convert.ToString(valObj.ADDER);//Convert.ToString
txtExpr1.Text = Convert.ToString(valObj.Expr1);//Convert.ToString
txtP_BILL_ID.Text = Convert.ToString(valObj.P_BILL_ID);//Convert.ToInt32
txtBILL_STATUS.Text = Convert.ToString(valObj.BILL_STATUS);//Convert.ToString
txtCONN_SOURCE.Text = Convert.ToString(valObj.CONN_SOURCE);//Convert.ToString
txtIS_TABLE_EXISTS.Text = Convert.ToString(valObj.IS_TABLE_EXISTS);//Convert.ToString
txtKEYS.Text = Convert.ToString(valObj.KEYS);//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 btnFind_Click(object sender, EventArgs e)
{
condObj = new V_SYS_BILL_COL_SYN();
if(txtCOL_SYNID.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.COL_SYNID, Convert.ToInt32(txtCOL_SYNID.Value));
if(txtBILL_ID.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_ID, Convert.ToInt32(txtBILL_ID.Value));
if(txtCOL_ID.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.COL_ID, Convert.ToInt32(txtCOL_ID.Value));
if(txtDB_SRC.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.DB_SRC, Convert.ToString(txtDB_SRC.Value));
if(txtTABLE_NAME.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.TABLE_NAME, Convert.ToString(txtTABLE_NAME.Value));
if(txtCOL_NAME.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.COL_NAME, Convert.ToString(txtCOL_NAME.Value));
if(txtCOL_NOTE.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.COL_NOTE, Convert.ToString(txtCOL_NOTE.Value));
if(txtDATA_TYPE.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.DATA_TYPE, Convert.ToString(txtDATA_TYPE.Value));
if(txtDATA_LEN.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.DATA_LEN, Convert.ToInt32(txtDATA_LEN.Value));
if(txtDATA_ACC.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.DATA_ACC, Convert.ToInt32(txtDATA_ACC.Value));
if(txtIS_AUTO.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.IS_AUTO, Convert.ToString(txtIS_AUTO.Value));
if(txtISPK.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.ISPK, Convert.ToString(txtISPK.Value));
if(txtDVAL.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.DVAL, Convert.ToString(txtDVAL.Value));
if(txtPK_VALCODE.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.PK_VALCODE, Convert.ToString(txtPK_VALCODE.Value));
if(txtISFK.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.ISFK, Convert.ToString(txtISFK.Value));
if(txtSORT_NO.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
if(txtFK_NAME.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FK_NAME, Convert.ToString(txtFK_NAME.Value));
if(txtFK_SHOW.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FK_SHOW, Convert.ToString(txtFK_SHOW.Value));
if(txtDISPLAY_NAME.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.DISPLAY_NAME, Convert.ToString(txtDISPLAY_NAME.Value));
if(txtTITLE.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.TITLE, Convert.ToString(txtTITLE.Value));
if(txtBILL_ROW_FORMULAR.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_ROW_FORMULAR, Convert.ToString(txtBILL_ROW_FORMULAR.Value));
if(txtBILL_COL_FORMULAR.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_COL_FORMULAR, Convert.ToString(txtBILL_COL_FORMULAR.Value));
if(txtBILL_ISHEADER.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_ISHEADER, Convert.ToString(txtBILL_ISHEADER.Value));
if(txtBILL_HERDERWIDTH.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_HERDERWIDTH, Convert.ToInt32(txtBILL_HERDERWIDTH.Value));
if(txtFORM_CHECKTYPE.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FORM_CHECKTYPE, Convert.ToString(txtFORM_CHECKTYPE.Value));
if(txtBILL_AFTREDTL.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_AFTREDTL, Convert.ToString(txtBILL_AFTREDTL.Value));
if(txtFORM_CTRL_ID.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FORM_CTRL_ID, Convert.ToInt32(txtFORM_CTRL_ID.Value));
if(txtFORM_SHOW.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FORM_SHOW, Convert.ToString(txtFORM_SHOW.Value));
if(txtFORM_NEED.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FORM_NEED, Convert.ToString(txtFORM_NEED.Value));
if(txtFORM_MIN.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FORM_MIN, Convert.ToString(txtFORM_MIN.Value));
if(txtFORM_MAX.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FORM_MAX, Convert.ToString(txtFORM_MAX.Value));
if(txtFORM_ONEROW.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FORM_ONEROW, Convert.ToString(txtFORM_ONEROW.Value));
if(txtSEARCH_INBILL.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.SEARCH_INBILL, Convert.ToString(txtSEARCH_INBILL.Value));
if(txtFORM_CTRLWIDTH.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.FORM_CTRLWIDTH, Convert.ToInt32(txtFORM_CTRLWIDTH.Value));
if(txtSEARCH_TYPE.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.SEARCH_TYPE, Convert.ToString(txtSEARCH_TYPE.Value));
if(txtSEARCH_FORMULAR.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.SEARCH_FORMULAR, Convert.ToString(txtSEARCH_FORMULAR.Value));
if(txtSTATUS.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.STATUS, Convert.ToString(txtSTATUS.Value));
if(txtSEL_TB_COL.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.SEL_TB_COL, Convert.ToString(txtSEL_TB_COL.Value));
if(txtIS_COL_EXISTS.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.IS_COL_EXISTS, Convert.ToString(txtIS_COL_EXISTS.Value));
if(txtBILL_NAME.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_NAME, Convert.ToString(txtBILL_NAME.Value));
if(txtBILL_TYPE.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_TYPE, Convert.ToString(txtBILL_TYPE.Value));
if(txtBILL_SQL.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_SQL, Convert.ToString(txtBILL_SQL.Value));
if(txtADDTIME.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value));
if(txtEDITIME.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.EDITIME, Convert.ToDateTime(txtEDITIME.Value));
if(txtADDER.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.ADDER, Convert.ToString(txtADDER.Value));
if(txtExpr1.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.Expr1, Convert.ToString(txtExpr1.Value));
if(txtP_BILL_ID.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.P_BILL_ID, Convert.ToInt32(txtP_BILL_ID.Value));
if(txtBILL_STATUS.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.BILL_STATUS, Convert.ToString(txtBILL_STATUS.Value));
if(txtCONN_SOURCE.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.CONN_SOURCE, Convert.ToString(txtCONN_SOURCE.Value));
if(txtIS_TABLE_EXISTS.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.IS_TABLE_EXISTS, Convert.ToString(txtIS_TABLE_EXISTS.Value));
if(txtKEYS.Value !="" )
condObj.Like(V_SYS_BILL_COL_SYN.Attribute.KEYS, Convert.ToString(txtKEYS.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
private void BindList(V_SYS_BILL_COL_SYN condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(V_SYS_BILL_COL_SYN.Attribute.COL_SYNID, Order.Desc);
#region//����Ȩ������
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable<V_SYS_BILL_COL_SYN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void btnSetPageSize_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageSize.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<V_SYS_BILL_COL_SYN>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
/// <summary></summary>
public override ITable af_GetOptionValueSchema()
{
V_SYS_BILL_COL_SYN value = new V_SYS_BILL_COL_SYN();
if(BLLTable.IsExistOptionValue(this.TableName(),"COL_SYNID"))
value.col_synid_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_ID"))
value.bill_id_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"COL_ID"))
value.col_id_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"DB_SRC"))
value.db_src_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"TABLE_NAME"))
value.table_name_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"COL_NAME"))
value.col_name_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"COL_NOTE"))
value.col_note_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"DATA_TYPE"))
value.data_type_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"DATA_LEN"))
value.data_len_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"DATA_ACC"))
value.data_acc_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"IS_AUTO"))
value.is_auto_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"ISPK"))
value.ispk_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"DVAL"))
value.dval_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"PK_VALCODE"))
value.pk_valcode_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"ISFK"))
value.isfk_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"SORT_NO"))
value.sort_no_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FK_NAME"))
value.fk_name_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FK_SHOW"))
value.fk_show_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"DISPLAY_NAME"))
value.display_name_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"TITLE"))
value.title_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_ROW_FORMULAR"))
value.bill_row_formular_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_COL_FORMULAR"))
value.bill_col_formular_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_ISHEADER"))
value.bill_isheader_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_HERDERWIDTH"))
value.bill_herderwidth_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FORM_CHECKTYPE"))
value.form_checktype_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_AFTREDTL"))
value.bill_aftredtl_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FORM_CTRL_ID"))
value.form_ctrl_id_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FORM_SHOW"))
value.form_show_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FORM_NEED"))
value.form_need_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FORM_MIN"))
value.form_min_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FORM_MAX"))
value.form_max_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FORM_ONEROW"))
value.form_onerow_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"SEARCH_INBILL"))
value.search_inbill_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"FORM_CTRLWIDTH"))
value.form_ctrlwidth_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"SEARCH_TYPE"))
value.search_type_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"SEARCH_FORMULAR"))
value.search_formular_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"STATUS"))
value.status_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"SEL_TB_COL"))
value.sel_tb_col_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"IS_COL_EXISTS"))
value.is_col_exists_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_NAME"))
value.bill_name_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_TYPE"))
value.bill_type_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_SQL"))
value.bill_sql_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"ADDTIME"))
value.addtime_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"EDITIME"))
value.editime_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"ADDER"))
value.adder_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"Expr1"))
value.expr1_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"P_BILL_ID"))
value.p_bill_id_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"BILL_STATUS"))
value.bill_status_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"CONN_SOURCE"))
value.conn_source_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"IS_TABLE_EXISTS"))
value.is_table_exists_initialized = true;
if(BLLTable.IsExistOptionValue(this.TableName(),"KEYS"))
value.keys_initialized = true;
return value;
}
/// <summary>V_SYS_BILL_COL_SYN ���һ��ʵ��</summary>
public static V_SYS_BILL_COL_SYN GetOneInstance()
{
V_SYS_BILL_COL_SYN value = new V_SYS_BILL_COL_SYN();
return value;
}