Esempio n. 1
0
        public List<QhandyOR> GetBottomList(string wdbh,string pagewindID)
        {
            List<QhandyOR> listBottom = new List<QhandyOR>();

            DataTable dt = m_Qhand.selectAllDate(wdbh,pagewindID);
            foreach (DataRow dr in dt.Rows)
            {
                QhandyOR b = new QhandyOR(dr);
                listBottom.Add(b);
            }
            return listBottom;
        }
Esempio n. 2
0
 public bool Insert(QhandyOR obj)
 {
     return m_Qhand.Insert(obj);
 }
Esempio n. 3
0
        /// <summary>
        /// 插入T_QhandyOR
        /// </summary>
        public virtual bool Insert(QhandyOR qhandy)
        {
            string sql = @"insert into t_Qhandy (ID, OrgBH,  LABEL_VISIBLE, LABEL_CAPTION, LABEL_FONTCOLOR, LABEL_FONTNAME, LABEL_FONTUNDERLINE,
            LABEL_FONTITALIC, LABEL_FONTBOLD, LABEL_FONTSIZE, LABEL_TOP, LABEL_LEFT, LABEL_JOBNO, LABEL_JOBNAME, LABEL_PRINTSTR, LABEL_SHADE, TAG_VISIBLE,
            TAG_CAPTION, TAG_FONTCOLOR, TAG_FONTNAME, TAG_FONTUNDERLINE, TAG_FONTITALIC, TAG_FONTBOLD, TAG_FONTSIZE, TAG_TOPOFFSET, TAG_LEFTOFFSET, LABEL_TYPE,
            ENLABEL_VISIBLE, ENLABEL_CAPTION, ENLABEL_FONTCOLOR, ENLABEL_FONTNAME, ENLABEL_FONTITALIC, ENLABEL_FONTUNDERLINE, ENLABEL_FONTBOLD, ENLABEL_FONTSIZE,
            SCREENTYPE, ENLABEL_LEFTOFFSET, ENLABEL_TOPOFFSET,ButtomType, windowOnID, windowID
            ,LABEL_Height,LABEL_Width,LABEL_BG)
            values (@ID, @OrgBH, @LABEL_VISIBLE, @LABEL_CAPTION, @LABEL_FONTCOLOR, @LABEL_FONTNAME, @LABEL_FONTUNDERLINE, @LABEL_FONTITALIC, @LABEL_FONTBOLD, @LABEL_FONTSIZE,
            @LABEL_TOP, @LABEL_LEFT, @LABEL_JOBNO, @LABEL_JOBNAME, @LABEL_PRINTSTR, @LABEL_SHADE, @TAG_VISIBLE, @TAG_CAPTION, @TAG_FONTCOLOR, @TAG_FONTNAME, @TAG_FONTUNDERLINE,
            @TAG_FONTITALIC, @TAG_FONTBOLD, @TAG_FONTSIZE, @TAG_TOPOFFSET, @TAG_LEFTOFFSET, @LABEL_TYPE, @ENLABEL_VISIBLE, @ENLABEL_CAPTION, @ENLABEL_FONTCOLOR,
            @ENLABEL_FONTNAME, @ENLABEL_FONTITALIC, @ENLABEL_FONTUNDERLINE, @ENLABEL_FONTBOLD, @ENLABEL_FONTSIZE, @SCREENTYPE, @ENLABEL_LEFTOFFSET,
            @ENLABEL_TOPOFFSET,@ButtomType, @windowOnID, @windowID
            ,@LABEL_Height,@LABEL_Width,@LABEL_BG)";
            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@ID", SqlDbType.Char, 36, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, qhandy.Id),
                new SqlParameter("@OrgBH", SqlDbType.VarChar, 64, ParameterDirection.Input, false, 0, 0, "OrgBH", DataRowVersion.Default, qhandy.Orgbh),
                //new SqlParameter("@LABEL_IDX", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LABEL_IDX", DataRowVersion.Default, qhandy.LabelIdx),
                new SqlParameter("@LABEL_VISIBLE", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "LABEL_VISIBLE", DataRowVersion.Default, qhandy.LabelVisible),
                new SqlParameter("@LABEL_CAPTION", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "LABEL_CAPTION", DataRowVersion.Default, qhandy.LabelCaption),
                new SqlParameter("@LABEL_FONTCOLOR", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LABEL_FONTCOLOR", DataRowVersion.Default, qhandy.LabelFontcolor),
                new SqlParameter("@LABEL_FONTNAME", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "LABEL_FONTNAME", DataRowVersion.Default, qhandy.LabelFontname),
                new SqlParameter("@LABEL_FONTUNDERLINE", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "LABEL_FONTUNDERLINE", DataRowVersion.Default, qhandy.LabelFontunderline),
                new SqlParameter("@LABEL_FONTITALIC", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "LABEL_FONTITALIC", DataRowVersion.Default, qhandy.LabelFontitalic),
                new SqlParameter("@LABEL_FONTBOLD", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "LABEL_FONTBOLD", DataRowVersion.Default, qhandy.LabelFontbold),
                new SqlParameter("@LABEL_FONTSIZE", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LABEL_FONTSIZE", DataRowVersion.Default, qhandy.LabelFontsize),
                new SqlParameter("@LABEL_TOP", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LABEL_TOP", DataRowVersion.Default, qhandy.LabelTop),
                new SqlParameter("@LABEL_LEFT", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LABEL_LEFT", DataRowVersion.Default, qhandy.LabelLeft),
                new SqlParameter("@LABEL_JOBNO", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "LABEL_JOBNO", DataRowVersion.Default, qhandy.LabelJobno),
                new SqlParameter("@LABEL_JOBNAME", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "LABEL_JOBNAME", DataRowVersion.Default, qhandy.LabelJobname),
                new SqlParameter("@LABEL_PRINTSTR", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "LABEL_PRINTSTR", DataRowVersion.Default, qhandy.LabelPrintstr),
                new SqlParameter("@LABEL_SHADE", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "LABEL_SHADE", DataRowVersion.Default, qhandy.LabelShade),
                new SqlParameter("@TAG_VISIBLE", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "TAG_VISIBLE", DataRowVersion.Default, qhandy.TagVisible),
                new SqlParameter("@TAG_CAPTION", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "TAG_CAPTION", DataRowVersion.Default, qhandy.TagCaption),
                new SqlParameter("@TAG_FONTCOLOR", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "TAG_FONTCOLOR", DataRowVersion.Default, qhandy.TagFontcolor),
                new SqlParameter("@TAG_FONTNAME", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "TAG_FONTNAME", DataRowVersion.Default, qhandy.TagFontname),
                new SqlParameter("@TAG_FONTUNDERLINE", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "TAG_FONTUNDERLINE", DataRowVersion.Default, qhandy.TagFontunderline),
                new SqlParameter("@TAG_FONTITALIC", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "TAG_FONTITALIC", DataRowVersion.Default, qhandy.TagFontitalic),
                new SqlParameter("@TAG_FONTBOLD", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "TAG_FONTBOLD", DataRowVersion.Default, qhandy.TagFontbold),
                new SqlParameter("@TAG_FONTSIZE", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "TAG_FONTSIZE", DataRowVersion.Default, qhandy.TagFontsize),
                new SqlParameter("@TAG_TOPOFFSET", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "TAG_TOPOFFSET", DataRowVersion.Default, qhandy.TagTopoffset),
                new SqlParameter("@TAG_LEFTOFFSET", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "TAG_LEFTOFFSET", DataRowVersion.Default, qhandy.TagLeftoffset),
                new SqlParameter("@LABEL_TYPE", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "LABEL_TYPE", DataRowVersion.Default, qhandy.LabelType),
                new SqlParameter("@ENLABEL_VISIBLE", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "ENLABEL_VISIBLE", DataRowVersion.Default, qhandy.EnlabelVisible),
                new SqlParameter("@ENLABEL_CAPTION", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "ENLABEL_CAPTION", DataRowVersion.Default, qhandy.EnlabelCaption),
                new SqlParameter("@ENLABEL_FONTCOLOR", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ENLABEL_FONTCOLOR", DataRowVersion.Default, qhandy.EnlabelFontcolor),
                new SqlParameter("@ENLABEL_FONTNAME", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "ENLABEL_FONTNAME", DataRowVersion.Default, qhandy.EnlabelFontname),
                new SqlParameter("@ENLABEL_FONTITALIC", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "ENLABEL_FONTITALIC", DataRowVersion.Default, qhandy.EnlabelFontitalic),
                new SqlParameter("@ENLABEL_FONTUNDERLINE", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "ENLABEL_FONTUNDERLINE", DataRowVersion.Default, qhandy.EnlabelFontunderline),
                new SqlParameter("@ENLABEL_FONTBOLD", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "ENLABEL_FONTBOLD", DataRowVersion.Default, qhandy.EnlabelFontbold),
                new SqlParameter("@ENLABEL_FONTSIZE", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ENLABEL_FONTSIZE", DataRowVersion.Default, qhandy.EnlabelFontsize),
                new SqlParameter("@SCREENTYPE", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "SCREENTYPE", DataRowVersion.Default, qhandy.Screentype),
                new SqlParameter("@ENLABEL_LEFTOFFSET", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ENLABEL_LEFTOFFSET", DataRowVersion.Default, qhandy.EnlabelLeftoffset),
                new SqlParameter("@ENLABEL_TOPOFFSET", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ENLABEL_TOPOFFSET", DataRowVersion.Default, qhandy.EnlabelTopoffset),
                new SqlParameter("@ButtomType", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "ButtomType", DataRowVersion.Default, qhandy.ButtomType),
                new SqlParameter("@windowOnID", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "windowOnID", DataRowVersion.Default, qhandy.Windowonid),
                new SqlParameter("@windowID", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "windowID", DataRowVersion.Default, qhandy.Windowid),

                new SqlParameter("@LABEL_BG", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "LABEL_BG", DataRowVersion.Default, qhandy.Bg),
                new SqlParameter("@LABEL_Height", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "LABEL_Height", DataRowVersion.Default, qhandy.ButtonHeight),
                new SqlParameter("@LABEL_Width", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "LABEL_Width", DataRowVersion.Default, qhandy.ButtonWidth)
            };
            return db.ExecuteNoQuery(sql, parameters) > -1;
        }
Esempio n. 4
0
 public QhandyOR selectARowDate(string m_id)
 {
     string sql = string.Format("select * from T_QHANDY where string id='{0}'", m_id);
     DataTable dt = null;
     try
     {
         dt = db.ExecuteQuery(sql);
     }
     catch (Exception ex)
     {
         throw ex;
     }
     if (dt == null)
         return null;
     if (dt.Rows.Count == 0)
         return null;
     DataRow dr = dt.Rows[0];
     QhandyOR m_QHAN = new QhandyOR(dr);
     return m_QHAN;
 }