private void ShowInfo(int id)
 {
     WFunctionStepBB functionStepBB = new WFunctionStepBB();
     vWFunctionStepData model = new vWFunctionStepData();
     try
     {
         model = functionStepBB.GetVModel(id);
         this.functionNo.Text = model.functionNo;
         this.stepNo.Text = model.stepNo.ToString();
         this.seq.Text = model.seq.ToString();
         this.stepNm.Text = model.stepNm;
         this.doEmp.Text = model.doEmp;
         this.isUseEmpDo.Text = model.isUseEmpDo.ToString();
         this.isUseEmpLeaderDo.Text = model.isUseEmpLeaderDo.ToString();
         this.condition.Text = model.condition;
     }
     finally
     {
         functionStepBB.Dispose();
     }
 }
        /// <summary>
        /// �õ�һ����ͼmodel
        /// </summary>
        /// <param name="id">����ֵ</param>
        /// <returns>model</returns>
        public vWFunctionStepData GetVModel(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from vWFunctionStep");
            strSql.Append(" where id = @id ");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int)
                };
            parameters[0].Value = id;

            vWFunctionStepData model = new vWFunctionStepData();
            DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow row = ds.Tables[0].Rows[0];
                if (row["id"] != DBNull.Value)
                {
                    model.id = Convert.ToInt32(row["id"]);
                }
                if (row["functionNo"] != DBNull.Value)
                {
                    model.functionNo = Convert.ToString(row["functionNo"]);
                }
                if (row["stepNo"] != DBNull.Value)
                {
                    model.stepNo = Convert.ToInt32(row["stepNo"]);
                }
                if (row["seq"] != DBNull.Value)
                {
                    model.seq = Convert.ToInt32(row["seq"]);
                }
                if (row["stepNm"] != DBNull.Value)
                {
                    model.stepNm = Convert.ToString(row["stepNm"]);
                }
                if (row["doEmp"] != DBNull.Value)
                {
                    model.doEmp = Convert.ToString(row["doEmp"]);
                }
                if (row["isUseEmpDo"] != DBNull.Value)
                {
                    model.isUseEmpDo = Convert.ToBoolean(row["isUseEmpDo"]);
                }
                if (row["isUseEmpLeaderDo"] != DBNull.Value)
                {
                    model.isUseEmpLeaderDo = Convert.ToBoolean(row["isUseEmpLeaderDo"]);
                }
                if (row["condition"] != DBNull.Value)
                {
                    model.condition = Convert.ToString(row["condition"]);
                }
                if (row["remark"] != DBNull.Value)
                {
                    model.remark = Convert.ToString(row["remark"]);
                }
                if (row["coordinateX"] != DBNull.Value)
                {
                    model.coordinateX = Convert.ToInt32(row["coordinateX"]);
                }
                if (row["coordinateY"] != DBNull.Value)
                {
                    model.coordinateY = Convert.ToInt32(row["coordinateY"]);
                }
                if (row["functionNm"] != DBNull.Value)
                {
                    model.functionNm = Convert.ToString(row["functionNm"]);
                }
                if (row["functionUrl"] != DBNull.Value)
                {
                    model.functionUrl = Convert.ToString(row["functionUrl"]);
                }
                if (row["functionChangeUrl"] != DBNull.Value)
                {
                    model.functionChangeUrl = Convert.ToString(row["functionChangeUrl"]);
                }
                if (row["useEmpField"] != DBNull.Value)
                {
                    model.useEmpField = Convert.ToString(row["useEmpField"]);
                }
                if (row["auditEmpIdField"] != DBNull.Value)
                {
                    model.auditEmpIdField = Convert.ToString(row["auditEmpIdField"]);
                }
                if (row["auditDtField"] != DBNull.Value)
                {
                    model.auditDtField = Convert.ToString(row["auditDtField"]);
                }
                if (row["workFlowStateField"] != DBNull.Value)
                {
                    model.workFlowStateField = Convert.ToString(row["workFlowStateField"]);
                }
                if (row["workFlowSeqField"] != DBNull.Value)
                {
                    model.workFlowSeqField = Convert.ToString(row["workFlowSeqField"]);
                }
                if (row["auditMarkField"] != DBNull.Value)
                {
                    model.auditMarkField = Convert.ToString(row["auditMarkField"]);
                }
                if (row["auditDegreeField"] != DBNull.Value)
                {
                    model.auditDegreeField = Convert.ToString(row["auditDegreeField"]);
                }
                if (row["changeWindowHeight"] != DBNull.Value)
                {
                    model.changeWindowHeight = Convert.ToInt32(row["changeWindowHeight"]);
                }
                if (row["changeWindowWidth"] != DBNull.Value)
                {
                    model.changeWindowWidth = Convert.ToInt32(row["changeWindowWidth"]);
                }
                if (row["windowHeight"] != DBNull.Value)
                {
                    model.windowHeight = Convert.ToInt32(row["windowHeight"]);
                }
                if (row["windowWidth"] != DBNull.Value)
                {
                    model.windowWidth = Convert.ToInt32(row["windowWidth"]);
                }
                if (row["isAutoAudit"] != DBNull.Value)
                {
                    model.isAutoAudit = Convert.ToBoolean(row["isAutoAudit"]);
                }
                if (row["isDraw"] != DBNull.Value)
                {
                    model.isDraw = Convert.ToBoolean(row["isDraw"]);
                }
                if (row["workflowNm"] != DBNull.Value)
                {
                    model.workflowNm = Convert.ToString(row["workflowNm"]);
                }
                if (row["workTableNm"] != DBNull.Value)
                {
                    model.workTableNm = Convert.ToString(row["workTableNm"]);
                }
                if (row["recordKeyField"] != DBNull.Value)
                {
                    model.recordKeyField = Convert.ToString(row["recordKeyField"]);
                }
                if (row["keyIsInt"] != DBNull.Value)
                {
                    model.keyIsInt = Convert.ToBoolean(row["keyIsInt"]);
                }
                if (row["titleField"] != DBNull.Value)
                {
                    model.titleField = Convert.ToString(row["titleField"]);
                }
                if (row["itemNo"] != DBNull.Value)
                {
                    model.itemNo = Convert.ToString(row["itemNo"]);
                }
                if (row["isRun"] != DBNull.Value)
                {
                    model.isRun = Convert.ToBoolean(row["isRun"]);
                }
                if (row["stopMark"] != DBNull.Value)
                {
                    model.stopMark = Convert.ToString(row["stopMark"]);
                }
                return model;
            }
            else
            {
                return null;
            }
        }