Exemple #1
0
    //檢查此功能是否已被其他人鎖定
    //Retrun 0:無任何鎖定記錄 -1:有自己的鎖定記錄 1:有他人的鎖定記錄
    private int QueryControlChk(out string strLockUID, out string strLockTime, out string strLockUserName)
    {
        int iResult = 0;
        strLockUserName = "";//鎖定的使用者
        strLockUID = "";
        strLockTime = "";

        CAAModel.MaintainAccountRecord BCO = new CAAModel.MaintainAccountRecord(ConntionDB);

        ParameterList.Clear();
        ParameterList.Add("CAA11");

        DataTable dt = BCO.QueryControlChk(ParameterList);

        if (dt.Rows.Count > 0)
        {
            string strID = dt.Rows[0]["ID"].ToString();
            strLockUID = dt.Rows[0]["CREATEUID"].ToString();
            strLockTime = dt.Rows[0]["CREATEDATE"].ToString();
            if ((strLockTime == ViewState["LockTime"].ToString()) &&
                (strLockUID == Session["UID"].ToString()) &&
                (strID == ViewState["LockID"].ToString())
               )
            {
                iResult = -1;
            }
            else
            {
                iResult = 1;
                strLockUserName = dt.Rows[0]["USER_NAME"].ToString(); ;
            }
        }
        else
        {
            iResult = 0;
        }
        return iResult;
    }