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);
}
