private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
txtGoodsName.Text = dataGridView1.CurrentRow.Cells["OldGoodsName"].Value.ToString();
txtGoodsSpec.Text = dataGridView1.CurrentRow.Cells["OldSpec"].Value.ToString();
txtOldCode.Text = dataGridView1.CurrentRow.Cells["OldGoodsCode"].Value.ToString();
txtOldCode.Tag = m_basicGoodsServer.GetGoodsIDByGoodsCode(txtOldCode.Text, txtGoodsName.Text, txtGoodsSpec.Text).ToString();
textBox1.Text = dataGridView1.CurrentRow.Cells["NewSpec"].Value.ToString();
textBox2.Text = dataGridView1.CurrentRow.Cells["NewGoodsName"].Value.ToString();
txtNewCode.Text = dataGridView1.CurrentRow.Cells["NewGoodsCode"].Value.ToString();
txtNewCode.Tag = m_basicGoodsServer.GetGoodsIDByGoodsCode(txtNewCode.Text, textBox2.Text, textBox1.Text).ToString();
txtOldCvtID.Text = dataGridView1.CurrentRow.Cells["OldCvtID"].Value.ToString();
txtNewCvtID.Text = dataGridView1.CurrentRow.Cells["NewCvtID"].Value.ToString();
txtNewGoodsID.Text = dataGridView1.CurrentRow.Cells["NewGoods"].Value.ToString();
txtOldGoodsID.Text = dataGridView1.CurrentRow.Cells["OldGoods"].Value.ToString();
if (dataGridView1.CurrentRow.Cells["Count"].Value.ToString().Trim() == "" ||
dataGridView1.CurrentRow.Cells["Count"].Value.ToString() == null)
{
txtCount.Value = 0;
}
else
{
txtCount.Value = Convert.ToDecimal(dataGridView1.CurrentRow.Cells["Count"].Value.ToString());
}
txtUnit.Text = dataGridView1.CurrentRow.Cells["Unit"].Value.ToString();
m_intOldGoodsID = m_basicGoodsServer.GetGoodsID(txtOldCode.Text, txtGoodsName.Text, txtOldCode.Text);
}
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
}