protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new HR_CHECKINOUT(); if(txtUSERID.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.USERID, Convert.ToInt32(txtUSERID.Value)); if(txtCHECKTIME.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.CHECKTIME, Convert.ToDateTime(txtCHECKTIME.Value)); if(txtSTAFF_ID.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value)); if(txtCHECKTYPE.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.CHECKTYPE, Convert.ToString(txtCHECKTYPE.Value)); if(txtVERIFYCODE.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.VERIFYCODE, Convert.ToInt32(txtVERIFYCODE.Value)); if(txtSENSORID.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.SENSORID, Convert.ToString(txtSENSORID.Value)); listObj = BLLTable<HR_CHECKINOUT>.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 Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "详细"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["CHECKTIME"])) { valObj = BLLTable <HR_CHECKINOUT> .Factory(conn).GetRowData(HR_CHECKINOUT.Attribute.CHECKTIME, Request["CHECKTIME"]); if (valObj == null) { return; } txtUSERID.Text = Convert.ToString(valObj.USERID);//Convert.ToInt32 txtCHECKTIME.Text = (valObj.CHECKTIME == DateTime.MinValue) ? "" : valObj.CHECKTIME.ToString("yyyy-MM-dd HH:mm"); txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal txtCHECKTYPE.Text = Convert.ToString(valObj.CHECKTYPE);//Convert.ToString txtVERIFYCODE.Text = Convert.ToString(valObj.VERIFYCODE);//Convert.ToInt32 txtSENSORID.Text = Convert.ToString(valObj.SENSORID);//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 HR_CHECKINOUT(); if(txtUSERID.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.USERID, Convert.ToInt32(txtUSERID.Value)); if(txtCHECKTIME.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.CHECKTIME, Convert.ToDateTime(txtCHECKTIME.Value)); if(txtSTAFF_ID.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value)); if(txtCHECKTYPE.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.CHECKTYPE, Convert.ToString(txtCHECKTYPE.Value)); if(txtVERIFYCODE.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.VERIFYCODE, Convert.ToInt32(txtVERIFYCODE.Value)); if(txtSENSORID.Value !="" ) condObj.Like(HR_CHECKINOUT.Attribute.SENSORID, Convert.ToString(txtSENSORID.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<HR_CHECKINOUT>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <HR_CHECKINOUT>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <HR_CHECKINOUT>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<HR_CHECKINOUT>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { #region//默认隐藏的列 //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(HR_CHECKINOUT.Attribute.EXP1); //hideTableColumnList.Add(HR_CHECKINOUT.Attribute.EXP2); //hideTableColumnList.Add(HR_CHECKINOUT.Attribute.EXP3); //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要 //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(HR_CHECKINOUT.Attribute.EXP1); //hideFindColumnList.Add(HR_CHECKINOUT.Attribute.EXP2); //hideFindColumnList.Add(HR_CHECKINOUT.Attribute.EXP3); #endregion condObj.OrderBy(HR_CHECKINOUT.Attribute.CHECKTIME, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { HR_CHECKINOUT roleOld = new HR_CHECKINOUT(); roleOld.Where(HR_CHECKINOUT.Attribute.CHECKTIME, Request["ids"].ToString()); listObj = BLLTable <HR_CHECKINOUT> .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].CHECKTIME + "',Name:'" + listObj[i].CHECKTIME + "'}";//这里的Name用于显示在列表中,请自行重定义。 hidInitIDS.Value += listObj[i].CHECKTIME; } } try { listObj = BLLTable <HR_CHECKINOUT> .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) { //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelCHECKTIME"] != null) { int re = BLLTable <HR_CHECKINOUT> .Factory(conn).Delete(HR_CHECKINOUT.Attribute.CHECKTIME, Request["DelCHECKTIME"]); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { HR_CHECKINOUT cond = new HR_CHECKINOUT(); cond.In(HR_CHECKINOUT.Attribute.CHECKTIME, Request["DelKeyIDS"]); int re = BLLTable <HR_CHECKINOUT> .Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { HR_CHECKINOUT val = new HR_CHECKINOUT(); //val.CHECKTIME = 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 <HR_CHECKINOUT> .Factory(conn).Update(val, HR_CHECKINOUT.Attribute.CHECKTIME); Response.Write("修改用户信息成功"); } Response.End(); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new HR_CHECKINOUT(); if (txtUSERID.Value != "") { condObj.Like_OR(HR_CHECKINOUT.Attribute.USERID, Convert.ToInt32(txtUSERID.Value)); } if (txtCHECKTIME.Value != "") { condObj.Like_OR(HR_CHECKINOUT.Attribute.CHECKTIME, Convert.ToDateTime(txtCHECKTIME.Value)); } if (txtSTAFF_ID.Value != "") { condObj.Like_OR(HR_CHECKINOUT.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value)); } if (txtCHECKTYPE.Value != "") { condObj.Like_OR(HR_CHECKINOUT.Attribute.CHECKTYPE, Convert.ToString(txtCHECKTYPE.Value)); } if (txtVERIFYCODE.Value != "") { condObj.Like_OR(HR_CHECKINOUT.Attribute.VERIFYCODE, Convert.ToInt32(txtVERIFYCODE.Value)); } if (txtSENSORID.Value != "") { condObj.Like_OR(HR_CHECKINOUT.Attribute.SENSORID, Convert.ToString(txtSENSORID.Value)); } try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable <HR_CHECKINOUT> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } 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["CHECKTIME"])) { valObj = BLLTable<HR_CHECKINOUT>.Factory(conn).GetRowData(HR_CHECKINOUT.Attribute.CHECKTIME, Request["CHECKTIME"]); if(valObj==null) return ; txtUSERID.Text = Convert.ToString(valObj.USERID);//Convert.ToInt32 txtCHECKTIME.Text = (valObj.CHECKTIME == DateTime.MinValue) ? "" : valObj.CHECKTIME.ToString("yyyy-MM-dd HH:mm"); txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal txtCHECKTYPE.Text = Convert.ToString(valObj.CHECKTYPE);//Convert.ToString txtVERIFYCODE.Text = Convert.ToString(valObj.VERIFYCODE);//Convert.ToInt32 txtSENSORID.Text = Convert.ToString(valObj.SENSORID);//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 Page_Load(object sender, EventArgs e) { //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelCHECKTIME"] != null) { int re = BLLTable<HR_CHECKINOUT>.Factory(conn).Delete(HR_CHECKINOUT.Attribute.CHECKTIME, Request["DelCHECKTIME"]); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { HR_CHECKINOUT cond = new HR_CHECKINOUT(); cond.In(HR_CHECKINOUT.Attribute.CHECKTIME, Request["DelKeyIDS"]); int re = BLLTable<HR_CHECKINOUT>.Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { HR_CHECKINOUT val = new HR_CHECKINOUT(); //val.CHECKTIME = 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<HR_CHECKINOUT>.Factory(conn).Update(val, HR_CHECKINOUT.Attribute.CHECKTIME); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "±à¼"; Page.Title = title; if (!string.IsNullOrEmpty(Request["CHECKTIME"])) { keyid = Request["CHECKTIME"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { txtCHECKTIME.Value = (DateTime.Now).ToString("yyyy-MM-dd"); this.txtCHECKTIME.Disabled = true; this.txtCHECKTIME.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable <HR_CHECKINOUT> .Factory(conn).GetRowData(HR_CHECKINOUT.Attribute.CHECKTIME, keyid); if (valObj == null) { return; } txtUSERID.Value = Convert.ToString(valObj.USERID);//Convert.ToInt32 txtCHECKTIME.Value = (valObj.CHECKTIME == DateTime.MinValue) ? "" : valObj.CHECKTIME.ToString("yyyy-MM-dd"); txtSTAFF_ID.Value = Convert.ToString(valObj.STAFF_ID); //Convert.ToDecimal txtCHECKTYPE.Value = Convert.ToString(valObj.CHECKTYPE); //Convert.ToString txtVERIFYCODE.Value = Convert.ToString(valObj.VERIFYCODE); //Convert.ToInt32 txtSENSORID.Value = Convert.ToString(valObj.SENSORID); //Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new HR_CHECKINOUT(); if (txtUSERID.Value != "") { condObj.Like(HR_CHECKINOUT.Attribute.USERID, Convert.ToInt32(txtUSERID.Value)); } if (txtCHECKTIME.Value != "") { condObj.Like(HR_CHECKINOUT.Attribute.CHECKTIME, Convert.ToDateTime(txtCHECKTIME.Value)); } if (txtSTAFF_ID.Value != "") { condObj.Like(HR_CHECKINOUT.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value)); } if (txtCHECKTYPE.Value != "") { condObj.Like(HR_CHECKINOUT.Attribute.CHECKTYPE, Convert.ToString(txtCHECKTYPE.Value)); } if (txtVERIFYCODE.Value != "") { condObj.Like(HR_CHECKINOUT.Attribute.VERIFYCODE, Convert.ToInt32(txtVERIFYCODE.Value)); } if (txtSENSORID.Value != "") { condObj.Like(HR_CHECKINOUT.Attribute.SENSORID, Convert.ToString(txtSENSORID.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
private void BindList(HR_CHECKINOUT condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(HR_CHECKINOUT.Attribute.CHECKTIME, Order.Desc); } #region//数据权限条件 #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable <HR_CHECKINOUT> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <HR_CHECKINOUT>(hidCondition.Value); } listObj = BLLTable <HR_CHECKINOUT> .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<HR_CHECKINOUT>(hidCondition.Value); } listObj = BLLTable<HR_CHECKINOUT>.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 { HR_CHECKINOUT valObj = new HR_CHECKINOUT(); if (txtUSERID.Value != "") { valObj.USERID = Convert.ToInt32(txtUSERID.Value); } if (txtCHECKTIME.Value != "") { valObj.CHECKTIME = Convert.ToDateTime(txtCHECKTIME.Value); } if (txtSTAFF_ID.Value != "") { valObj.STAFF_ID = Convert.ToDecimal(txtSTAFF_ID.Value); } if (txtCHECKTYPE.Value != "") { valObj.CHECKTYPE = Convert.ToString(txtCHECKTYPE.Value); } if (txtVERIFYCODE.Value != "") { valObj.VERIFYCODE = Convert.ToInt32(txtVERIFYCODE.Value); } if (txtSENSORID.Value != "") { valObj.SENSORID = Convert.ToString(txtSENSORID.Value); } if (keyid != "") { //valObj.CHECKTIME = Convert.ToInt32(keyid); count = BLLTable <HR_CHECKINOUT> .Factory(conn).Update(valObj, HR_CHECKINOUT.Attribute.CHECKTIME); } else { count = BLLTable <HR_CHECKINOUT> .Factory(conn).Insert(valObj, HR_CHECKINOUT.Attribute.CHECKTIME); keyid = valObj.CHECKTIME.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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK") { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 { txtUSERID.Value = ""; txtCHECKTIME.Value = ""; txtSTAFF_ID.Value = ""; txtCHECKTYPE.Value = ""; txtVERIFYCODE.Value = ""; txtSENSORID.Value = ""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { #region//Ĭ�����ص��� //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(HR_CHECKINOUT.Attribute.EXP1); //hideTableColumnList.Add(HR_CHECKINOUT.Attribute.EXP2); //hideTableColumnList.Add(HR_CHECKINOUT.Attribute.EXP3); //valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(HR_CHECKINOUT.Attribute.EXP1); //hideFindColumnList.Add(HR_CHECKINOUT.Attribute.EXP2); //hideFindColumnList.Add(HR_CHECKINOUT.Attribute.EXP3); #endregion condObj.OrderBy(HR_CHECKINOUT.Attribute.CHECKTIME, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { HR_CHECKINOUT roleOld = new HR_CHECKINOUT(); roleOld.Where(HR_CHECKINOUT.Attribute.CHECKTIME, Request["ids"].ToString()); listObj = BLLTable<HR_CHECKINOUT>.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].CHECKTIME + "',Name:'" + listObj[i].CHECKTIME + "'}";//�����Name������ʾ���б��У��������ض��塣 hidInitIDS.Value += listObj[i].CHECKTIME; } } try { listObj = BLLTable<HR_CHECKINOUT>.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["CHECKTIME"])) { keyid = Request["CHECKTIME"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { txtCHECKTIME.Value = (DateTime.Now).ToString("yyyy-MM-dd"); this.txtCHECKTIME.Disabled = true; this.txtCHECKTIME.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable<HR_CHECKINOUT>.Factory(conn).GetRowData(HR_CHECKINOUT.Attribute.CHECKTIME, keyid); if(valObj==null) return ; txtUSERID.Value = Convert.ToString(valObj.USERID);//Convert.ToInt32 txtCHECKTIME.Value = (valObj.CHECKTIME == DateTime.MinValue) ? "" : valObj.CHECKTIME.ToString("yyyy-MM-dd"); txtSTAFF_ID.Value = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal txtCHECKTYPE.Value = Convert.ToString(valObj.CHECKTYPE);//Convert.ToString txtVERIFYCODE.Value = Convert.ToString(valObj.VERIFYCODE);//Convert.ToInt32 txtSENSORID.Value = Convert.ToString(valObj.SENSORID);//Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnOK_Click(object sender, EventArgs e) { try { HR_CHECKINOUT valObj = new HR_CHECKINOUT(); if(txtUSERID.Value !="" ) valObj.USERID = Convert.ToInt32(txtUSERID.Value); if(txtCHECKTIME.Value !="" ) valObj.CHECKTIME = Convert.ToDateTime(txtCHECKTIME.Value); if(txtSTAFF_ID.Value !="" ) valObj.STAFF_ID = Convert.ToDecimal(txtSTAFF_ID.Value); if(txtCHECKTYPE.Value !="" ) valObj.CHECKTYPE = Convert.ToString(txtCHECKTYPE.Value); if(txtVERIFYCODE.Value !="" ) valObj.VERIFYCODE = Convert.ToInt32(txtVERIFYCODE.Value); if(txtSENSORID.Value !="" ) valObj.SENSORID = Convert.ToString(txtSENSORID.Value); if (keyid != "") { //valObj.CHECKTIME = Convert.ToInt32(keyid); count = BLLTable<HR_CHECKINOUT>.Factory(conn).Update(valObj, HR_CHECKINOUT.Attribute.CHECKTIME); } else { count = BLLTable<HR_CHECKINOUT>.Factory(conn).Insert(valObj, HR_CHECKINOUT.Attribute.CHECKTIME); keyid = valObj.CHECKTIME.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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK") { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 { txtUSERID.Value =""; txtCHECKTIME.Value =""; txtSTAFF_ID.Value =""; txtCHECKTYPE.Value =""; txtVERIFYCODE.Value =""; txtSENSORID.Value =""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
private DataTable CreatDefaultFangAnTable(string fangan) { DataTable tab = new DataTable(fangan); tab.Columns.Add("*USERINFO"); tab.Columns.Add("*CHECKINOUT"); HR_CK_USERINFO hruser = new HR_CK_USERINFO(); foreach (AttributeItem ai in hruser.af_AttributeItemList) { if (ai.FieldName == "ID" || ai.FieldName == "PHOTO") continue; tab.Columns.Add("USERINFO_" + ai.FieldName); } HR_CHECKINOUT hrcheck = new HR_CHECKINOUT(); foreach (AttributeItem ai in hrcheck.af_AttributeItemList) { if (ai.FieldName == "ID" || ai.FieldName == "PHOTO") continue; tab.Columns.Add("CHECKINOUT_" + ai.FieldName); } DataRow dr = tab.NewRow(); dr["*USERINFO"] = "USERINFO"; dr["*CHECKINOUT"] = "CHECKINOUT"; foreach (AttributeItem ai in hruser.af_AttributeItemList) { if (ai.FieldName == "ID" || ai.FieldName == "PHOTO") continue; if (ai.FieldName == "STAFF_ID") dr["USERINFO_" + ai.FieldName] = "USERID"; else dr["USERINFO_" + ai.FieldName] = ai.FieldName; } foreach (AttributeItem ai in hrcheck.af_AttributeItemList) { if (ai.FieldName == "ID" || ai.FieldName == "PHOTO") continue; if (ai.FieldName == "STAFF_ID") dr["CHECKINOUT_" + ai.FieldName] = "USERID"; else dr["CHECKINOUT_" + ai.FieldName] = ai.FieldName; } tab.Rows.Add(dr); return tab; }
private void BindList(HR_CHECKINOUT condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(HR_CHECKINOUT.Attribute.CHECKTIME, Order.Desc); #region//����Ȩ������ #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable<HR_CHECKINOUT>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
private void UpdateCheck(OleDbConnection conn2, string fangan, string stime, string etime) { if (conn2 == null) return; Dictionary<string, string> userFields = GetFieldsByFangAn(fangan, "CHECKINOUT"); if (!userFields.ContainsKey("*CHECKINOUT") || !userFields.ContainsKey("CHECKINOUT_CHECKTIME")) { Response.Write("同步方案不完整,请修改方案!"); Response.End(); return; } string sql = "select "; foreach (string field in userFields.Keys) { if (field.Contains("*")) continue; sql += " " + userFields[field] + ","; } sql = sql.TrimEnd(','); sql += " from " + userFields["*CHECKINOUT"]; sql += " where " + userFields["CHECKINOUT_CHECKTIME"]; sql += " between #" + stime + "# and #" + etime + "# "; OleDbCommand com = new OleDbCommand(sql, conn2); OleDbDataReader dr = com.ExecuteReader(); HR_CHECKINOUT hrcheck = new HR_CHECKINOUT(); List<HR_CHECKINOUT> hrchecks = new List<HR_CHECKINOUT>(); while (dr.Read()) { try { hrcheck = new HR_CHECKINOUT(); foreach (AttributeItem ai in hrcheck.af_AttributeItemList) { if (userFields.ContainsKey("CHECKINOUT_" + ai.FieldName)) { object val = dr[userFields["CHECKINOUT_" + ai.FieldName]]; if (val != null && !string.IsNullOrEmpty(val.ToString())) hrcheck.SetValue(ai, val); } } hrchecks.Add(hrcheck); } catch { } } int countok = 0; int countfi = 0; int counter = 0; foreach (HR_CHECKINOUT check in hrchecks) { try { int count = BLLTable<HR_CHECKINOUT>.SaveOrUpdate(check, HR_CHECKINOUT.Attribute.USERID, HR_CHECKINOUT.Attribute.CHECKTIME); if (count > 0) countok++; else countfi++; } catch { counter++; } } Response.Write("同步考勤记录数:" + hrchecks.Count + "条" + "\n成功:" + countok + "条\n失败:" + countfi + "条\n出错:" + counter + "条"); }
private void UpdateCheck(OleDbConnection conn2, string fangan, string stime, string etime) { if (conn2 == null) { return; } Dictionary <string, string> userFields = GetFieldsByFangAn(fangan, "CHECKINOUT"); if (!userFields.ContainsKey("*CHECKINOUT") || !userFields.ContainsKey("CHECKINOUT_CHECKTIME")) { Response.Write("同步方案不完整,请修改方案!"); Response.End(); return; } string sql = "select "; foreach (string field in userFields.Keys) { if (field.Contains("*")) { continue; } sql += " " + userFields[field] + ","; } sql = sql.TrimEnd(','); sql += " from " + userFields["*CHECKINOUT"]; sql += " where " + userFields["CHECKINOUT_CHECKTIME"]; sql += " between #" + stime + "# and #" + etime + "# "; OleDbCommand com = new OleDbCommand(sql, conn2); OleDbDataReader dr = com.ExecuteReader(); HR_CHECKINOUT hrcheck = new HR_CHECKINOUT(); List <HR_CHECKINOUT> hrchecks = new List <HR_CHECKINOUT>(); while (dr.Read()) { try { hrcheck = new HR_CHECKINOUT(); foreach (AttributeItem ai in hrcheck.af_AttributeItemList) { if (userFields.ContainsKey("CHECKINOUT_" + ai.FieldName)) { object val = dr[userFields["CHECKINOUT_" + ai.FieldName]]; if (val != null && !string.IsNullOrEmpty(val.ToString())) { hrcheck.SetValue(ai, val); } } } hrchecks.Add(hrcheck); } catch { } } int countok = 0; int countfi = 0; int counter = 0; foreach (HR_CHECKINOUT check in hrchecks) { try { int count = BLLTable <HR_CHECKINOUT> .SaveOrUpdate(check, HR_CHECKINOUT.Attribute.USERID, HR_CHECKINOUT.Attribute.CHECKTIME); if (count > 0) { countok++; } else { countfi++; } } catch { counter++; } } Response.Write("同步考勤记录数:" + hrchecks.Count + "条" + "\n成功:" + countok + "条\n失败:" + countfi + "条\n出错:" + counter + "条"); }
private DataTable CreatDefaultFangAnTable(string fangan) { DataTable tab = new DataTable(fangan); tab.Columns.Add("*USERINFO"); tab.Columns.Add("*CHECKINOUT"); HR_CK_USERINFO hruser = new HR_CK_USERINFO(); foreach (AttributeItem ai in hruser.af_AttributeItemList) { if (ai.FieldName == "ID" || ai.FieldName == "PHOTO") { continue; } tab.Columns.Add("USERINFO_" + ai.FieldName); } HR_CHECKINOUT hrcheck = new HR_CHECKINOUT(); foreach (AttributeItem ai in hrcheck.af_AttributeItemList) { if (ai.FieldName == "ID" || ai.FieldName == "PHOTO") { continue; } tab.Columns.Add("CHECKINOUT_" + ai.FieldName); } DataRow dr = tab.NewRow(); dr["*USERINFO"] = "USERINFO"; dr["*CHECKINOUT"] = "CHECKINOUT"; foreach (AttributeItem ai in hruser.af_AttributeItemList) { if (ai.FieldName == "ID" || ai.FieldName == "PHOTO") { continue; } if (ai.FieldName == "STAFF_ID") { dr["USERINFO_" + ai.FieldName] = "USERID"; } else { dr["USERINFO_" + ai.FieldName] = ai.FieldName; } } foreach (AttributeItem ai in hrcheck.af_AttributeItemList) { if (ai.FieldName == "ID" || ai.FieldName == "PHOTO") { continue; } if (ai.FieldName == "STAFF_ID") { dr["CHECKINOUT_" + ai.FieldName] = "USERID"; } else { dr["CHECKINOUT_" + ai.FieldName] = ai.FieldName; } } tab.Rows.Add(dr); return(tab); }