internal static QTJLInfo GetInfoById(int innerid) { QTJLInfo info = new QTJLInfo(); DataTable dt = SQLHelper.ExecuteDataTable("select * from T_qtjl where id = @id", innerid); info.Id = innerid; info.VisitorId = Convert.ToInt32(dt.Rows[0]["visitorid"]); info.BeVisitor = dt.Rows[0]["bevisitor"].ToString(); info.Property = dt.Rows[0]["property"].ToString(); info.BeginTime = Convert.ToDateTime(dt.Rows[0]["begintime"].ToString()); info.EndTime = Convert.ToDateTime(dt.Rows[0]["endtime"].ToString()); info.AttachContent = dt.Rows[0]["attachcontent"].ToString(); return(info); }
internal static int UpdateInfo(QTJLInfo qtjlinfo, int id) { object obj = SQLHelper.ExecuteNonQuery("update T_qtjl set visitorid=@visitorid, bevisitor=@bevisitor, property=@bevisitor, begintime=@begintime, endtime=@endtime, attachcontent=@attachcontent where id=@id", qtjlinfo.VisitorId, qtjlinfo.BeVisitor, qtjlinfo.Property, qtjlinfo.BeginTime, qtjlinfo.EndTime, qtjlinfo.AttachContent, id); return(Convert.ToInt32(obj)); }
internal static int AddInfo(QTJLInfo qtjlinfo) { object obj = SQLHelper.ExecuteScalar("insert into T_qtjl(visitorid, bevisitor, property, begintime, endtime, attachcontent) output inserted.id values(@visitorid, @bevisitor, @property, @begintime, @endtime, @attachcontent)", qtjlinfo.VisitorId, qtjlinfo.BeVisitor, qtjlinfo.Property, qtjlinfo.BeginTime, qtjlinfo.EndTime, qtjlinfo.AttachContent); return(Convert.ToInt32(obj)); }