private void btnInput_Click(object sender, EventArgs e)
{
string LoadFile = null;
OpenFileDialog openexcle = new OpenFileDialog();
openexcle.Filter = "excel files (*.xls)|*.xls";
openexcle.ShowHelp = true;
if(openexcle.ShowDialog()==DialogResult.OK)
{
LoadFile = openexcle.FileName.ToString();
if (!string.IsNullOrEmpty(LoadFile))
{
FrmUnusualStockImporCheck from = new FrmUnusualStockImporCheck(LoadFile);
from.Tag = "JC_C_YCKC_CHECK";
from.Text = "非正常库存导入EXCEL数据检测";
if (from.ShowDialog()==DialogResult.OK)
{
xpServerCollectionSource1.FixedFilterString = "[CZYID] =\'" + FrmLogin.getUserID + "\'";
this.unitOfWork1.DropIdentityMap();
xpServerCollectionSource1.Reload();
SetCZLXMC();
this.gridView1.BestFitColumns();
}
// CheckInputData(LoadFile);
}
else
{
MessageBox.Show("你还没有加载文件");
}
}
}
private void btnBillInput_Click(object sender, EventArgs e)
{
if (selection1.SelectedCount != 1)
{
MessageBox.Show("必须选择一条进退单进行明细导入");
}
else
{
bool fgCheck = false;
int RowIndex = selection1.GetSelectedRowIndex(0);
int RowHandle = gridView1.GetRowHandle(RowIndex);
string strZTID = gridView1.GetRowCellDisplayText(RowHandle, colZTID).ToString().Trim();
string strZT = gridView1.GetRowCellDisplayText(RowHandle, colZT).ToString().Trim();
string strJTDH = gridView1.GetRowCellDisplayText(RowHandle, colJTDH).ToString().Trim();
string strJTDID = gridView1.GetRowCellDisplayText(RowHandle, colJTDID).ToString().Trim();
string strczyid = gridView1.GetRowCellDisplayText(RowHandle, colCZYID).ToString().Trim();
if (Convert.ToInt32(strZT) > 02)
{
fgCheck = false;
MessageBox.Show("这个单子已经确认过了无法导入");
}
else if (strZTID != FrmLogin.getZTID.ToString())
{
fgCheck = false;
MessageBox.Show("只有自己帐套下建立的单子才可以导入");
}
else if (string.IsNullOrEmpty(strJTDH))
{
fgCheck = false;
MessageBox.Show("该进退单为空号");
}
else if (strczyid != FrmLogin.getUserID.ToString())
{
fgCheck = false;
MessageBox.Show("只能导入自己建立的进退单");
}
else
{
fgCheck = true;
}
if (fgCheck == true)
{
string LoadFile = null;
OpenFileDialog openexcle = new OpenFileDialog();
openexcle.Filter = "excel files (*.xls)|*.xls";
openexcle.ShowHelp = true;
if (openexcle.ShowDialog() == DialogResult.OK)
{
LoadFile = openexcle.FileName.ToString();
if (!string.IsNullOrEmpty(LoadFile))
{
FrmUnusualStockImporCheck from = new FrmUnusualStockImporCheck(LoadFile, strJTDID);
from.Tag = "JC_G_JTD_CHECK";
from.Text = "非正常库存导入EXCEL数据检测";
if (from.ShowDialog() == DialogResult.OK)
{
selection1.ClearSelection();
// xpServerCollectionSource1.FixedFilterString = "[CZYID] =\'" + FrmLogin.getUserID + "\'";
this.unitOfWork1.DropIdentityMap();
xpServerCollectionSource1.Reload();
// SetCZLXMC();
this.gridView1.BestFitColumns();
}
// CheckInputData(LoadFile);
}
else
{
MessageBox.Show("你还没有加载文件");
}
}
}
}
}