private void insertPlateViewSQL(MyPlateCommodityInfo uc)
{
string type = null;
if (marketType.Equals(DaFutures))
{
type = "00";
//期货
}
else
{
type = "10";
//股票
}
string[] cmdTexts = null;
MySqlParameter[][] commandParameters = null;
MySqlParameter[] delcommandParameters = new MySqlParameter[] { new MySqlParameter("@plate_group_id", uc.FPlateGroupId), new MySqlParameter("@plate_id", uc.FPlateId),
new MySqlParameter("@exchange_no", uc.FExchangeNo), new MySqlParameter("@commodity_no", uc.FComodityNo), new MySqlParameter("@commodity_type", type) };
MySqlParameter[] insertcommandParameters = new MySqlParameter[] {
new MySqlParameter("@plate_group_id", uc.FPlateGroupId),
new MySqlParameter("@plate_group_name", uc.FPlateGroupName),
new MySqlParameter("@plate_id", uc.FPlateId),
new MySqlParameter("@plate_name", uc.FPlateName),
new MySqlParameter("@exchange_no", uc.FExchangeNo),
new MySqlParameter("@commodity_no", uc.FComodityNo),
new MySqlParameter("@commodity_type", type),
new MySqlParameter("@group_sort_id", "0"),
new MySqlParameter("@sort_id", uc.FSortId),
new MySqlParameter("@create_by", "batch_id"),
new MySqlParameter("@create_date", DateTime.Now),
new MySqlParameter("@update_by", "batch_id"),
new MySqlParameter("@update_date", DateTime.Now)
};
//需要更新的时候
cmdTexts = new string[]
{
SQLText.deletePlateView,
SQLText.insertPlateViewSQL
};
commandParameters = new MySqlParameter[][] {
delcommandParameters,
insertcommandParameters
};
bool isInsert = MySqlHelper.ExecuteTransaction(MySqlHelper.ConnectionStringManager, CommandType.Text, cmdTexts, commandParameters);
if (!isInsert)
{
PrintToTxt(uc.MyToString() + " 板块更新失败");
marketErrorLoger.log(LogLevel.SYSTEMERROR, uc.MyToString() + " 产品更新失败");
}
}
