private void insertStockSQL(bool isdelete, ContractStockHK uc)
{
string[] cmdTexts = null;
MySqlParameter[][] commandParameters = null;
MySqlParameter[] delcommandParameters = new MySqlParameter[] {
new MySqlParameter("@exchange_no", uc.FExchangeNo),
new MySqlParameter("@stock_no", uc.FCommodityNo)
};
Exchange ec = lstExchange.FirstOrDefault(p => p.FExchangeNo == uc.FExchangeNo);
if (ec != null)
{
//将期货的交易所名字换成中文
uc.FExchangeName = ec.FName;
}
MySqlParameter[] insertcommandParameters = new MySqlParameter[] {
new MySqlParameter("@exchange_no", uc.FExchangeNo),
new MySqlParameter("@exchange_name", uc.FExchangeName),
new MySqlParameter("@stock_no", uc.FCommodityNo),
new MySqlParameter("@stock_name", uc.FCommodityName),
new MySqlParameter("@stock_type", uc.FCommodityType),
new MySqlParameter("@reg_date", DateTime.Now.ToString("yyyyMMdd")),
new MySqlParameter("@currency_no", uc.FCurrencyNo),
new MySqlParameter("@currency_name", uc.FCurrencyName),
new MySqlParameter("@lot_size", uc.FLotSize),
new MySqlParameter("@mortgage_percent", uc.FMortgagePercent),
new MySqlParameter("@upper_tick_code", uc.FUpperTickCode),
new MySqlParameter("@create_by", "batch_id"),
new MySqlParameter("@create_date", DateTime.Now),
new MySqlParameter("@update_by", "batch_id"),
new MySqlParameter("@update_date", DateTime.Now),
new MySqlParameter("@commodity_type", "10"),
new MySqlParameter("@py_name", GetStringSpell.GetChineseSpell(uc.FCommodityName))
};
if (isdelete)
{
//需要更新的时候
cmdTexts = new string[]
{
SQLText.deleteStockSQL,
SQLText.insertStockSQL
};
commandParameters = new MySqlParameter[][] {
delcommandParameters,
insertcommandParameters
};
}
else
{
cmdTexts = new string[]
{
// deletefuturesSQL,
SQLText.insertStockSQL
};
commandParameters = new MySqlParameter[][] {
//delcommandParameters,
insertcommandParameters
};
}
bool isInsert = MySqlHelper.ExecuteTransaction(MySqlHelper.ConnectionStringManager, CommandType.Text, cmdTexts, commandParameters);
if (!isInsert)
{
PrintToTxt(uc.FCommodityNo + " 产品更新失败");
marketErrorLoger.log(LogLevel.SYSTEMERROR, uc.FCommodityNo + " 产品更新失败");
}
}
private void insertSQL(bool isdelete, UseContract uc)
{
string[] cmdTexts = null;
MySqlParameter[][] commandParameters = null;
MySqlParameter[] delcommandParameters = new MySqlParameter[] {
new MySqlParameter("@exchange_no", uc.FExchangeNo),
new MySqlParameter("@code", uc.code)
};
Exchange ec = lstExchange.FirstOrDefault(p => p.FExchangeNo == uc.FExchangeNo);
if (ec != null)
{
//将期货的交易所名字换成中文
uc.FName = ec.FName;
}
MySqlParameter[] insertcommandParameters = new MySqlParameter[] {
new MySqlParameter("@exchange_no", uc.FExchangeNo),
new MySqlParameter("@exchange_name", uc.FName),
new MySqlParameter("@commodity_no", uc.FCommodityNo),
new MySqlParameter("@commodity_name", uc.CommodityFName),
new MySqlParameter("@code", uc.code),
new MySqlParameter("@contract_no", uc.FContractNo),
new MySqlParameter("@contract_name", uc.ContractFName),
new MySqlParameter("@futures_type", uc.FCommodityType),
new MySqlParameter("@product_dot", uc.FProductDot),
new MySqlParameter("@upper_tick", uc.FUpperTick),
new MySqlParameter("@reg_date", DateTime.Now.ToString("yyyyMMdd")),
new MySqlParameter("@expiry_date", uc.FTradeMonth),
new MySqlParameter("@dot_num", uc.FDotNum),
new MySqlParameter("@currency_no", uc.CommodityFCurrencyNo),
new MySqlParameter("@currency_name", uc.CurrencyFName),
new MySqlParameter("@lower_tick", uc.FLowerTick),
new MySqlParameter("@exchange_no2", uc.FExchange2),
new MySqlParameter("@deposit", uc.FFreezenMoney),
new MySqlParameter("@deposit_percent", uc.FFreezenPercent),
new MySqlParameter("@first_notice_day", uc.FTradeMonth),
new MySqlParameter("@create_by", "batch_id"),
new MySqlParameter("@create_date", DateTime.Now),
new MySqlParameter("@update_by", "batch_id"),
new MySqlParameter("@update_date", DateTime.Now),
new MySqlParameter("@commodity_type", "00"),
new MySqlParameter("@py_name", GetStringSpell.GetChineseSpell(uc.ContractFName))
};
if (isdelete)
{
//需要更新的时候
cmdTexts = new string[]
{
SQLText.deletefuturesSQL,
SQLText.insertfuturesSQL
};
commandParameters = new MySqlParameter[][] {
delcommandParameters,
insertcommandParameters
};
}
else
{
cmdTexts = new string[]
{
// deletefuturesSQL,
SQLText.insertfuturesSQL
};
commandParameters = new MySqlParameter[][] {
//delcommandParameters,
insertcommandParameters
};
}
bool isInsert = MySqlHelper.ExecuteTransaction(MySqlHelper.ConnectionStringManager, CommandType.Text, cmdTexts, commandParameters);
if (!isInsert)
{
PrintToTxt(uc.code + " 产品更新失败");
marketErrorLoger.log(LogLevel.SYSTEMERROR, uc.code + " 产品更新失败");
}
}
