internal static SYQMKHInfo GetInfoById(int innerid) { SYQMKHInfo info = new SYQMKHInfo(); DataTable dt = SQLHelper.ExecuteDataTable("select * from T_syqmkh where id = @id", innerid); info.Id = innerid; info.EntryDate = Convert.ToDateTime(dt.Rows[0]["entrydate"].ToString()); info.PassDate = Convert.ToDateTime(dt.Rows[0]["passdate"].ToString()); info.AttachContent = dt.Rows[0]["valuation"].ToString(); return(info); }
internal static int UpdateInfo(SYQMKHInfo syqmkhinfo, int id) { object obj = SQLHelper.ExecuteNonQuery("update T_syqmkh set entrydate=@entrydate, passdate=@passdate, valuation=@valuation, where id=@id", syqmkhinfo.EntryDate, syqmkhinfo.PassDate, syqmkhinfo.AttachContent, id); return(Convert.ToInt32(obj)); }
internal static int AddInfo(SYQMKHInfo syqmkhinfo) { object obj = SQLHelper.ExecuteScalar("insert into T_syqmkh(entrydate, passdate, valuation) output inserted.id values(@entrydate, @passdate, @valuation)", syqmkhinfo.EntryDate, syqmkhinfo.PassDate, syqmkhinfo.AttachContent); return(Convert.ToInt32(obj)); }