public short GetBAJK13s(decimal brxh, ref List <BAJK13> lstBAJK13s)
{
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.BAJK13Table.KEY1301
, 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 (lstBAJK13s == null)
{
lstBAJK13s = new List <BAJK13>();
}
do
{
BAJK13 BAJK13 = new BAJK13();
for (int i = 0; i < dataReader.FieldCount; i++)
{
if (dataReader.IsDBNull(i))
{
continue;
}
PropertyInfo property = Reflect.GetPropertyInfo(typeof(BAJK13), dataReader.GetName(i));
bool result = Reflect.SetPropertyValue(BAJK13, property, dataReader.GetValue(i));
}
lstBAJK13s.Add(BAJK13);
} 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(BAJK13 model)
{
if (model == null)
{
LogManager.Instance.WriteLog("", new string[] { "" }
, new object[] { model }, "参数不能为空");
return(SystemData.ReturnValue.PARAM_ERROR);
}
if (model.KEY1301 == 0 || model.KEY1301 == 0)
{
return(SystemData.ReturnValue.EXCEPTION);
}
StringBuilder sbField = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
PropertyInfo[] PropertyList = Reflect.GetProperties <BAJK13>(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.BAJK13
, 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);
}
