public void GetApplicationDetail()
{
ApplicationDetailTable = applicationDetail.SelectAppDetailByCtrlID(applicationInfo.CtrlID);
dgvApplyDetails.AutoGenerateColumns = false;
dgvApplyDetails.DataSource = ApplicationDetailTable;
dgvDevilerDetails.AutoGenerateColumns = false;
dgvReceiptDetails.AutoGenerateColumns = false;
DeliverDetailTable = applicationDetail.SelectDeliverDetailByCtrlID(applicationInfo.CtrlID);
dgvDevilerDetails.DataSource = DeliverDetailTable;
ReceiptDetailTable = applicationDetail.SelectReceiptDetailByCtrlID(applicationInfo.CtrlID);
dgvReceiptDetails.DataSource = ReceiptDetailTable;
txtApplyUser.Text = applicationInfo.ApplicantsName;
txtPosition.Text = applicationInfo.ApplicantsPos;
txtDate.Text = applicationInfo.ApplicantsDate;
txtSendShopName.Text = applicationInfo.DeliverStore;
txtAcceptShopName.Text = applicationInfo.ReceiptStore;
txtApproval.Text = applicationInfo.ApprovalName;
txtApprovalTime.Text = applicationInfo.ApprovalDate;
txtApproval2.Text = applicationInfo.ApprovalName2;
txtApprovalTime2.Text = applicationInfo.ApprovalDate2;
txtBeforeChecked.Text = applicationInfo.DeliverCheck;
txtBeforeUser.Text = applicationInfo.DeliverCheckerName;
txtAfterChecked.Text = applicationInfo.ReceiptCheck;
txtAfterUser.Text = applicationInfo.ReceiptCheckerName;
txtS_O.Text = applicationInfo.S_O;
txtO_O.Text = applicationInfo.O_O;
txtBatch_Num1.SelectedText = applicationInfo.Batch_Num1;
txtBatch_Num2.SelectedText = applicationInfo.Batch_Num2;
txtDeliverDate.Text = applicationInfo.DeliverDate;
txtReceiptDate.Text = applicationInfo.ReceiptDate;
txtS_O_Str.Text = applicationInfo.S_O_Str;
txtO_O_Str.Text = applicationInfo.O_O_Str;
}
void GetDataTable()
{
AddApplicationDT = applicationDetail.SelectAppDetailByCtrlID("0");
dgvApplyProducts.AutoGenerateColumns = false;
dgvApplyProducts.DataSource = AddApplicationDT;
HighlightItemID();
}
public void GetApplicationDetail()
{
ApplicationDetailTable = applicationDetail.SelectAppDetailByCtrlID(applicationInfo.CtrlID);
dgvApplyDetails.DataSource = ApplicationDetailTable;
txtApplyUser.Text = applicationInfo.ApplicantsName;
txtPosition.Text = applicationInfo.ApplicantsPos;
txtDate.Text = applicationInfo.ApplicantsDate;
//txtSendShopName.Text = applicationInfo.DeliverStore;
//txtAcceptShopName.Text = applicationInfo.ReceiptStore;
txtApproval.Text = applicationInfo.ApprovalName;
txtApprovalTime.Text = applicationInfo.ApprovalDate;
txtApproval2.Text = applicationInfo.ApprovalName2;
txtApprovalTime2.Text = applicationInfo.ApprovalDate2;
txtBeforeChecked.Text = applicationInfo.DeliverCheck;
txtBeforeUser.Text = applicationInfo.DeliverCheckerName;
txtAfterChecked.Text = applicationInfo.ReceiptCheck;
txtAfterUser.Text = applicationInfo.ReceiptCheckerName;
}
public void GetApplicationDetail()
{
dgvDevilerDetails.AutoGenerateColumns = false;
dgvAppDetails.AutoGenerateColumns = false;
DeliverDetailTable = applicationDetail.SelectDeliverDetailByCtrlID(_ctrlID);
AppDetailTable = applicationDetail.SelectAppDetailByCtrlID(_ctrlID);
DiffDeliverDT = DeliverDetailTable.Clone();
DiffAppDT = AppDetailTable.Clone();
dgvDevilerDetails.DataSource = DiffDeliverDT;
dgvAppDetails.DataSource = DiffAppDT;
string[] strIDs = new string[50];
int i = 0;
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
bool isDiff = false;
if (AppDetailTable.Rows.Count != 0)
{
foreach (DataRow recdr in AppDetailTable.Rows)
{
if (deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
if (Array.IndexOf <string>(strIDs, recdr["ID"].ToString()) == -1)
{
i++;
strIDs[i] = recdr["ID"].ToString();
isDiff = false;
goto done;
}
else
{
isDiff = true;
}
}
else
{
isDiff = true;
}
}
done:
if (isDiff)
{
DiffDeliverDT.Rows.Add(deldr.ItemArray);
}
}
else
{
isDiff = true;
DiffDeliverDT.Rows.Add(deldr.ItemArray);
}
}
strIDs = new string[50];
i = 0;
foreach (DataRow recdr in AppDetailTable.Rows)
{
bool isDiff = false;
if (DeliverDetailTable.Rows.Count != 0)
{
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
if (deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
if (Array.IndexOf <string>(strIDs, deldr["ID"].ToString()) == -1)
{
i++;
strIDs[i] = deldr["ID"].ToString();
isDiff = false;
goto done2;
}
else
{
isDiff = true;
}
}
else
{
isDiff = true;
}
}
done2:
if (isDiff)
{
DiffAppDT.Rows.Add(recdr.ItemArray);
}
}
else
{
isDiff = true;
DiffAppDT.Rows.Add(recdr.ItemArray);
}
}
}
private void btnExcel_Click(object sender, EventArgs e)
{
TempDT = new DataTable[3];
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Excel文件|*.xls";
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
try
{
label1.Text = "正在导入Excel数据....";
filePath = openFileDialog.FileName;
applicationInfoDT = applicationInfo.SelectApplicationByCtrlID("");
applicationInfoDT.Clear();
applicationDetailDT = applicationDetail.SelectAppDetailByCtrlID("");
applicationDetailDT.Clear();
//创建错误列表
DataTable dtError = new DataTable("Error");
DataColumn dc1 = new DataColumn("ID", Type.GetType("System.Int16"));
DataColumn dc2 = new DataColumn("eCtrlID", Type.GetType("System.String"));
DataColumn dc3 = new DataColumn("eItemID", Type.GetType("System.String"));
DataColumn dc4 = new DataColumn("ErrorString", Type.GetType("System.String"));
dtError.Columns.Add(dc1);
dtError.Columns.Add(dc2);
dtError.Columns.Add(dc3);
dtError.Columns.Add(dc4);
TempDT[0] = applicationInfoDT;
TempDT[1] = applicationDetailDT;
TempDT[2] = dtError;
PrintExcel pe = new PrintExcel();
TempDT = pe.ExcelToDataTable_Application(filePath, TempDT);
dgvApplyInfo.AutoGenerateColumns = false;
dgvApplyInfo.DataSource = TempDT[0];
dgvApplyDetails.AutoGenerateColumns = false;
dgvApplyDetails.DataSource = TempDT[1];
dgvErrorList.AutoGenerateColumns = false;
dgvErrorList.DataSource = TempDT[2];
label1.Text = "Excel数据载入完成";
if (TempDT[0].Rows.Count > 0 && TempDT[1].Rows.Count > 0 && TempDT[2].Rows.Count == 0)
{
btnImport.Enabled = true;
}
else
{
label1.ForeColor = Color.Red;
label1.Text = label1.Text + " ,但是数据有错,详见数据错误列表";
}
//if (TempDT[2].Rows.Count > 0)
//{
// label1.ForeColor = Color.Red;
// label1.Text = label1.Text + " ,但是数据有错,详见数据错误列表";
//}
}
catch (Exception ex)
{
label1.ForeColor = Color.Red;
label1.Text = "Excel数据导入失败,详见数据错误列表";
}
}
}
private void btnDataProcess_Click(object sender, EventArgs e)
{
AccessHelper ah = new AccessHelper();
foreach (DataRow dr in dtStaDetail.Rows)
{
string strCtrlID = "";
int intNum = int.Parse(dr["num"].ToString());
int intCI = 1;
int intCurrentNum = 1;
int intTotalCount = 0;
double douTotalPrice = 0.00;
string strSQL = "select * from applicationdetail where CtrlID='" + dr["CtrlID"].ToString() + "' ";
DataTable dtDataDetail = ah.SelectToDataTable(strSQL);
strSQL = "select * from ApplicationInfo where CtrlID='" + dr["CtrlID"].ToString() + "' ";
DataTable dtDataInfo = ah.SelectToDataTable(strSQL);
string strOriCtrlID = "Auto" + DateTime.Now.ToString("HHmmssfff") + dtDataInfo.Rows[0]["Applicants"].ToString().Substring(0, 1);
strCtrlID = strOriCtrlID;
DataTable AddAppInfoDT = applicationInfo.SelectApplicationByCtrlID("0");
DataTable AddAppDetailDT = applicationDetail.SelectAppDetailByCtrlID("0");
DataRow drInfo = AddAppInfoDT.NewRow();
DataRow drDetail = AddAppDetailDT.NewRow();
drInfo = dtDataInfo.Rows[0];
foreach (DataRow drIN in dtDataDetail.Rows)
{
drDetail = drIN;
if (intCurrentNum <= 20)
{
intCurrentNum++;
drInfo["CtrlID"] = strCtrlID;
drDetail["CtrlID"] = strCtrlID;
intTotalCount += (int)drDetail["App_Count"];
douTotalPrice += ((int)drDetail["App_Count"]) * ((double.Parse(drDetail["Price"].ToString())));
AddAppDetailDT.Rows.Add(drDetail.ItemArray);
}
else
{
drInfo["TotalCount"] = intTotalCount;
drInfo["TotalPrice"] = douTotalPrice;
AddAppInfoDT.Rows.Add(drInfo.ItemArray);
applicationInfo.SubmitApplicationInfo(AddAppInfoDT);
applicationDetail.SubmitApplicationDetail(AddAppDetailDT);
intCurrentNum = 1;
intTotalCount = 0;
douTotalPrice = 0.00;
strCtrlID = strOriCtrlID + intCI.ToString();
intCI++;
AddAppInfoDT.Clear();
AddAppDetailDT.Clear();
//drInfo = AddAppInfoDT.NewRow();
//drDetail = AddAppDetailDT.NewRow();
//drInfo = dtDataInfo.Rows[0];
intCurrentNum++;
drInfo["CtrlID"] = strCtrlID;
drDetail["CtrlID"] = strCtrlID;
intTotalCount += (int)drDetail["App_Count"];
douTotalPrice += ((int)drDetail["App_Count"]) * ((double.Parse(drDetail["Price"].ToString())));
AddAppDetailDT.Rows.Add(drDetail.ItemArray);
}
}
if (AddAppDetailDT.Rows.Count > 0)
{
drInfo["TotalCount"] = intTotalCount;
drInfo["TotalPrice"] = douTotalPrice;
AddAppInfoDT.Rows.Add(drInfo.ItemArray);
applicationInfo.SubmitApplicationInfo(AddAppInfoDT);
applicationDetail.SubmitApplicationDetail(AddAppDetailDT);
intCurrentNum = 1;
intTotalCount = 0;
douTotalPrice = 0.00;
//strCtrlID = strOriCtrlID + intCI.ToString();
//intCI++;
AddAppInfoDT.Clear();
AddAppDetailDT.Clear();
}
strSQL = "update applicationdetail set isdelete=1 where CtrlID='" + dr["CtrlID"].ToString() + "' ";
ah.ExecuteSQLNonquery(strSQL);
strSQL = "update ApplicationInfo set isdelete=1 where CtrlID='" + dr["CtrlID"].ToString() + "' ";
ah.ExecuteSQLNonquery(strSQL);
}
ah.Close();
MessageBox.Show("处理完成!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
frmDataProcessing_Load(null, null);
}
void GetDataTable()
{
AddApplicationDT = applicationDetail.SelectAppDetailByCtrlID(applicationInfo.CtrlID);
dgvApplyProducts.AutoGenerateColumns = false;
dgvApplyProducts.DataSource = AddApplicationDT;
}
public Boolean boolCampareOrder(string _ctrlID)
{
Boolean boolResult = false;
DataTable DeliverDetailTable;
DataTable ReceiptDetailTable;
DataTable AppDetailTable;
ApplicationInfo applicationInfo = new ApplicationInfo();
ApplicationDetail applicationDetail = new ApplicationDetail();
//dgvDevilerDetails.AutoGenerateColumns = false;
//dgvReceiptDetails.AutoGenerateColumns = false;
DeliverDetailTable = applicationDetail.SelectDeliverDetailByCtrlID(_ctrlID);
ReceiptDetailTable = applicationDetail.SelectReceiptDetailByCtrlID(_ctrlID);
AppDetailTable = applicationDetail.SelectAppDetailByCtrlID(_ctrlID);
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
foreach (DataRow recdr in ReceiptDetailTable.Rows)
{
if (DeliverDetailTable.Rows.Count == ReceiptDetailTable.Rows.Count && deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
boolResult = false;
goto done;
}
else
{
boolResult = true;
}
}
done:
if (boolResult)
{
goto Finish;
}
}
foreach (DataRow recdr in ReceiptDetailTable.Rows)
{
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
if (DeliverDetailTable.Rows.Count == ReceiptDetailTable.Rows.Count && deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
boolResult = false;
goto done2;
}
else
{
boolResult = true;
}
}
done2:
if (boolResult)
{
goto Finish;
}
}
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
foreach (DataRow recdr in AppDetailTable.Rows)
{
if (DeliverDetailTable.Rows.Count == AppDetailTable.Rows.Count && deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
boolResult = false;
goto done3;
}
else
{
boolResult = true;
}
}
done3:
if (boolResult)
{
goto Finish;
}
}
foreach (DataRow recdr in AppDetailTable.Rows)
{
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
if (DeliverDetailTable.Rows.Count == AppDetailTable.Rows.Count && deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
boolResult = false;
goto done4;
}
else
{
boolResult = true;
}
}
done4:
if (boolResult)
{
goto Finish;
}
}
Finish:
return(boolResult);
}
