コード例 #1
0
        /// <summary>
        /// 得到一个视图model
        /// </summary>
        /// <param name="id">主键值</param>
        /// <returns>model</returns>
        public vLWorkPlatformData GetVModel(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(@"select id,workPlatformNo,workPlatformNm,putBoxNum,isDel,isrtEmpId,isrtDt,updtEmpId,updtDt,isrtEmpNm,updtEmpNm from vLWorkPlatform");
            strSql.Append(" where id = @id ");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int)
                };
            parameters[0].Value = id;

            vLWorkPlatformData model = new vLWorkPlatformData();
            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["workPlatformNo"] != DBNull.Value)
                {
                    model.workPlatformNo = Convert.ToString(row["workPlatformNo"]);
                }
                if (row["workPlatformNm"] != DBNull.Value)
                {
                    model.workPlatformNm = Convert.ToString(row["workPlatformNm"]);
                }
                if (row["putBoxNum"] != DBNull.Value)
                {
                    model.putBoxNum = Convert.ToInt32(row["putBoxNum"]);
                }
                if (row["isDel"] != DBNull.Value)
                {
                    model.isDel = Convert.ToBoolean(row["isDel"]);
                }
                if (row["isrtEmpId"] != DBNull.Value)
                {
                    model.isrtEmpId = Convert.ToInt32(row["isrtEmpId"]);
                }
                if (row["isrtDt"] != DBNull.Value)
                {
                    model.isrtDt = Convert.ToString(row["isrtDt"]);
                }
                if (row["updtEmpId"] != DBNull.Value)
                {
                    model.updtEmpId = Convert.ToInt32(row["updtEmpId"]);
                }
                if (row["updtDt"] != DBNull.Value)
                {
                    model.updtDt = Convert.ToString(row["updtDt"]);
                }
                if (row["isrtEmpNm"] != DBNull.Value)
                {
                    model.isrtEmpNm = Convert.ToString(row["isrtEmpNm"]);
                }
                if (row["updtEmpNm"] != DBNull.Value)
                {
                    model.updtEmpNm = Convert.ToString(row["updtEmpNm"]);
                }
                return model;
            }
            else
            {
                return null;
            }
        }
コード例 #2
0
    /// <summary>
    /// 展示数据
    /// </summary>
    /// <param name="id">记录Id</param>
    private void ShowInfo(int id)
    {
        LWorkPlatformBB workPlatformBB = new LWorkPlatformBB();
        vLWorkPlatformData model = new vLWorkPlatformData();

        try
        {
            model = workPlatformBB.GetVModel(id);
            this.tbWorkPlatformNo.Text = model.workPlatformNo;
            this.tbWorkPlatformNm.Text = model.workPlatformNm;
        }
        finally
        {
            workPlatformBB.Dispose();
        }
    }