public short GetBAJK12s(decimal brxh, ref List <BAJK12> lstBAJK12s) { 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.BAJK12Table.KEY1201 , 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 (lstBAJK12s == null) { lstBAJK12s = new List <BAJK12>(); } do { BAJK12 BAJK12 = new BAJK12(); for (int i = 0; i < dataReader.FieldCount; i++) { if (dataReader.IsDBNull(i)) { continue; } PropertyInfo property = Reflect.GetPropertyInfo(typeof(BAJK12), dataReader.GetName(i)); bool result = Reflect.SetPropertyValue(BAJK12, property, dataReader.GetValue(i)); } lstBAJK12s.Add(BAJK12); } 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 Insert(BAJK12 model) { if (model == null) { LogManager.Instance.WriteLog("", new string[] { "" } , new object[] { model }, "参数不能为空"); return(SystemData.ReturnValue.PARAM_ERROR); } if (model.KEY1201 == 0 || model.KEY1201 == 0) { return(SystemData.ReturnValue.EXCEPTION); } StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); PropertyInfo[] PropertyList = Reflect.GetProperties <BAJK12>(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},", name); sbValue.AppendFormat("{0},", value); break; case "DateTime": DateTime dt = DateTime.Parse(value.ToString()); if (dt == model.DefaultTime || dt == model.DefaultTime2 || dt == model.DefaultTime3) { break; } sbField.AppendFormat("{0},", name); sbValue.AppendFormat("{0},", base.BAJKDataAccess.GetSqlTimeFormat(dt)); break; default: sbField.AppendFormat("{0},", name); sbValue.AppendFormat("'{0}',", value); break; } } string szField = sbField.ToString().Substring(0, sbField.Length - 1); string szValue = sbValue.ToString().Substring(0, sbValue.Length - 1); string szSQL = string.Format(SystemData.SQL.INSERT , SystemData.DataTable_BAJK.BAJK12 , szField , szValue); 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); }