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; }
public bool Insert(QhandyOR obj) { return m_Qhand.Insert(obj); }
/// <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; }
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; }