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