/// <summary>
/// 手动提交清算
/// </summary>
/// <param name="list">结算价列表</param>
/// <param name="errorMsg">异常信息</param>
/// <returns></returns>
public bool DoManualReckoning(List <QH_TodaySettlementPriceInfoEx> list, out string errorMsg)
{
errorMsg = "结算价列表为Null！";
if (list == null)
{
return(false);
}
List <QH_TodaySettlementPriceInfo> listInfo = new List <QH_TodaySettlementPriceInfo>();
foreach (QH_TodaySettlementPriceInfoEx item in list)
{
QH_TodaySettlementPriceInfo info = new QH_TodaySettlementPriceInfo();
info.CommodityCode = item.CommodityCode;
info.TradingDate = item.TradingDate;
info.SettlementPrice = item.SettlementPrice;
listInfo.Add(info);
}
List <CT_Counter> listcounter = StaticDalClass.CounterDAL.GetListArray(string.Empty);
bool rtn = true;
foreach (CT_Counter T in listcounter)
{
bool b = AccountManageServiceProxy.GetInstance().DoManualReckoning(T, listInfo, out errorMsg);
if (!b)
{
rtn = false;
}
}
return(rtn);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(QH_TodaySettlementPriceInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update QH_TodaySettlementPrice set ");
strSql.Append("SettlementPrice=@SettlementPrice");
strSql.Append(" where CommodityCode=@CommodityCode and TradingDate=@TradingDate ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CommodityCode", DbType.String, model.CommodityCode);
db.AddInParameter(dbCommand, "TradingDate", DbType.Int32, model.TradingDate);
db.AddInParameter(dbCommand, "SettlementPrice", DbType.Decimal, model.SettlementPrice);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(QH_TodaySettlementPriceInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into QH_TodaySettlementPrice(");
strSql.Append("CommodityCode,TradingDate,SettlementPrice)");
strSql.Append(" values (");
strSql.Append("@CommodityCode,@TradingDate,@SettlementPrice)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CommodityCode", DbType.String, model.CommodityCode);
db.AddInParameter(dbCommand, "TradingDate", DbType.Int32, model.TradingDate);
db.AddInParameter(dbCommand, "SettlementPrice", DbType.Decimal, model.SettlementPrice);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public QH_TodaySettlementPriceInfo ReaderBind(IDataReader dataReader)
{
QH_TodaySettlementPriceInfo model = new QH_TodaySettlementPriceInfo();
object ojb;
model.CommodityCode = dataReader["CommodityCode"].ToString();
ojb = dataReader["TradingDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.TradingDate = (int)ojb;
}
ojb = dataReader["SettlementPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.SettlementPrice = (decimal)ojb;
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public QH_TodaySettlementPriceInfo GetModel(string CommodityCode, int TradingDate)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CommodityCode,TradingDate,SettlementPrice from QH_TodaySettlementPrice ");
strSql.Append(" where CommodityCode=@CommodityCode and TradingDate=@TradingDate ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CommodityCode", DbType.String, CommodityCode);
db.AddInParameter(dbCommand, "TradingDate", DbType.Int32, TradingDate);
QH_TodaySettlementPriceInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
