Пример #1
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        int uid = -1;

        condObj = new HR_CK_USERINFO();
        if (txtUSERID.Value != "" && int.TryParse(txtUSERID.Value, out uid))
        {
            condObj.USERID = Convert.ToInt32(txtUSERID.Value);
        }
        if (txtSTAFF_ID.Value != "" && int.TryParse(txtSTAFF_ID.Value, out uid))
        {
            condObj.STAFF_ID = Convert.ToInt32(txtSTAFF_ID.Value);
        }
        if (txtBADGENUMBER.Value != "")
        {
            condObj.Like(HR_CK_USERINFO.Attribute.BADGENUMBER, txtBADGENUMBER.Value);
        }
        if (txtSSN.Value != "")
        {
            condObj.Like(HR_CK_USERINFO.Attribute.SSN, txtSSN.Value);
        }
        if (txtNAME.Value != "")
        {
            condObj.Like(HR_CK_USERINFO.Attribute.NAME, txtNAME.Value);
        }

        hidCondition.Value = condObj.ToJson(20);
        BindList(condObj, 1);
    }
Пример #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string doType = Request["dotype"];
        string userid = Server.UrlDecode(Request["userid"]);
        if (string.IsNullOrEmpty(doType) || string.IsNullOrEmpty(userid))
        {
            Response.Write("user id is null");
            Response.End();
            return;
        }

        if (doType == "doUpdateCKUSERINFOStff")
        {
            try
            {
                string stfid = Server.UrlDecode(Request["stfid"]);
                HR_CK_USERINFO user = new HR_CK_USERINFO();
                user._USERID = Convert.ToInt32(userid);
                if (!string.IsNullOrEmpty(stfid) && stfid != "-")
                {
                    HR_CK_USERINFO userCon = new HR_CK_USERINFO();
                    userCon.STAFF_ID = Convert.ToInt32(stfid);
                    if (BLLTable<HR_CK_USERINFO>.Exists(userCon))
                    {
                        Response.Write("该员工已有对应关系!");
                    }
                    else
                    {
                        user.STAFF_ID = Convert.ToInt32(stfid);
                        if (BLLTable<HR_CK_USERINFO>.Factory(conn).Update(user, HR_CK_USERINFO.Attribute.USERID) > 0)
                            Response.Write("操作成功");
                        else
                            Response.Write("操作失败");
                    }
                }
                else
                {
                    user.STAFF_ID = 0;
                    if (BLLTable<HR_CK_USERINFO>.Factory(conn).Update(user, HR_CK_USERINFO.Attribute.USERID) > 0)
                        Response.Write("操作成功");
                    else
                        Response.Write("操作失败");
                }
            }
            catch (Exception ex)
            {
                Response.Write("操作失败!\r\n原因如下:\r\n----------\r\n" + ex.Message);
                Response.End();
            }
            Response.End();
        }
        else
        {
            Response.Write("不支持的操作!");
            Response.End();
            return;
        }
        Response.End();
    }
 protected void aspPager_PageChanged(object sender, EventArgs e)
 {
     if (hidCondition.Value != "")
     {
         condObj = JsonServiceBase.FromJson<HR_CK_USERINFO>(hidCondition.Value);
     }
     BindList(condObj, aspPager.CurrentPageIndex);
 }
Пример #4
0
 protected void aspPager_PageChanged(object sender, EventArgs e)
 {
     if (hidCondition.Value != "")
     {
         condObj = JsonServiceBase.FromJson <HR_CK_USERINFO>(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_CK_USERINFO>(hidCondition.Value);
     }
     BindList(condObj, aspPager.CurrentPageIndex);
 }
Пример #6
0
 protected void btnSetPageSize_Click(object sender, EventArgs e)
 {
     aspPager.PageSize = int.Parse(txtPageSize.Value);
     if (hidCondition.Value != "")
     {
         condObj = JsonServiceBase.FromJson <HR_CK_USERINFO>(hidCondition.Value);
     }
     BindList(condObj, aspPager.CurrentPageIndex);
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录
        if (Request["DelUSERID"] != null)
        {
            int re = BLLTable <HR_CK_USERINFO> .Factory(conn).Delete(HR_CK_USERINFO.Attribute.USERID, Request["DelUSERID"]);

            if (re > 0)
            {
                Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示
            }
            else
            {
                Response.Write("删除失败!");
            }
        }

        //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录
        if (Request["DelKeyIDS"] != null)
        {
            HR_CK_USERINFO cond = new HR_CK_USERINFO();
            cond.In(HR_CK_USERINFO.Attribute.USERID, Request["DelKeyIDS"]);
            int re = BLLTable <HR_CK_USERINFO> .Factory(conn).Delete(cond);

            if (re > 0)
            {
                Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示
            }
            else
            {
                Response.Write("删除失败!");
            }
        }

        //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新
        if (Request["saveInfo"] != null)
        {
            HR_CK_USERINFO val = new HR_CK_USERINFO();
            val.USERID = 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_CK_USERINFO> .Factory(conn).Update(val, HR_CK_USERINFO.Attribute.USERID);

            Response.Write("修改用户信息成功");
        }
        Response.End();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        #region//默认隐藏的列
        //hideTableColumnList = new List<AttributeItem>();
        //hideTableColumnList.Add(HR_CK_USERINFO.Attribute.EXP1);
        //hideTableColumnList.Add(HR_CK_USERINFO.Attribute.EXP2);
        //hideTableColumnList.Add(HR_CK_USERINFO.Attribute.EXP3);
        //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要
        //valObj.Remove(hideTableColumnList);

        //hideFindColumnList = new List<AttributeItem>();
        //hideFindColumnList.Add(HR_CK_USERINFO.Attribute.EXP1);
        //hideFindColumnList.Add(HR_CK_USERINFO.Attribute.EXP2);
        //hideFindColumnList.Add(HR_CK_USERINFO.Attribute.EXP3);
        #endregion
        condObj.OrderBy(HR_CK_USERINFO.Attribute.USERID, Order.Desc);

        if (!IsPostBack)
        {
            btnFind.Text              = LanguageService.GetLanguageString("btnFind", "查询");
            aspPager.PageSize         = 10;
            aspPager.CurrentPageIndex = 1;

            if (!string.IsNullOrEmpty(Request["ids"]))
            {
                HR_CK_USERINFO roleOld = new HR_CK_USERINFO();
                roleOld.Where(HR_CK_USERINFO.Attribute.USERID, Request["ids"].ToString());
                listObj = BLLTable <HR_CK_USERINFO> .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].USERID + "',Name:'" + listObj[i].USERID + "'}";//这里的Name用于显示在列表中,请自行重定义。
                    hidInitIDS.Value += listObj[i].USERID;
                }
            }
            try
            {
                listObj = BLLTable <HR_CK_USERINFO> .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["DelUSERID"] != null)
        {
            int re = BLLTable<HR_CK_USERINFO>.Factory(conn).Delete(HR_CK_USERINFO.Attribute.USERID, Request["DelUSERID"]);
            if (re > 0)
            {
                Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
            }
            else
            {
                Response.Write("ɾ��ʧ�ܣ�");
            }
        }

        //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
        if (Request["DelKeyIDS"] != null)
        {
            HR_CK_USERINFO cond = new HR_CK_USERINFO();
            cond.In(HR_CK_USERINFO.Attribute.USERID, Request["DelKeyIDS"]);
            int re = BLLTable<HR_CK_USERINFO>.Factory(conn).Delete(cond);
            if (re > 0)
            {
                Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
            }
            else
            {
                Response.Write("ɾ��ʧ�ܣ�");
            }
        }

        //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
        if (Request["saveInfo"] != null)
        {
            HR_CK_USERINFO val = new HR_CK_USERINFO();
            val.USERID = 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_CK_USERINFO>.Factory(conn).Update(val, HR_CK_USERINFO.Attribute.USERID);
            Response.Write("�޸��û���Ϣ�ɹ�");

        }
        Response.End();
    }
    protected void btnFind_Click(object sender, EventArgs e)
    {
        int uid = -1;
        condObj = new HR_CK_USERINFO();
        if (txtUSERID.Value != "" && int.TryParse(txtUSERID.Value, out uid))
            condObj.USERID = Convert.ToInt32(txtUSERID.Value);
        if (txtSTAFF_ID.Value != "" && int.TryParse(txtSTAFF_ID.Value, out uid))
            condObj.STAFF_ID = Convert.ToInt32(txtSTAFF_ID.Value);
        if (txtBADGENUMBER.Value != "")
            condObj.Like(HR_CK_USERINFO.Attribute.BADGENUMBER, txtBADGENUMBER.Value);
        if (txtSSN.Value != "")
            condObj.Like(HR_CK_USERINFO.Attribute.SSN, txtSSN.Value);
        if (txtNAME.Value != "")
            condObj.Like(HR_CK_USERINFO.Attribute.NAME, txtNAME.Value);

        hidCondition.Value = condObj.ToJson(20);
        BindList(condObj, 1);
    }
Пример #11
0
    protected void aspPager_PageChanged(object sender, EventArgs e)
    {
        try
        {
            if (hidCondition.Value != "")
            {
                condObj = JsonServiceBase.FromJson <HR_CK_USERINFO>(hidCondition.Value);
            }
            listObj = BLLTable <HR_CK_USERINFO> .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
     {
         recount = aspPager.RecordCount;
         if (hidCondition.Value != "")
         {
             condObj = JsonServiceBase.FromJson<HR_CK_USERINFO>(hidCondition.Value);
         }
         List<HR_CK_USERINFO> listVal = BLLTable<HR_CK_USERINFO>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);
         repList.DataSource = listVal;
         repList.DataBind();
     }
     catch (Exception ex)
     {
          litWarn.Text = ex.Message;
     }
 }
Пример #13
0
    private void BindList(HR_CK_USERINFO condObj, int curPage)
    {
        if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序
        {
            condObj.af_PageBy(HR_CK_USERINFO.Attribute.USERID, Order.Asc);
        }

        #region//数据权限条件

        #endregion
        //condObj.PID = decimal.Parse(pid);

        HR_STAFF otherVal = new HR_STAFF();
        otherVal.STAFF_NAME = "";
        Relation r2 = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_CK_USERINFO.Attribute.STAFF_ID, RelationType.RightJoin);
        if (!string.IsNullOrEmpty(txtSTAFF_NAME.Value) || !string.IsNullOrEmpty(txtSTAFF_NO.Value))
        {
            HR_STAFF otherCon = new HR_STAFF();
            if (!string.IsNullOrEmpty(txtSTAFF_NAME.Value))
            {
                otherCon.Like(HR_STAFF.Attribute.STAFF_NAME, txtSTAFF_NAME.Value);
            }
            if (!string.IsNullOrEmpty(txtSTAFF_NO.Value))
            {
                otherCon.Like(HR_STAFF.Attribute.STAFF_NO, txtSTAFF_NO.Value);
            }
            listObj = BLLTable <HR_CK_USERINFO> .Factory(conn).SelectByPage(valObj, new List <Relation>(new Relation[] { r2 }), new List <ITableImplement>(new ITableImplement[] { otherVal }), new List <ITableImplement>(new ITableImplement[] { condObj, otherCon }), aspPager.PageSize, curPage, ref recount);
        }
        else
        {
            listObj = BLLTable <HR_CK_USERINFO> .Factory(conn).SelectByPage(valObj, r2, otherVal, condObj, aspPager.PageSize, curPage, ref recount);
        }
        repList.DataSource = listObj;
        repList.DataBind();
        aspPager.RecordCount = recount;
    }
Пример #14
0
    protected void btnOK_Click(object sender, EventArgs e)
    {
        try
        {
            HR_CK_USERINFO valObj = new HR_CK_USERINFO();


            if (txtUSERID.Value != "")
            {
                valObj.USERID = Convert.ToInt32(txtUSERID.Value);
            }


            if (wucSelStaff1.Staff_ID > 0)
            {
                valObj.STAFF_ID = Convert.ToDecimal(wucSelStaff1.Staff_ID);
            }


            if (txtBADGENUMBER.Value != "")
            {
                valObj.BADGENUMBER = Convert.ToString(txtBADGENUMBER.Value);
            }


            if (txtSSN.Value != "")
            {
                valObj.SSN = Convert.ToString(txtSSN.Value);
            }


            if (txtNAME.Value != "")
            {
                valObj.NAME = Convert.ToString(txtNAME.Value);
            }


            if (txtGENDER.Value != "")
            {
                valObj.GENDER = Convert.ToString(txtGENDER.Value);
            }


            if (txtTITLE.Value != "")
            {
                valObj.TITLE = Convert.ToString(txtTITLE.Value);
            }


            if (txtPAGER.Value != "")
            {
                valObj.PAGER = Convert.ToString(txtPAGER.Value);
            }


            if (txtBIRTHDAY.Value != "")
            {
                valObj.BIRTHDAY = Convert.ToDateTime(txtBIRTHDAY.Value);
            }


            if (txtHIREDDAY.Value != "")
            {
                valObj.HIREDDAY = Convert.ToDateTime(txtHIREDDAY.Value);
            }


            if (txtSTREET.Value != "")
            {
                valObj.STREET = Convert.ToString(txtSTREET.Value);
            }


            if (txtCITY.Value != "")
            {
                valObj.CITY = Convert.ToString(txtCITY.Value);
            }


            if (txtSTATE.Value != "")
            {
                valObj.STATE = Convert.ToString(txtSTATE.Value);
            }


            if (txtZIP.Value != "")
            {
                valObj.ZIP = Convert.ToString(txtZIP.Value);
            }


            if (txtOPHONE.Value != "")
            {
                valObj.OPHONE = Convert.ToString(txtOPHONE.Value);
            }


            if (txtFPHONE.Value != "")
            {
                valObj.FPHONE = Convert.ToString(txtFPHONE.Value);
            }


            if (txtVERIFICATIONMETHOD.Value != "")
            {
                valObj.VERIFICATIONMETHOD = Convert.ToInt16(txtVERIFICATIONMETHOD.Value);
            }


            if (txtDEFAULTDEPTID.Value != "")
            {
                valObj.DEFAULTDEPTID = Convert.ToInt16(txtDEFAULTDEPTID.Value);
            }


            if (txtSECURITYFLAGS.Value != "")
            {
                valObj.SECURITYFLAGS = Convert.ToInt16(txtSECURITYFLAGS.Value);
            }


            if (txtATT.Value != "")
            {
                valObj.ATT = Convert.ToInt16(txtATT.Value);
            }


            if (txtINLATE.Value != "")
            {
                valObj.INLATE = Convert.ToInt16(txtINLATE.Value);
            }


            if (txtOUTEARLY.Value != "")
            {
                valObj.OUTEARLY = Convert.ToInt16(txtOUTEARLY.Value);
            }


            if (txtOVERTIME.Value != "")
            {
                valObj.OVERTIME = Convert.ToInt16(txtOVERTIME.Value);
            }


            if (txtSEP.Value != "")
            {
                valObj.SEP = Convert.ToInt16(txtSEP.Value);
            }


            if (txtHOLIDAY.Value != "")
            {
                valObj.HOLIDAY = Convert.ToInt16(txtHOLIDAY.Value);
            }


            if (txtMINZU.Value != "")
            {
                valObj.MINZU = Convert.ToString(txtMINZU.Value);
            }


            if (txtPASSWORD.Value != "")
            {
                valObj.PASSWORD = Convert.ToString(txtPASSWORD.Value);
            }


            if (txtLUNCHDURATION.Value != "")
            {
                valObj.LUNCHDURATION = Convert.ToInt16(txtLUNCHDURATION.Value);
            }


            if (txtMVerifyPass.Value != "")
            {
                valObj.MVerifyPass = Convert.ToString(txtMVerifyPass.Value);
            }


            if (keyid != "")
            {
                valObj.USERID = Convert.ToInt32(keyid);
                count         = BLLTable <HR_CK_USERINFO> .Factory(conn).Update(valObj, HR_CK_USERINFO.Attribute.USERID);
            }
            else
            {
                count = BLLTable <HR_CK_USERINFO> .Factory(conn).Insert(valObj, HR_CK_USERINFO.Attribute.USERID);

                keyid = valObj.USERID.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 = "";


                    wucSelStaff1.Staff_ID = 0;


                    txtBADGENUMBER.Value = "";


                    txtSSN.Value = "";


                    txtNAME.Value = "";


                    txtGENDER.Value = "";


                    txtTITLE.Value = "";


                    txtPAGER.Value = "";


                    txtBIRTHDAY.Value = "";


                    txtHIREDDAY.Value = "";


                    txtSTREET.Value = "";


                    txtCITY.Value = "";


                    txtSTATE.Value = "";


                    txtZIP.Value = "";


                    txtOPHONE.Value = "";


                    txtFPHONE.Value = "";


                    txtVERIFICATIONMETHOD.Value = "";


                    txtDEFAULTDEPTID.Value = "";


                    txtSECURITYFLAGS.Value = "";


                    txtATT.Value = "";


                    txtINLATE.Value = "";


                    txtOUTEARLY.Value = "";


                    txtOVERTIME.Value = "";


                    txtSEP.Value = "";


                    txtHOLIDAY.Value = "";


                    txtMINZU.Value = "";


                    txtPASSWORD.Value = "";


                    txtLUNCHDURATION.Value = "";


                    txtMVerifyPass.Value = "";


                    txtPHOTO.Value = "";
                }
            }
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }
Пример #15
0
    private void UpdateStff(OleDbConnection conn2, string fangan)
    {
        if (conn2 == null)
        {
            return;
        }
        Dictionary <string, string> userFields = GetFieldsByFangAn(fangan, "USERINFO");

        if (!userFields.ContainsKey("*USERINFO"))
        {
            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["*USERINFO"];
        OleDbCommand          com     = new OleDbCommand(sql, conn2);
        OleDbDataReader       dr      = com.ExecuteReader();
        HR_CK_USERINFO        hruser  = new HR_CK_USERINFO();
        List <HR_CK_USERINFO> hrusers = new List <HR_CK_USERINFO>();
        Dictionary <string, HR_CK_USERINFO> userDic = new Dictionary <string, HR_CK_USERINFO>();
        List <HR_CK_USERINFO> chongfuUser           = new List <HR_CK_USERINFO>();

        while (dr.Read())
        {
            try
            {
                hruser = new HR_CK_USERINFO();
                foreach (AttributeItem ai in hruser.af_AttributeItemList)
                {
                    if (userFields.ContainsKey("USERINFO_" + ai.FieldName))
                    {
                        object val = dr[userFields["USERINFO_" + ai.FieldName]];
                        if (val != null && !string.IsNullOrEmpty(val.ToString()))
                        {
                            hruser.SetValue(ai, val.ToString().Replace("?粀", "").Replace("\0", "").Replace("?", "").Replace("粀", ""));
                        }
                    }
                }
                hruser.Remove(new AttributeItem[] { HR_CK_USERINFO.Attribute.STAFF_ID });
                if (!userDic.ContainsKey(hruser.NAME))
                {
                    userDic.Add(hruser.NAME, hruser);
                }
                else
                {
                    chongfuUser.Add(hruser);
                }
                hrusers.Add(hruser);
            }
            catch { }
        }

        foreach (HR_CK_USERINFO user in chongfuUser)
        {
            if (userDic.ContainsKey(user.NAME))
            {
                userDic.Remove(hruser.NAME);
            }
        }

        HR_STAFF stfVal = new HR_STAFF();

        stfVal.STAFF_NAME = "";
        stfVal.STAFF_ID   = 0;
        HR_STAFF        stfCon  = new HR_STAFF();
        List <HR_STAFF> stfList = BLLTable <HR_STAFF> .Factory(conn).Select(stfVal, stfCon);

        Dictionary <string, HR_STAFF> stfDic = new Dictionary <string, HR_STAFF>();
        List <HR_STAFF> chongfuStf           = new List <HR_STAFF>();

        foreach (HR_STAFF stf in stfList)
        {
            if (!stfDic.ContainsKey(stf.STAFF_NAME))
            {
                stfDic.Add(stf.STAFF_NAME, stf);
            }
            else
            {
                chongfuStf.Add(stf);
            }
        }

        foreach (HR_STAFF stf in chongfuStf)
        {
            if (stfDic.ContainsKey(stf.STAFF_NAME))
            {
                stfDic.Remove(stf.STAFF_NAME);
            }
        }

        foreach (string name in userDic.Keys)
        {
            if (stfDic.ContainsKey(name))
            {
                HR_CK_USERINFO stfidcon = new HR_CK_USERINFO();//wcp考虑优化新能
                stfidcon.STAFF_ID = stfDic[name].STAFF_ID;
                if (!BLLTable <HR_CK_USERINFO> .Exists(stfidcon))
                {
                    userDic[name].STAFF_ID = stfDic[name].STAFF_ID;
                }
            }
        }

        int countok = 0;
        int countfi = 0;
        int counter = 0;

        foreach (HR_CK_USERINFO user in hrusers)
        {
            try
            {
                int count = 0;
                count = BLLTable <HR_CK_USERINFO> .SaveOrUpdate(user, HR_CK_USERINFO.Attribute.USERID);

                if (count > 0)
                {
                    countok++;
                }
                else
                {
                    countfi++;
                }
            }
            catch { counter++; }
        }

        Response.Write("同步员工信息数:" + hrusers.Count + "条" + "\n成功:" + countok + "条\n失败:" + countfi + "条\n出错:" + counter + "条");
    }
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new HR_CK_USERINFO();

        if(txtUSERID.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.USERID, Convert.ToInt32(txtUSERID.Value));

        if(txtSTAFF_ID.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value));

        if(txtBADGENUMBER.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.BADGENUMBER, Convert.ToString(txtBADGENUMBER.Value));

        if(txtSSN.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.SSN, Convert.ToString(txtSSN.Value));

        if(txtNAME.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.NAME, Convert.ToString(txtNAME.Value));

        if(txtGENDER.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.GENDER, Convert.ToString(txtGENDER.Value));

        if(txtTITLE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.TITLE, Convert.ToString(txtTITLE.Value));

        if(txtPAGER.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.PAGER, Convert.ToString(txtPAGER.Value));

        if(txtBIRTHDAY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.BIRTHDAY, Convert.ToDateTime(txtBIRTHDAY.Value));

        if(txtHIREDDAY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.HIREDDAY, Convert.ToDateTime(txtHIREDDAY.Value));

        if(txtSTREET.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.STREET, Convert.ToString(txtSTREET.Value));

        if(txtCITY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.CITY, Convert.ToString(txtCITY.Value));

        if(txtSTATE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.STATE, Convert.ToString(txtSTATE.Value));

        if(txtZIP.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.ZIP, Convert.ToString(txtZIP.Value));

        if(txtOPHONE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.OPHONE, Convert.ToString(txtOPHONE.Value));

        if(txtFPHONE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.FPHONE, Convert.ToString(txtFPHONE.Value));

        if(txtVERIFICATIONMETHOD.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.VERIFICATIONMETHOD, Convert.ToInt16(txtVERIFICATIONMETHOD.Value));

        if(txtDEFAULTDEPTID.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.DEFAULTDEPTID, Convert.ToInt16(txtDEFAULTDEPTID.Value));

        if(txtSECURITYFLAGS.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.SECURITYFLAGS, Convert.ToInt16(txtSECURITYFLAGS.Value));

        if(txtATT.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.ATT, Convert.ToInt16(txtATT.Value));

        if(txtINLATE.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.INLATE, Convert.ToInt16(txtINLATE.Value));

        if(txtOUTEARLY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.OUTEARLY, Convert.ToInt16(txtOUTEARLY.Value));

        if(txtOVERTIME.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.OVERTIME, Convert.ToInt16(txtOVERTIME.Value));

        if(txtSEP.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.SEP, Convert.ToInt16(txtSEP.Value));

        if(txtHOLIDAY.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.HOLIDAY, Convert.ToInt16(txtHOLIDAY.Value));

        if(txtMINZU.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.MINZU, Convert.ToString(txtMINZU.Value));

        if(txtPASSWORD.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.PASSWORD, Convert.ToString(txtPASSWORD.Value));

        if(txtLUNCHDURATION.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.LUNCHDURATION, Convert.ToInt16(txtLUNCHDURATION.Value));

        if(txtMVerifyPass.Value !="" )
            condObj.Like_OR(HR_CK_USERINFO.Attribute.MVerifyPass, Convert.ToString(txtMVerifyPass.Value));

        try
        {
            hidCondition.Value = condObj.ToJson(20);

            listObj = BLLTable<HR_CK_USERINFO>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
            repList.DataSource = listObj;
            repList.DataBind();
        }
        catch (Exception ex)
        {
             litWarn.Text = ex.Message;
        }
    }
Пример #17
0
    protected void Page_Load(object sender, EventArgs e)
    {
        title      = valObj._ZhName + "±à¼­";
        Page.Title = title;
        if (!string.IsNullOrEmpty(Request["USERID"]))
        {
            keyid = Request["USERID"];
        }

        if (!string.IsNullOrEmpty(Request["KeyID"]))
        {
            keyid = Request["KeyID"];
        }
        if (!IsPostBack)
        {
            txtBIRTHDAY.Value = (DateTime.Now).ToString("yyyy-MM-dd");
            txtHIREDDAY.Value = (DateTime.Now).ToString("yyyy-MM-dd");

            this.txtUSERID.Disabled            = true;
            this.txtUSERID.Attributes["class"] = "dis";
            try
            {
                if (keyid != "")
                {
                    valObj = BLLTable <HR_CK_USERINFO> .Factory(conn).GetRowData(HR_CK_USERINFO.Attribute.USERID, keyid);

                    if (valObj == null)
                    {
                        return;
                    }


                    txtUSERID.Value = Convert.ToString(valObj.USERID);//Convert.ToInt32

                    wucSelStaff1.Staff_ID   = Convert.ToDecimal(valObj.STAFF_ID);
                    wucSelStaff1.Staff_NAME = Convert.ToString(valObj.NAME);
                    //txtSTAFF_ID.Value = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal

                    txtBADGENUMBER.Value = Convert.ToString(valObj.BADGENUMBER); //Convert.ToString

                    txtSSN.Value = Convert.ToString(valObj.SSN);                 //Convert.ToString

                    txtNAME.Value = Convert.ToString(valObj.NAME);               //Convert.ToString

                    txtGENDER.Value = Convert.ToString(valObj.GENDER);           //Convert.ToString

                    txtTITLE.Value = Convert.ToString(valObj.TITLE);             //Convert.ToString

                    txtPAGER.Value = Convert.ToString(valObj.PAGER);             //Convert.ToString

                    txtBIRTHDAY.Value = (valObj.BIRTHDAY == DateTime.MinValue) ? "" : valObj.BIRTHDAY.ToString("yyyy-MM-dd");

                    txtHIREDDAY.Value = (valObj.HIREDDAY == DateTime.MinValue) ? "" : valObj.HIREDDAY.ToString("yyyy-MM-dd");

                    txtSTREET.Value = Convert.ToString(valObj.STREET);                         //Convert.ToString

                    txtCITY.Value = Convert.ToString(valObj.CITY);                             //Convert.ToString

                    txtSTATE.Value = Convert.ToString(valObj.STATE);                           //Convert.ToString

                    txtZIP.Value = Convert.ToString(valObj.ZIP);                               //Convert.ToString

                    txtOPHONE.Value = Convert.ToString(valObj.OPHONE);                         //Convert.ToString

                    txtFPHONE.Value = Convert.ToString(valObj.FPHONE);                         //Convert.ToString

                    txtVERIFICATIONMETHOD.Value = Convert.ToString(valObj.VERIFICATIONMETHOD); //Convert.ToInt16

                    txtDEFAULTDEPTID.Value = Convert.ToString(valObj.DEFAULTDEPTID);           //Convert.ToInt16

                    txtSECURITYFLAGS.Value = Convert.ToString(valObj.SECURITYFLAGS);           //Convert.ToInt16

                    txtATT.Value = Convert.ToString(valObj.ATT);                               //Convert.ToInt16

                    txtINLATE.Value = Convert.ToString(valObj.INLATE);                         //Convert.ToInt16

                    txtOUTEARLY.Value = Convert.ToString(valObj.OUTEARLY);                     //Convert.ToInt16

                    txtOVERTIME.Value = Convert.ToString(valObj.OVERTIME);                     //Convert.ToInt16

                    txtSEP.Value = Convert.ToString(valObj.SEP);                               //Convert.ToInt16

                    txtHOLIDAY.Value = Convert.ToString(valObj.HOLIDAY);                       //Convert.ToInt16

                    txtMINZU.Value = Convert.ToString(valObj.MINZU);                           //Convert.ToString

                    txtPASSWORD.Value = Convert.ToString(valObj.PASSWORD);                     //Convert.ToString

                    txtLUNCHDURATION.Value = Convert.ToString(valObj.LUNCHDURATION);           //Convert.ToInt16

                    txtMVerifyPass.Value = Convert.ToString(valObj.MVerifyPass);               //Convert.ToString

                    txtPHOTO.Value = Convert.ToString(valObj.PHOTO);                           //Convert.ToBase64CharArray
                }
            }
            catch (Exception ex)
            {
                litWarn.Text = ex.Message;
            }
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        #region//Ĭ�����ص���
        //hideTableColumnList = new List<AttributeItem>();
        //hideTableColumnList.Add(HR_CK_USERINFO.Attribute.EXP1);
        //hideTableColumnList.Add(HR_CK_USERINFO.Attribute.EXP2);
        //hideTableColumnList.Add(HR_CK_USERINFO.Attribute.EXP3);
        //valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
        //valObj.Remove(hideTableColumnList);

        //hideFindColumnList = new List<AttributeItem>();
        //hideFindColumnList.Add(HR_CK_USERINFO.Attribute.EXP1);
        //hideFindColumnList.Add(HR_CK_USERINFO.Attribute.EXP2);
        //hideFindColumnList.Add(HR_CK_USERINFO.Attribute.EXP3);
        #endregion
        condObj.OrderBy(HR_CK_USERINFO.Attribute.USERID, Order.Desc);

        if (!IsPostBack)
        {
            btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
            aspPager.PageSize = 10;
            aspPager.CurrentPageIndex = 1;

            if (!string.IsNullOrEmpty(Request["ids"]))
            {
                HR_CK_USERINFO roleOld = new HR_CK_USERINFO();
                roleOld.Where(HR_CK_USERINFO.Attribute.USERID, Request["ids"].ToString());
                listObj = BLLTable<HR_CK_USERINFO>.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].USERID + "',Name:'" + listObj[i].USERID + "'}";//�����Name������ʾ���б��У��������ض��塣
                    hidInitIDS.Value += listObj[i].USERID;
                }
            }
            try
            {

                listObj = BLLTable<HR_CK_USERINFO>.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;
            }

        }
    }
    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;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        title = valObj._ZhName + "�༭";
        Page.Title = title;
        if (!string.IsNullOrEmpty(Request["USERID"]))
        {
            keyid = Request["USERID"];
        }

        if (!string.IsNullOrEmpty(Request["KeyID"]))
        {
            keyid = Request["KeyID"];
        }
        if (!IsPostBack)
        {

            txtBIRTHDAY.Value = (DateTime.Now).ToString("yyyy-MM-dd");
            txtHIREDDAY.Value = (DateTime.Now).ToString("yyyy-MM-dd");

            this.txtUSERID.Disabled = true;
            this.txtUSERID.Attributes["class"] = "dis";
            try
            {
                if (keyid != "")
                {

                    valObj = BLLTable<HR_CK_USERINFO>.Factory(conn).GetRowData(HR_CK_USERINFO.Attribute.USERID, keyid);
                    if(valObj==null) return ;

                    txtUSERID.Value = Convert.ToString(valObj.USERID);//Convert.ToInt32

                    wucSelStaff1.Staff_ID = Convert.ToDecimal(valObj.STAFF_ID);
                    wucSelStaff1.Staff_NAME = Convert.ToString(valObj.NAME);
                    //txtSTAFF_ID.Value = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal

                    txtBADGENUMBER.Value = Convert.ToString(valObj.BADGENUMBER);//Convert.ToString

                    txtSSN.Value = Convert.ToString(valObj.SSN);//Convert.ToString

                    txtNAME.Value = Convert.ToString(valObj.NAME);//Convert.ToString

                    txtGENDER.Value = Convert.ToString(valObj.GENDER);//Convert.ToString

                    txtTITLE.Value = Convert.ToString(valObj.TITLE);//Convert.ToString

                    txtPAGER.Value = Convert.ToString(valObj.PAGER);//Convert.ToString

                    txtBIRTHDAY.Value = (valObj.BIRTHDAY == DateTime.MinValue) ? "" : valObj.BIRTHDAY.ToString("yyyy-MM-dd");

                    txtHIREDDAY.Value = (valObj.HIREDDAY == DateTime.MinValue) ? "" : valObj.HIREDDAY.ToString("yyyy-MM-dd");

                    txtSTREET.Value = Convert.ToString(valObj.STREET);//Convert.ToString

                    txtCITY.Value = Convert.ToString(valObj.CITY);//Convert.ToString

                    txtSTATE.Value = Convert.ToString(valObj.STATE);//Convert.ToString

                    txtZIP.Value = Convert.ToString(valObj.ZIP);//Convert.ToString

                    txtOPHONE.Value = Convert.ToString(valObj.OPHONE);//Convert.ToString

                    txtFPHONE.Value = Convert.ToString(valObj.FPHONE);//Convert.ToString

                    txtVERIFICATIONMETHOD.Value = Convert.ToString(valObj.VERIFICATIONMETHOD);//Convert.ToInt16

                    txtDEFAULTDEPTID.Value = Convert.ToString(valObj.DEFAULTDEPTID);//Convert.ToInt16

                    txtSECURITYFLAGS.Value = Convert.ToString(valObj.SECURITYFLAGS);//Convert.ToInt16

                    txtATT.Value = Convert.ToString(valObj.ATT);//Convert.ToInt16

                    txtINLATE.Value = Convert.ToString(valObj.INLATE);//Convert.ToInt16

                    txtOUTEARLY.Value = Convert.ToString(valObj.OUTEARLY);//Convert.ToInt16

                    txtOVERTIME.Value = Convert.ToString(valObj.OVERTIME);//Convert.ToInt16

                    txtSEP.Value = Convert.ToString(valObj.SEP);//Convert.ToInt16

                    txtHOLIDAY.Value = Convert.ToString(valObj.HOLIDAY);//Convert.ToInt16

                    txtMINZU.Value = Convert.ToString(valObj.MINZU);//Convert.ToString

                    txtPASSWORD.Value = Convert.ToString(valObj.PASSWORD);//Convert.ToString

                    txtLUNCHDURATION.Value = Convert.ToString(valObj.LUNCHDURATION);//Convert.ToInt16

                    txtMVerifyPass.Value = Convert.ToString(valObj.MVerifyPass);//Convert.ToString

                    txtPHOTO.Value = Convert.ToString(valObj.PHOTO);//Convert.ToBase64CharArray
                }
            }
            catch (Exception ex)
            {
                litWarn.Text = ex.Message;
            }
        }
    }
    protected void btnOK_Click(object sender, EventArgs e)
    {
        try
        {
            HR_CK_USERINFO valObj = new HR_CK_USERINFO();

            if(txtUSERID.Value !="" )
                valObj.USERID = Convert.ToInt32(txtUSERID.Value);

            if (wucSelStaff1.Staff_ID > 0)
                valObj.STAFF_ID = Convert.ToDecimal(wucSelStaff1.Staff_ID);

            if(txtBADGENUMBER.Value !="" )
                valObj.BADGENUMBER = Convert.ToString(txtBADGENUMBER.Value);

            if(txtSSN.Value !="" )
                valObj.SSN = Convert.ToString(txtSSN.Value);

            if(txtNAME.Value !="" )
                valObj.NAME = Convert.ToString(txtNAME.Value);

            if(txtGENDER.Value !="" )
                valObj.GENDER = Convert.ToString(txtGENDER.Value);

            if(txtTITLE.Value !="" )
                valObj.TITLE = Convert.ToString(txtTITLE.Value);

            if(txtPAGER.Value !="" )
                valObj.PAGER = Convert.ToString(txtPAGER.Value);

            if(txtBIRTHDAY.Value !="" )
                valObj.BIRTHDAY = Convert.ToDateTime(txtBIRTHDAY.Value);

            if(txtHIREDDAY.Value !="" )
                valObj.HIREDDAY = Convert.ToDateTime(txtHIREDDAY.Value);

            if(txtSTREET.Value !="" )
                valObj.STREET = Convert.ToString(txtSTREET.Value);

            if(txtCITY.Value !="" )
                valObj.CITY = Convert.ToString(txtCITY.Value);

            if(txtSTATE.Value !="" )
                valObj.STATE = Convert.ToString(txtSTATE.Value);

            if(txtZIP.Value !="" )
                valObj.ZIP = Convert.ToString(txtZIP.Value);

            if(txtOPHONE.Value !="" )
                valObj.OPHONE = Convert.ToString(txtOPHONE.Value);

            if(txtFPHONE.Value !="" )
                valObj.FPHONE = Convert.ToString(txtFPHONE.Value);

            if(txtVERIFICATIONMETHOD.Value !="" )
                valObj.VERIFICATIONMETHOD = Convert.ToInt16(txtVERIFICATIONMETHOD.Value);

            if(txtDEFAULTDEPTID.Value !="" )
                valObj.DEFAULTDEPTID = Convert.ToInt16(txtDEFAULTDEPTID.Value);

            if(txtSECURITYFLAGS.Value !="" )
                valObj.SECURITYFLAGS = Convert.ToInt16(txtSECURITYFLAGS.Value);

            if(txtATT.Value !="" )
                valObj.ATT = Convert.ToInt16(txtATT.Value);

            if(txtINLATE.Value !="" )
                valObj.INLATE = Convert.ToInt16(txtINLATE.Value);

            if(txtOUTEARLY.Value !="" )
                valObj.OUTEARLY = Convert.ToInt16(txtOUTEARLY.Value);

            if(txtOVERTIME.Value !="" )
                valObj.OVERTIME = Convert.ToInt16(txtOVERTIME.Value);

            if(txtSEP.Value !="" )
                valObj.SEP = Convert.ToInt16(txtSEP.Value);

            if(txtHOLIDAY.Value !="" )
                valObj.HOLIDAY = Convert.ToInt16(txtHOLIDAY.Value);

            if(txtMINZU.Value !="" )
                valObj.MINZU = Convert.ToString(txtMINZU.Value);

            if(txtPASSWORD.Value !="" )
                valObj.PASSWORD = Convert.ToString(txtPASSWORD.Value);

            if(txtLUNCHDURATION.Value !="" )
                valObj.LUNCHDURATION = Convert.ToInt16(txtLUNCHDURATION.Value);

            if(txtMVerifyPass.Value !="" )
                valObj.MVerifyPass = Convert.ToString(txtMVerifyPass.Value);

            if (keyid != "")
            {
                valObj.USERID = Convert.ToInt32(keyid);
                count = BLLTable<HR_CK_USERINFO>.Factory(conn).Update(valObj, HR_CK_USERINFO.Attribute.USERID);
            }
            else
            {
                count = BLLTable<HR_CK_USERINFO>.Factory(conn).Insert(valObj, HR_CK_USERINFO.Attribute.USERID);
                keyid = valObj.USERID.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 ="";

                    wucSelStaff1.Staff_ID = 0;

                    txtBADGENUMBER.Value ="";

                    txtSSN.Value ="";

                    txtNAME.Value ="";

                    txtGENDER.Value ="";

                    txtTITLE.Value ="";

                    txtPAGER.Value ="";

                    txtBIRTHDAY.Value ="";

                    txtHIREDDAY.Value ="";

                    txtSTREET.Value ="";

                    txtCITY.Value ="";

                    txtSTATE.Value ="";

                    txtZIP.Value ="";

                    txtOPHONE.Value ="";

                    txtFPHONE.Value ="";

                    txtVERIFICATIONMETHOD.Value ="";

                    txtDEFAULTDEPTID.Value ="";

                    txtSECURITYFLAGS.Value ="";

                    txtATT.Value ="";

                    txtINLATE.Value ="";

                    txtOUTEARLY.Value ="";

                    txtOVERTIME.Value ="";

                    txtSEP.Value ="";

                    txtHOLIDAY.Value ="";

                    txtMINZU.Value ="";

                    txtPASSWORD.Value ="";

                    txtLUNCHDURATION.Value ="";

                    txtMVerifyPass.Value ="";

                    txtPHOTO.Value ="";
                }
            }
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }
    private void UpdateStff(OleDbConnection conn2, string fangan)
    {
        if (conn2 == null)
            return;
        Dictionary<string, string> userFields = GetFieldsByFangAn(fangan, "USERINFO");
        if (!userFields.ContainsKey("*USERINFO"))
        {
            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["*USERINFO"];
        OleDbCommand com = new OleDbCommand(sql, conn2);
        OleDbDataReader dr = com.ExecuteReader();
        HR_CK_USERINFO hruser = new HR_CK_USERINFO();
        List<HR_CK_USERINFO> hrusers = new List<HR_CK_USERINFO>();
        Dictionary<string, HR_CK_USERINFO> userDic = new Dictionary<string, HR_CK_USERINFO>();
        List<HR_CK_USERINFO> chongfuUser = new List<HR_CK_USERINFO>();
        while (dr.Read())
        {
            try
            {
                hruser = new HR_CK_USERINFO();
                foreach (AttributeItem ai in hruser.af_AttributeItemList)
                {
                    if (userFields.ContainsKey("USERINFO_" + ai.FieldName))
                    {
                        object val = dr[userFields["USERINFO_" + ai.FieldName]];
                        if (val != null && !string.IsNullOrEmpty(val.ToString()))
                            hruser.SetValue(ai, val.ToString().Replace("?粀", "").Replace("\0", "").Replace("?", "").Replace("粀", ""));
                    }
                }
                hruser.Remove(new AttributeItem[] { HR_CK_USERINFO.Attribute.STAFF_ID });
                if (!userDic.ContainsKey(hruser.NAME))
                    userDic.Add(hruser.NAME, hruser);
                else
                    chongfuUser.Add(hruser);
                hrusers.Add(hruser);
            }
            catch { }
        }

        foreach (HR_CK_USERINFO user in chongfuUser)
        {
            if (userDic.ContainsKey(user.NAME))
                userDic.Remove(hruser.NAME);
        }

        HR_STAFF stfVal = new HR_STAFF();
        stfVal.STAFF_NAME = "";
        stfVal.STAFF_ID = 0;
        HR_STAFF stfCon = new HR_STAFF();
        List<HR_STAFF> stfList = BLLTable<HR_STAFF>.Factory(conn).Select(stfVal, stfCon);
        Dictionary<string, HR_STAFF> stfDic = new Dictionary<string, HR_STAFF>();
        List<HR_STAFF> chongfuStf = new List<HR_STAFF>();
        foreach (HR_STAFF stf in stfList)
        {
            if (!stfDic.ContainsKey(stf.STAFF_NAME))
                stfDic.Add(stf.STAFF_NAME, stf);
            else
                chongfuStf.Add(stf);
        }

        foreach (HR_STAFF stf in chongfuStf)
        {
            if (stfDic.ContainsKey(stf.STAFF_NAME))
                stfDic.Remove(stf.STAFF_NAME);
        }

        foreach (string name in userDic.Keys)
        {
            if (stfDic.ContainsKey(name))
            {
                HR_CK_USERINFO stfidcon = new HR_CK_USERINFO();//wcp考虑优化新能
                stfidcon.STAFF_ID = stfDic[name].STAFF_ID;
                if (!BLLTable<HR_CK_USERINFO>.Exists(stfidcon))
                    userDic[name].STAFF_ID = stfDic[name].STAFF_ID;
            }
        }

        int countok = 0;
        int countfi = 0;
        int counter = 0;
        foreach (HR_CK_USERINFO user in hrusers)
        {
            try
            {
                int count = 0;
                count = BLLTable<HR_CK_USERINFO>.SaveOrUpdate(user, HR_CK_USERINFO.Attribute.USERID);
                if (count > 0)
                    countok++;
                else
                    countfi++;
            }
            catch { counter++; }
        }

        Response.Write("同步员工信息数:" + hrusers.Count + "条" + "\n成功:" + countok + "条\n失败:" + countfi + "条\n出错:" + counter + "条");
    }
Пример #23
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        try
        {
            condObj = new HR_CK_USERINFO();



            if (txtUSERID.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.USERID, Convert.ToInt32(txtUSERID.Value));
            }


            if (txtSTAFF_ID.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.STAFF_ID, Convert.ToDecimal(txtSTAFF_ID.Value));
            }


            if (txtBADGENUMBER.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.BADGENUMBER, Convert.ToString(txtBADGENUMBER.Value));
            }


            if (txtSSN.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.SSN, Convert.ToString(txtSSN.Value));
            }


            if (txtNAME.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.NAME, Convert.ToString(txtNAME.Value));
            }


            if (txtGENDER.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.GENDER, Convert.ToString(txtGENDER.Value));
            }


            if (txtTITLE.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.TITLE, Convert.ToString(txtTITLE.Value));
            }


            if (txtPAGER.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.PAGER, Convert.ToString(txtPAGER.Value));
            }


            if (txtBIRTHDAY.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.BIRTHDAY, Convert.ToDateTime(txtBIRTHDAY.Value));
            }


            if (txtHIREDDAY.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.HIREDDAY, Convert.ToDateTime(txtHIREDDAY.Value));
            }


            if (txtSTREET.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.STREET, Convert.ToString(txtSTREET.Value));
            }


            if (txtCITY.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.CITY, Convert.ToString(txtCITY.Value));
            }


            if (txtSTATE.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.STATE, Convert.ToString(txtSTATE.Value));
            }


            if (txtZIP.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.ZIP, Convert.ToString(txtZIP.Value));
            }


            if (txtOPHONE.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.OPHONE, Convert.ToString(txtOPHONE.Value));
            }


            if (txtFPHONE.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.FPHONE, Convert.ToString(txtFPHONE.Value));
            }


            if (txtVERIFICATIONMETHOD.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.VERIFICATIONMETHOD, Convert.ToInt16(txtVERIFICATIONMETHOD.Value));
            }


            if (txtDEFAULTDEPTID.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.DEFAULTDEPTID, Convert.ToInt16(txtDEFAULTDEPTID.Value));
            }


            if (txtSECURITYFLAGS.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.SECURITYFLAGS, Convert.ToInt16(txtSECURITYFLAGS.Value));
            }


            if (txtATT.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.ATT, Convert.ToInt16(txtATT.Value));
            }


            if (txtINLATE.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.INLATE, Convert.ToInt16(txtINLATE.Value));
            }


            if (txtOUTEARLY.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.OUTEARLY, Convert.ToInt16(txtOUTEARLY.Value));
            }


            if (txtOVERTIME.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.OVERTIME, Convert.ToInt16(txtOVERTIME.Value));
            }


            if (txtSEP.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.SEP, Convert.ToInt16(txtSEP.Value));
            }


            if (txtHOLIDAY.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.HOLIDAY, Convert.ToInt16(txtHOLIDAY.Value));
            }


            if (txtMINZU.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.MINZU, Convert.ToString(txtMINZU.Value));
            }


            if (txtPASSWORD.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.PASSWORD, Convert.ToString(txtPASSWORD.Value));
            }


            if (txtLUNCHDURATION.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.LUNCHDURATION, Convert.ToInt16(txtLUNCHDURATION.Value));
            }


            if (txtMVerifyPass.Value != "")
            {
                condObj.Like(HR_CK_USERINFO.Attribute.MVerifyPass, Convert.ToString(txtMVerifyPass.Value));
            }


            listObj = BLLTable <HR_CK_USERINFO> .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;
    }
Пример #24
0
    protected void Page_Load(object sender, EventArgs e)
    {
        title      = valObj._ZhName + "详细";
        Page.Title = title;
        if (!IsPostBack)
        {
            try
            {
                if (!string.IsNullOrEmpty(Request["USERID"]))
                {
                    valObj = BLLTable <HR_CK_USERINFO> .Factory(conn).GetRowData(HR_CK_USERINFO.Attribute.USERID, Request["USERID"]);

                    if (valObj == null)
                    {
                        return;
                    }


                    txtUSERID.Text = Convert.ToString(valObj.USERID);//Convert.ToInt32


                    txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal


                    txtBADGENUMBER.Text = Convert.ToString(valObj.BADGENUMBER);//Convert.ToString


                    txtSSN.Text = Convert.ToString(valObj.SSN);//Convert.ToString


                    txtNAME.Text = Convert.ToString(valObj.NAME);//Convert.ToString


                    txtGENDER.Text = Convert.ToString(valObj.GENDER);//Convert.ToString


                    txtTITLE.Text = Convert.ToString(valObj.TITLE);//Convert.ToString


                    txtPAGER.Text = Convert.ToString(valObj.PAGER);//Convert.ToString


                    txtBIRTHDAY.Text = (valObj.BIRTHDAY == DateTime.MinValue) ? "" : valObj.BIRTHDAY.ToString("yyyy-MM-dd HH:mm");


                    txtHIREDDAY.Text = (valObj.HIREDDAY == DateTime.MinValue) ? "" : valObj.HIREDDAY.ToString("yyyy-MM-dd HH:mm");


                    txtSTREET.Text = Convert.ToString(valObj.STREET);//Convert.ToString


                    txtCITY.Text = Convert.ToString(valObj.CITY);//Convert.ToString


                    txtSTATE.Text = Convert.ToString(valObj.STATE);//Convert.ToString


                    txtZIP.Text = Convert.ToString(valObj.ZIP);//Convert.ToString


                    txtOPHONE.Text = Convert.ToString(valObj.OPHONE);//Convert.ToString


                    txtFPHONE.Text = Convert.ToString(valObj.FPHONE);//Convert.ToString


                    txtVERIFICATIONMETHOD.Text = Convert.ToString(valObj.VERIFICATIONMETHOD);//Convert.ToInt16


                    txtDEFAULTDEPTID.Text = Convert.ToString(valObj.DEFAULTDEPTID);//Convert.ToInt16


                    txtSECURITYFLAGS.Text = Convert.ToString(valObj.SECURITYFLAGS);//Convert.ToInt16


                    txtATT.Text = Convert.ToString(valObj.ATT);//Convert.ToInt16


                    txtINLATE.Text = Convert.ToString(valObj.INLATE);//Convert.ToInt16


                    txtOUTEARLY.Text = Convert.ToString(valObj.OUTEARLY);//Convert.ToInt16


                    txtOVERTIME.Text = Convert.ToString(valObj.OVERTIME);//Convert.ToInt16


                    txtSEP.Text = Convert.ToString(valObj.SEP);//Convert.ToInt16


                    txtHOLIDAY.Text = Convert.ToString(valObj.HOLIDAY);//Convert.ToInt16


                    txtMINZU.Text = Convert.ToString(valObj.MINZU);//Convert.ToString


                    txtPASSWORD.Text = Convert.ToString(valObj.PASSWORD);//Convert.ToString


                    txtLUNCHDURATION.Text = Convert.ToString(valObj.LUNCHDURATION);//Convert.ToInt16


                    txtMVerifyPass.Text = Convert.ToString(valObj.MVerifyPass);//Convert.ToString


                    txtPHOTO.Text = Convert.ToString(valObj.PHOTO);//Convert.ToBase64CharArray
                }
            }
            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();
            }
        }
    }
Пример #25
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string doType = Request["dotype"];
        string userid = Server.UrlDecode(Request["userid"]);

        if (string.IsNullOrEmpty(doType) || string.IsNullOrEmpty(userid))
        {
            Response.Write("user id is null");
            Response.End();
            return;
        }

        if (doType == "doUpdateCKUSERINFOStff")
        {
            try
            {
                string         stfid = Server.UrlDecode(Request["stfid"]);
                HR_CK_USERINFO user  = new HR_CK_USERINFO();
                user._USERID = Convert.ToInt32(userid);
                if (!string.IsNullOrEmpty(stfid) && stfid != "-")
                {
                    HR_CK_USERINFO userCon = new HR_CK_USERINFO();
                    userCon.STAFF_ID = Convert.ToInt32(stfid);
                    if (BLLTable <HR_CK_USERINFO> .Exists(userCon))
                    {
                        Response.Write("该员工已有对应关系!");
                    }
                    else
                    {
                        user.STAFF_ID = Convert.ToInt32(stfid);
                        if (BLLTable <HR_CK_USERINFO> .Factory(conn).Update(user, HR_CK_USERINFO.Attribute.USERID) > 0)
                        {
                            Response.Write("操作成功");
                        }
                        else
                        {
                            Response.Write("操作失败");
                        }
                    }
                }
                else
                {
                    user.STAFF_ID = 0;
                    if (BLLTable <HR_CK_USERINFO> .Factory(conn).Update(user, HR_CK_USERINFO.Attribute.USERID) > 0)
                    {
                        Response.Write("操作成功");
                    }
                    else
                    {
                        Response.Write("操作失败");
                    }
                }
            }
            catch (Exception ex)
            {
                Response.Write("操作失败!\r\n原因如下:\r\n----------\r\n" + ex.Message);
                Response.End();
            }
            Response.End();
        }
        else
        {
            Response.Write("不支持的操作!");
            Response.End();
            return;
        }
        Response.End();
    }
Пример #26
0
    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_CK_USERINFO condObj, int curPage)
    {
        if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
            condObj.af_PageBy(HR_CK_USERINFO.Attribute.USERID, Order.Asc);

        #region//����Ȩ������

        #endregion
        //condObj.PID = decimal.Parse(pid);

        HR_STAFF otherVal = new HR_STAFF();
        otherVal.STAFF_NAME = "";
        Relation r2 = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_CK_USERINFO.Attribute.STAFF_ID, RelationType.RightJoin);
        if (!string.IsNullOrEmpty(txtSTAFF_NAME.Value) || !string.IsNullOrEmpty(txtSTAFF_NO.Value))
        {
            HR_STAFF otherCon = new HR_STAFF();
            if (!string.IsNullOrEmpty(txtSTAFF_NAME.Value))
                otherCon.Like(HR_STAFF.Attribute.STAFF_NAME, txtSTAFF_NAME.Value);
            if (!string.IsNullOrEmpty(txtSTAFF_NO.Value))
                otherCon.Like(HR_STAFF.Attribute.STAFF_NO, txtSTAFF_NO.Value);
            listObj = BLLTable<HR_CK_USERINFO>.Factory(conn).SelectByPage(valObj, new List<Relation>(new Relation[] { r2 }), new List<ITableImplement>(new ITableImplement[] { otherVal }), new List<ITableImplement>(new ITableImplement[] { condObj, otherCon }), aspPager.PageSize, curPage, ref recount);
        }
        else
            listObj = BLLTable<HR_CK_USERINFO>.Factory(conn).SelectByPage(valObj, r2, otherVal, condObj, aspPager.PageSize, curPage, ref recount);
        repList.DataSource = listObj;
        repList.DataBind();
        aspPager.RecordCount = recount;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        title = valObj._ZhName + "��ϸ";
        Page.Title = title;
        if (!IsPostBack)
        {
            try
            {
                if (!string.IsNullOrEmpty(Request["USERID"]))
                {

                    valObj = BLLTable<HR_CK_USERINFO>.Factory(conn).GetRowData(HR_CK_USERINFO.Attribute.USERID, Request["USERID"]);
                    if(valObj==null) return ;

                    txtUSERID.Text = Convert.ToString(valObj.USERID);//Convert.ToInt32

                    txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal

                    txtBADGENUMBER.Text = Convert.ToString(valObj.BADGENUMBER);//Convert.ToString

                    txtSSN.Text = Convert.ToString(valObj.SSN);//Convert.ToString

                    txtNAME.Text = Convert.ToString(valObj.NAME);//Convert.ToString

                    txtGENDER.Text = Convert.ToString(valObj.GENDER);//Convert.ToString

                    txtTITLE.Text = Convert.ToString(valObj.TITLE);//Convert.ToString

                    txtPAGER.Text = Convert.ToString(valObj.PAGER);//Convert.ToString

                    txtBIRTHDAY.Text = (valObj.BIRTHDAY == DateTime.MinValue) ? "" : valObj.BIRTHDAY.ToString("yyyy-MM-dd HH:mm");

                    txtHIREDDAY.Text = (valObj.HIREDDAY == DateTime.MinValue) ? "" : valObj.HIREDDAY.ToString("yyyy-MM-dd HH:mm");

                    txtSTREET.Text = Convert.ToString(valObj.STREET);//Convert.ToString

                    txtCITY.Text = Convert.ToString(valObj.CITY);//Convert.ToString

                    txtSTATE.Text = Convert.ToString(valObj.STATE);//Convert.ToString

                    txtZIP.Text = Convert.ToString(valObj.ZIP);//Convert.ToString

                    txtOPHONE.Text = Convert.ToString(valObj.OPHONE);//Convert.ToString

                    txtFPHONE.Text = Convert.ToString(valObj.FPHONE);//Convert.ToString

                    txtVERIFICATIONMETHOD.Text = Convert.ToString(valObj.VERIFICATIONMETHOD);//Convert.ToInt16

                    txtDEFAULTDEPTID.Text = Convert.ToString(valObj.DEFAULTDEPTID);//Convert.ToInt16

                    txtSECURITYFLAGS.Text = Convert.ToString(valObj.SECURITYFLAGS);//Convert.ToInt16

                    txtATT.Text = Convert.ToString(valObj.ATT);//Convert.ToInt16

                    txtINLATE.Text = Convert.ToString(valObj.INLATE);//Convert.ToInt16

                    txtOUTEARLY.Text = Convert.ToString(valObj.OUTEARLY);//Convert.ToInt16

                    txtOVERTIME.Text = Convert.ToString(valObj.OVERTIME);//Convert.ToInt16

                    txtSEP.Text = Convert.ToString(valObj.SEP);//Convert.ToInt16

                    txtHOLIDAY.Text = Convert.ToString(valObj.HOLIDAY);//Convert.ToInt16

                    txtMINZU.Text = Convert.ToString(valObj.MINZU);//Convert.ToString

                    txtPASSWORD.Text = Convert.ToString(valObj.PASSWORD);//Convert.ToString

                    txtLUNCHDURATION.Text = Convert.ToString(valObj.LUNCHDURATION);//Convert.ToInt16

                    txtMVerifyPass.Text = Convert.ToString(valObj.MVerifyPass);//Convert.ToString

                    txtPHOTO.Text = Convert.ToString(valObj.PHOTO);//Convert.ToBase64CharArray

                }
            }
            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();
            }
        }
    }