public short GetBAJK15s(decimal brxh, ref List <BAJK15> lstBAJK15s) { if (base.BAJKDataAccess == null) { return(SystemData.ReturnValue.PARAM_ERROR); } StringBuilder sbField = new StringBuilder(); sbField.AppendFormat("*"); string szCondition = string.Format("1=1"); szCondition = string.Format("{0} AND {1} = {2} " , szCondition , SystemData.BAJK15Table.KEY1501 , brxh); string szSQL = string.Format(SystemData.SQL.SELECT_WHERE , sbField.ToString(), TableName, szCondition); IDataReader dataReader = null; try { dataReader = base.BAJKDataAccess.ExecuteReader(szSQL, CommandType.Text); if (dataReader == null || dataReader.IsClosed || !dataReader.Read()) { return(SystemData.ReturnValue.RES_NO_FOUND); } if (lstBAJK15s == null) { lstBAJK15s = new List <BAJK15>(); } do { BAJK15 BAJK15 = new BAJK15(); for (int i = 0; i < dataReader.FieldCount; i++) { if (dataReader.IsDBNull(i)) { continue; } PropertyInfo property = Reflect.GetPropertyInfo(typeof(BAJK15), dataReader.GetName(i)); bool result = Reflect.SetPropertyValue(BAJK15, property, dataReader.GetValue(i)); } lstBAJK15s.Add(BAJK15); } while (dataReader.Read()); return(SystemData.ReturnValue.OK); } catch (Exception ex) { LogManager.Instance.WriteLog("", new string[] { "szSQL" }, new object[] { szSQL }, ex); return(SystemData.ReturnValue.EXCEPTION); } finally { base.BAJKDataAccess.CloseConnnection(false); } }
public short Update(BAJK15 model) { if (model == null) { LogManager.Instance.WriteLog("", new string[] { "" } , new object[] { model }, "参数不能为空"); return(SystemData.ReturnValue.PARAM_ERROR); } if (base.BAJKDataAccess == null) { return(SystemData.ReturnValue.PARAM_ERROR); } StringBuilder sbField = new StringBuilder(); PropertyInfo[] PropertyList = Reflect.GetProperties <BAJK15>(model); foreach (var item in PropertyList) { string name = item.Name; object value = item.GetValue(model, null); switch (item.PropertyType.Name) { case "Decimal": sbField.AppendFormat("{0}={1},", name, value); break; case "int": sbField.AppendFormat("{0}={1},", name, value); break; case "DateTime": DateTime dt = DateTime.Parse(value.ToString()); if (dt == model.DefaultTime || dt == model.DefaultTime2 || dt == model.DefaultTime3) { break; } sbField.AppendFormat("{0}={1},", name, base.BAJKDataAccess.GetSqlTimeFormat(dt)); break; default: sbField.AppendFormat("{0}='{1}',", name, value); break; } } string szField = sbField.ToString().Substring(0, sbField.Length - 1); string szCondition = string.Format("{0}={1}", SystemData.BAJK15Table.KEY1501, model.KEY1501); string szSQL = string.Format(SystemData.SQL.UPDATE, TableName, szField, szCondition); int nCount = 0; try { nCount = base.BAJKDataAccess.ExecuteNonQuery(szSQL, CommandType.Text); } catch (Exception ex) { LogManager.Instance.WriteLog("", new string[] { "szSQL" }, new object[] { szSQL }, ex); return(SystemData.ReturnValue.EXCEPTION); } if (nCount <= 0) { LogManager.Instance.WriteLog("", new string[] { "szSQL" }, new object[] { szSQL }, "SQL语句执行后返回0!"); return(SystemData.ReturnValue.EXCEPTION); } return(SystemData.ReturnValue.OK); }