protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new SYS_BILL_OPRLOG();
if (txtTABLE_NAME.Value != "")
{
condObj.Like(SYS_BILL_OPRLOG.Attribute.TABLE_NAME, Convert.ToString(txtTABLE_NAME.Value));
}
if (txtDB_SRC_NAME.Value != "")
{
condObj.Like(SYS_BILL_OPRLOG.Attribute.DB_SRC_NAME, Convert.ToString(txtDB_SRC_NAME.Value));
}
if (txtOPR_TYPE.Value != "")
{
condObj.Like(SYS_BILL_OPRLOG.Attribute.OPR_TYPE, Convert.ToString(txtOPR_TYPE.Value));
}
if (txtSTATUS.Value != "")
{
condObj.Like(SYS_BILL_OPRLOG.Attribute.STATUS, Convert.ToString(txtSTATUS.Value));
}
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void btnSetPageSize_Click(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<SYS_BILL_OPRLOG>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void btnSetPageSize_Click(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <SYS_BILL_OPRLOG>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void Page_Load(object sender, EventArgs e)
{
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelLOG_ID"] != null)
{
int re = BLLTable <SYS_BILL_OPRLOG> .Factory(conn).Delete(SYS_BILL_OPRLOG.Attribute.LOG_ID, Request["DelLOG_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
SYS_BILL_OPRLOG cond = new SYS_BILL_OPRLOG();
cond.In(SYS_BILL_OPRLOG.Attribute.LOG_ID, Request["DelKeyIDS"]);
int re = BLLTable <SYS_BILL_OPRLOG> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
SYS_BILL_OPRLOG val = new SYS_BILL_OPRLOG();
val.LOG_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_OPRLOG> .Factory(conn).Update(val, SYS_BILL_OPRLOG.Attribute.LOG_ID);
Response.Write("修改用户信息成功");
}
Response.End();
}
private void BindList(SYS_BILL_OPRLOG condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(SYS_BILL_OPRLOG.Attribute.LOG_ID, Order.Desc);
}
listObj = BLLTable <SYS_BILL_OPRLOG> .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)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelLOG_ID"] != null)
{
int re = BLLTable<SYS_BILL_OPRLOG>.Factory(conn).Delete(SYS_BILL_OPRLOG.Attribute.LOG_ID, Request["DelLOG_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
SYS_BILL_OPRLOG cond = new SYS_BILL_OPRLOG();
cond.In(SYS_BILL_OPRLOG.Attribute.LOG_ID, Request["DelKeyIDS"]);
int re = BLLTable<SYS_BILL_OPRLOG>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
SYS_BILL_OPRLOG val = new SYS_BILL_OPRLOG();
val.LOG_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_OPRLOG>.Factory(conn).Update(val, SYS_BILL_OPRLOG.Attribute.LOG_ID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new SYS_BILL_OPRLOG();
if (txtTABLE_NAME.Value != "")
condObj.Like(SYS_BILL_OPRLOG.Attribute.TABLE_NAME, Convert.ToString(txtTABLE_NAME.Value));
if (txtDB_SRC_NAME.Value != "")
condObj.Like(SYS_BILL_OPRLOG.Attribute.DB_SRC_NAME, Convert.ToString(txtDB_SRC_NAME.Value));
if (txtOPR_TYPE.Value != "")
condObj.Like(SYS_BILL_OPRLOG.Attribute.OPR_TYPE, Convert.ToString(txtOPR_TYPE.Value));
if (txtSTATUS.Value != "")
condObj.Like(SYS_BILL_OPRLOG.Attribute.STATUS, Convert.ToString(txtSTATUS.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
private void BindList(SYS_BILL_OPRLOG condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(SYS_BILL_OPRLOG.Attribute.LOG_ID, Order.Desc);
listObj = BLLTable<SYS_BILL_OPRLOG>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
