protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new SYS_BILL_COLITEM();
if(txtITEM_ID.Value !="" )
condObj.Like(SYS_BILL_COLITEM.Attribute.ITEM_ID, Convert.ToInt32(txtITEM_ID.Value));
if(txtCOL_ID.Value !="" )
condObj.Like(SYS_BILL_COLITEM.Attribute.COL_ID, Convert.ToInt32(txtCOL_ID.Value));
if(txtVAL.Value !="" )
condObj.Like(SYS_BILL_COLITEM.Attribute.VAL, Convert.ToString(txtVAL.Value));
if(txtTXT.Value !="" )
condObj.Like(SYS_BILL_COLITEM.Attribute.TXT, Convert.ToString(txtTXT.Value));
if(txtSHOW_COL_REAL.Value !="" )
condObj.Like(SYS_BILL_COLITEM.Attribute.SHOW_COL_REAL, Convert.ToString(txtSHOW_COL_REAL.Value));
listObj = BLLTable<SYS_BILL_COLITEM>.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;
}
private void BindList(SYS_BILL_COLITEM condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(SYS_BILL_COLITEM.Attribute.ITEM_ID, Order.Desc);
condObj.COL_ID = pid;
listObj = BLLTable<SYS_BILL_COLITEM>.Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelITEM_ID"] != null)
{
int re = BLLTable <SYS_BILL_COLITEM> .Factory(conn).Delete(SYS_BILL_COLITEM.Attribute.ITEM_ID, Request["DelITEM_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
SYS_BILL_COLITEM cond = new SYS_BILL_COLITEM();
cond.In(SYS_BILL_COLITEM.Attribute.ITEM_ID, Request["DelKeyIDS"]);
int re = BLLTable <SYS_BILL_COLITEM> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
SYS_BILL_COLITEM val = new SYS_BILL_COLITEM();
val.ITEM_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 <SYS_BILL_COLITEM> .Factory(conn).Update(val, SYS_BILL_COLITEM.Attribute.ITEM_ID);
Response.Write("修改用户信息成功");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "±à¼";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["ITEM_ID"]))
{
keyid = Request["ITEM_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["ColID"]))
{
colid = int.Parse(Request["ColID"]);
}
if (!IsPostBack)
{
try
{
if (keyid != "")
{
valObj = BLLTable <SYS_BILL_COLITEM> .Factory(conn).GetRowData(SYS_BILL_COLITEM.Attribute.ITEM_ID, keyid);
if (valObj == null)
{
return;
}
txtITEM_ID.Value = Convert.ToString(valObj.ITEM_ID);//Convert.ToInt32
//txtCOL_ID.Value = Convert.ToString(valObj.COL_ID);//Convert.ToInt32
txtVAL.Value = Convert.ToString(valObj.VAL); //Convert.ToString
txtTXT.Value = Convert.ToString(valObj.TXT); //Convert.ToString
txtSHOW_COL_REAL.Value = Convert.ToString(valObj.SHOW_COL_REAL); //Convert.ToString
if (!string.IsNullOrEmpty(valObj.VAL))
{
ckVal.Checked = true;
}
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "_valChg();", false);
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
private void BindList(SYS_BILL_COLITEM condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(SYS_BILL_COLITEM.Attribute.ITEM_ID, Order.Desc);
}
condObj.COL_ID = pid;
listObj = BLLTable <SYS_BILL_COLITEM> .Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelITEM_ID"] != null)
{
int re = BLLTable<SYS_BILL_COLITEM>.Factory(conn).Delete(SYS_BILL_COLITEM.Attribute.ITEM_ID, Request["DelITEM_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
SYS_BILL_COLITEM cond = new SYS_BILL_COLITEM();
cond.In(SYS_BILL_COLITEM.Attribute.ITEM_ID, Request["DelKeyIDS"]);
int re = BLLTable<SYS_BILL_COLITEM>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
SYS_BILL_COLITEM val = new SYS_BILL_COLITEM();
val.ITEM_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<SYS_BILL_COLITEM>.Factory(conn).Update(val, SYS_BILL_COLITEM.Attribute.ITEM_ID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new SYS_BILL_COLITEM();
if (txtITEM_ID.Value != "")
{
condObj.Like(SYS_BILL_COLITEM.Attribute.ITEM_ID, Convert.ToInt32(txtITEM_ID.Value));
}
if (txtCOL_ID.Value != "")
{
condObj.Like(SYS_BILL_COLITEM.Attribute.COL_ID, Convert.ToInt32(txtCOL_ID.Value));
}
if (txtVAL.Value != "")
{
condObj.Like(SYS_BILL_COLITEM.Attribute.VAL, Convert.ToString(txtVAL.Value));
}
if (txtTXT.Value != "")
{
condObj.Like(SYS_BILL_COLITEM.Attribute.TXT, Convert.ToString(txtTXT.Value));
}
if (txtSHOW_COL_REAL.Value != "")
{
condObj.Like(SYS_BILL_COLITEM.Attribute.SHOW_COL_REAL, Convert.ToString(txtSHOW_COL_REAL.Value));
}
listObj = BLLTable <SYS_BILL_COLITEM> .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 aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<SYS_BILL_COLITEM>(hidCondition.Value);
}
listObj = BLLTable<SYS_BILL_COLITEM>.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 aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <SYS_BILL_COLITEM>(hidCondition.Value);
}
listObj = BLLTable <SYS_BILL_COLITEM> .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 btnOK_Click(object sender, EventArgs e)
{
try
{
SYS_BILL_COLITEM valObj = new SYS_BILL_COLITEM();
if (txtITEM_ID.Value != "")
valObj.ITEM_ID = Convert.ToInt32(txtITEM_ID.Value);
valObj.COL_ID = colid;
if (ckVal.Checked == true)
{
if (txtVAL.Value != "")
valObj.VAL = Convert.ToString(txtVAL.Value);
}
else
{
valObj.VAL = "";
}
if (txtTXT.Value != "")
valObj.TXT = Convert.ToString(txtTXT.Value);
if (txtSHOW_COL_REAL.Value != "")
valObj.SHOW_COL_REAL = Convert.ToString(txtSHOW_COL_REAL.Value);
if (keyid != "")
{
valObj.ITEM_ID = Convert.ToInt32(keyid);
count = BLLTable<SYS_BILL_COLITEM>.Factory(conn).Update(valObj, SYS_BILL_COLITEM.Attribute.ITEM_ID);
}
else
{
count = BLLTable<SYS_BILL_COLITEM>.Factory(conn).Insert(valObj, SYS_BILL_COLITEM.Attribute.ITEM_ID);
keyid = valObj.ITEM_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("}");
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
{
//txtITEM_ID.Value ="";
//txtCOL_ID.Value ="";
txtVAL.Value = "";
txtTXT.Value = "";
txtSHOW_COL_REAL.Value = "";
}
}
}
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["ITEM_ID"]))
{
keyid = Request["ITEM_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["ColID"]))
{
colid = int.Parse(Request["ColID"]);
}
if (!IsPostBack)
{
try
{
if (keyid != "")
{
valObj = BLLTable<SYS_BILL_COLITEM>.Factory(conn).GetRowData(SYS_BILL_COLITEM.Attribute.ITEM_ID, keyid);
if (valObj == null) return;
txtITEM_ID.Value = Convert.ToString(valObj.ITEM_ID);//Convert.ToInt32
//txtCOL_ID.Value = Convert.ToString(valObj.COL_ID);//Convert.ToInt32
txtVAL.Value = Convert.ToString(valObj.VAL);//Convert.ToString
txtTXT.Value = Convert.ToString(valObj.TXT);//Convert.ToString
txtSHOW_COL_REAL.Value = Convert.ToString(valObj.SHOW_COL_REAL);//Convert.ToString
if (!string.IsNullOrEmpty(valObj.VAL))
{
ckVal.Checked = true;
}
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "_valChg();", false);
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
SYS_BILL_COLITEM valObj = new SYS_BILL_COLITEM();
if (txtITEM_ID.Value != "")
{
valObj.ITEM_ID = Convert.ToInt32(txtITEM_ID.Value);
}
valObj.COL_ID = colid;
if (ckVal.Checked == true)
{
if (txtVAL.Value != "")
{
valObj.VAL = Convert.ToString(txtVAL.Value);
}
}
else
{
valObj.VAL = "";
}
if (txtTXT.Value != "")
{
valObj.TXT = Convert.ToString(txtTXT.Value);
}
if (txtSHOW_COL_REAL.Value != "")
{
valObj.SHOW_COL_REAL = Convert.ToString(txtSHOW_COL_REAL.Value);
}
if (keyid != "")
{
valObj.ITEM_ID = Convert.ToInt32(keyid);
count = BLLTable <SYS_BILL_COLITEM> .Factory(conn).Update(valObj, SYS_BILL_COLITEM.Attribute.ITEM_ID);
}
else
{
count = BLLTable <SYS_BILL_COLITEM> .Factory(conn).Insert(valObj, SYS_BILL_COLITEM.Attribute.ITEM_ID);
keyid = valObj.ITEM_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("}");
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
{
//txtITEM_ID.Value ="";
//txtCOL_ID.Value ="";
txtVAL.Value = "";
txtTXT.Value = "";
txtSHOW_COL_REAL.Value = "";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
