private void 日志toolStripButton_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow == null)
{
return;
}
FormShowYXLowestPriceError frm = new FormShowYXLowestPriceError(null, dataGridView1.CurrentRow.Cells["单据号"].Value.ToString());
frm.ShowDialog();
}
private void 导入toolStripButton_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_error);
return;
}
if (!CheckTable(dtTemp))
{
return;
}
DataTable dtClone = dtTemp.Clone();
foreach (DataRow dr in dtTemp.Rows)
{
YX_LowestMarketPrice lowest = new YX_LowestMarketPrice();
int GoodsID = m_basicGoodsServer.GetGoodsIDByGoodsCode(dr["容大代码"].ToString(),
dr["零件名称"].ToString(), dr["规格"].ToString());
if (GoodsID != 0 && GoodsID != 7126)
{
lowest.GoodsID = GoodsID;
}
else
{
AddErrorInfo(ref dtClone, dr);
continue;
}
string clientCode = m_clientServer.GetClientCode(dr["客户名称"].ToString());
if (clientCode != "")
{
lowest.ClientID = clientCode;
}
else
{
AddErrorInfo(ref dtClone, dr);
continue;
}
int?communicateID = m_LowestPriceServer.GetCommunicateID(lowest.ClientID, dr["主机厂图号型号"].ToString(),
dr["主机厂物品名称"].ToString(), lowest.GoodsID, out m_error);
if (communicateID != null)
{
lowest.CommunicateID = communicateID;
}
else
{
AddErrorInfo(ref dtClone, dr);
continue;
}
lowest.Date = ServerTime.Time;
lowest.Price = Convert.ToDecimal(dr["配件含税单价（元）"].ToString());
lowest.TerminalPrice = Convert.ToDecimal(dr["配件终端最低价（元）"].ToString());
lowest.Rater = BasicInfo.LoginID;
lowest.Remark = dr["备注"].ToString();
if (!m_LowestPriceServer.InsertAndUpdateData(lowest, out m_error))
{
AddErrorInfo(ref dtClone, dr);
continue;
}
}
if (dtClone.Rows.Count > 0)
{
FormShowYXLowestPriceError form = new FormShowYXLowestPriceError(dtTemp, null);
form.ShowDialog();
}
else
{
MessageDialog.ShowPromptMessage("导入成功");
}
#region 逻辑代码修改 Modify by cjb on 2015.11.18
//bool flag = false;
////string GoodsName = "";
//for (int i = 0; i < dtTemp.Rows.Count; i++)
//{
// YX_LowestMarketPrice lowest = new YX_LowestMarketPrice();
// lowest.Date = ServerTime.Time;
// int GoodsID = m_basicGoodsServer.GetGoodsIDByGoodsCode(
// dtTemp.Rows[i]["容大代码"].ToString(), dtTemp.Rows[i]["零件名称"].ToString(), dtTemp.Rows[i]["规格"].ToString());
// if (GoodsID != 0 && GoodsID != 7126)
// {
// lowest.GoodsID = GoodsID;
// }
// else if (GoodsID == 7126)
// {
// dtTemp.Rows.RemoveAt(i);
// i--;
// continue;
// }
// else
// {
// //GoodsName += "容大代码为:" + dtTemp.Rows[i]["容大代码"].ToString() + ";零件名称:" +
// // dtTemp.Rows[i]["零件名称"].ToString() + "的零件有误,系统没有该零件;\r\n";
// flag = true;
// continue;
// }
// lowest.Price = Convert.ToDecimal(dtTemp.Rows[i]["配件含税单价（元）"].ToString());
// lowest.TerminalPrice = Convert.ToDecimal(dtTemp.Rows[i]["配件终端最低价（元）"].ToString());
// lowest.Rater = BasicInfo.LoginID;
// lowest.Remark = dtTemp.Rows[i]["备注"].ToString();
// string clientCode = m_clientServer.GetClientCode(dtTemp.Rows[i]["客户名称"].ToString());
// if (clientCode != "")
// {
// lowest.ClientID = clientCode;
// string communicateID = m_LowestPriceServer.GetCommunicateID(clientCode, dtTemp.Rows[i]["主机厂图号型号"].ToString(),
// dtTemp.Rows[i]["主机厂物品名称"].ToString(), GoodsID, out m_error);
// if (communicateID != "")
// {
// lowest.CommunicateID = communicateID;
// }
// else
// {
// flag = true;
// continue;
// }
// }
// else
// {
// flag = true;
// continue;
// }
// if (!m_LowestPriceServer.InsertAndUpdateData(lowest, out m_error))
// {
// flag = true;
// }
// else
// {
// dtTemp.Rows.RemoveAt(i);
// i--;
// }
//}
//if (flag)
//{
// FormShowYXLowestPriceError form = new FormShowYXLowestPriceError(dtTemp,null);
// form.ShowDialog();
//}
//else
//{
// MessageDialog.ShowPromptMessage("导入成功");
//}
#endregion
}
