/// <summary> /// 保存数据 /// </summary> /// <param name="GUID"></param> /// <param name="entity"></param> /// <returns></returns> public int FormSave(TaskLogEntity entity) { try { List <OleDbParameter> parameter = new List <OleDbParameter>(); string SqlStr = ""; if (AccessHelper.ExecuteDataSet(AccessHelper.conn, "select * from " + entity.GetType().Name + " where [GUID]=@GUID", new OleDbParameter("@GUID", entity.GUID)).Tables[0].Rows.Count > 0) { SqlStr = "update " + entity.GetType().Name + " set "; PropertyInfo[] properties = entity.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public); foreach (PropertyInfo item in properties) {//循环遍历实体,取出字段和字段对应的值 if (item.GetValue(entity, null) != null) { if (item.Name != "GUID") { SqlStr += (SqlStr.EndsWith("set ") ? "" : ",") + "[" + item.Name + "]=@" + item.Name; parameter.Add(new OleDbParameter("@" + item.Name, item.GetValue(entity, null).ToString())); } } } SqlStr += " where [GUID]=@GUID"; } else { string Field = "", Variable = ""; PropertyInfo[] properties = entity.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public); foreach (PropertyInfo item in properties) {//循环遍历实体,取出字段和字段对应的值 if (item.GetValue(entity, null) != null) { Field += (Field == "" ? "" : ",") + "[" + item.Name + "]"; Variable += (Variable == "" ? "" : ",") + "@" + item.Name; parameter.Add(new OleDbParameter("@" + item.Name, item.GetValue(entity, null).ToString())); } } SqlStr = "insert into " + entity.GetType().Name + "(" + Field + ") values(" + Variable + ")"; } int mm = AccessHelper.ExecuteNonQuery(AccessHelper.conn, SqlStr, parameter.ToArray()); return(mm); } catch (Exception ex) { } return(0); }
static public TaskLogEntity GetLogEntity(string GUID) { TaskLogEntity entity = new TaskLogEntity(); //try //{ // XmlDocument xmlDoc = new XmlDocument(); // xmlDoc.Load(HttpContext.Current.Server.MapPath("/Log/Log.xml")); // XmlNode node = xmlDoc.SelectSingleNode("/DataItem/Log[@GUID='" + GUID + "']"); // if (node != null) // {//日志存在就进行修改 // //node.SelectSingleNode("ErrorMsg").InnerText = entity.ErrorMsg; // //node.SelectSingleNode("Status").InnerText = entity.Status; // //node.SelectSingleNode("Type").InnerText = entity.Type; // //node.SelectSingleNode("ErrorDate").InnerText = DateTime.Now.ToString(); // PropertyInfo[] properties = entity.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public); // foreach (PropertyInfo item in properties) // {//循环遍历实体,取出字段和字段对应的值 // if (item.GetValue(entity, null) != null) // { // item.SetValue(entity, node.SelectSingleNode(item.Name).InnerText, null); // } // } // } //} //catch (Exception ex) //{ //} //return entity; try { System.Data.DataTable dt = AccessHelper.ExecuteDataSet(AccessHelper.conn, "select * from Log where [GUID]=@GUID", new OleDbParameter("@GUID", GUID)).Tables[0]; if (dt.Rows.Count > 0) { PropertyInfo[] properties = entity.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public); foreach (PropertyInfo item in properties) {//循环遍历实体,取出字段和字段对应的值 if (item.GetValue(entity, null) != null) { item.SetValue(entity, dt.Rows[0][item.Name].ToString(), null); } } return(entity); } } catch (Exception ex) { } return(null); }
/// <summary> /// 获取实体 /// </summary> /// <param name="GUID"></param> /// <returns></returns> public TaskLogEntity GetEntity(string GUID) { try { TaskLogEntity entity = new TaskLogEntity(); DataTable dt = AccessHelper.ExecuteDataSet(AccessHelper.conn, "select * from TaskLogEntity where [GUID]=@GUID", new OleDbParameter("@GUID", GUID)).Tables[0]; if (dt.Rows.Count > 0) { PropertyInfo[] properties = entity.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public); foreach (PropertyInfo item in properties) {//循环遍历实体,取出字段和字段对应的值 if (item.GetValue(entity, null) != null) { item.SetValue(entity, dt.Rows[0][item.Name].ToString(), null); } } return(entity); } } catch (Exception ex) { } return(null); }