/// <summary> /// 插入t_Element_Library /// </summary> public virtual bool Insert(t_Element_Library elementLibrary) { string sql = "insert into t_Element_Library (ElementID, ElementName, ControlID, ScreenX, ScreenY, TxtInfo, Width, Height, ImageURL, ForeColor, Font, ChildScreenID, DeviceID, ChannelNo, ScreenID, BackColor, Transparent, oldX, oldY, Method, MinFloat, MaxFloat, SerialNum, TotalLength) values (@ElementID, @ElementName, @ControlID, @ScreenX, @ScreenY, @TxtInfo, @Width, @Height, @ImageURL, @ForeColor, @Font, @ChildScreenID, @DeviceID, @ChannelNo, @ScreenID, @BackColor, @Transparent, @oldX, @oldY, @Method, @MinFloat, @MaxFloat, @SerialNum, @TotalLength)"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ElementID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ElementID", DataRowVersion.Default, elementLibrary.Elementid), new SqlParameter("@ElementName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ElementName", DataRowVersion.Default, elementLibrary.Elementname), new SqlParameter("@ControlID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ControlID", DataRowVersion.Default, elementLibrary.Controlid), new SqlParameter("@ScreenX", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ScreenX", DataRowVersion.Default, elementLibrary.Screenx), new SqlParameter("@ScreenY", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ScreenY", DataRowVersion.Default, elementLibrary.Screeny), new SqlParameter("@TxtInfo", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "TxtInfo", DataRowVersion.Default, elementLibrary.Txtinfo), new SqlParameter("@Width", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Width", DataRowVersion.Default, elementLibrary.Width), new SqlParameter("@Height", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Height", DataRowVersion.Default, elementLibrary.Height), new SqlParameter("@ImageURL", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "ImageURL", DataRowVersion.Default, elementLibrary.Imageurl), new SqlParameter("@ForeColor", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "ForeColor", DataRowVersion.Default, elementLibrary.Forecolor), new SqlParameter("@Font", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Font", DataRowVersion.Default, elementLibrary.Font), new SqlParameter("@ChildScreenID", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ChildScreenID", DataRowVersion.Default, elementLibrary.Childscreenid), new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, elementLibrary.Deviceid), new SqlParameter("@ChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ChannelNo", DataRowVersion.Default, elementLibrary.Channelno), new SqlParameter("@ScreenID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ScreenID", DataRowVersion.Default, elementLibrary.Screenid), new SqlParameter("@BackColor", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "BackColor", DataRowVersion.Default, elementLibrary.Backcolor), new SqlParameter("@Transparent", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Transparent", DataRowVersion.Default, elementLibrary.Transparent), new SqlParameter("@oldX", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "oldX", DataRowVersion.Default, elementLibrary.Oldx), new SqlParameter("@oldY", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "oldY", DataRowVersion.Default, elementLibrary.Oldy), new SqlParameter("@Method", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Method", DataRowVersion.Default, elementLibrary.Method), new SqlParameter("@MinFloat", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "MinFloat", DataRowVersion.Default, elementLibrary.Minfloat), new SqlParameter("@MaxFloat", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "MaxFloat", DataRowVersion.Default, elementLibrary.Maxfloat), new SqlParameter("@SerialNum", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "SerialNum", DataRowVersion.Default, elementLibrary.Serialnum), new SqlParameter("@TotalLength", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "TotalLength", DataRowVersion.Default, elementLibrary.Totallength) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public List<t_Element_Library> selectAllDate() { string sql = "select * from t_Element_Library"; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } List<t_Element_Library> _List = new List<t_Element_Library>(); foreach (DataRow dr in dt.Rows) { t_Element_Library obj = new t_Element_Library(dr); _List.Add(obj); } return _List; }
public t_Element_Library selectARowDate(string m_id) { string sql = string.Format("select * from t_Element_Library where Elementid='{0}'", m_id); DataTable dt = null; try { dt = db.ExecuteQueryDataSet(sql).Tables[0]; } catch (Exception ex) { throw ex; } if (dt == null) return null; if (dt.Rows.Count == 0) return null; DataRow dr = dt.Rows[0]; t_Element_Library m_Elem = new t_Element_Library(dr); return m_Elem; }
public void Clone(t_Element_Library obj) { // Elementid = obj.Elementid; // Elementname = obj.Elementname; // Controlid = obj.Controlid; // Screenx = obj.Screenx; // Screeny = obj.Screeny; // Txtinfo = obj.Txtinfo; // Width = obj.Width; // Height = obj.Height; // Imageurl = obj.Imageurl; // Forecolor = obj.Forecolor; // Font = obj.Font; // Childscreenid = obj.Childscreenid; // Deviceid = obj.Deviceid; // Channelno = obj.Channelno; // Screenid = obj.Screenid; // Backcolor = obj.Backcolor; // Transparent = obj.Transparent; // Oldx = obj.Oldx; // Oldy = obj.Oldy; // Method = obj.Method; // Minfloat = obj.Minfloat; // Maxfloat = obj.Maxfloat; // Serialnum = obj.Serialnum; // Totallength = obj.Totallength; }