/// <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;
}
