/// <summary>
/// 导入单据明细
/// </summary>
/// <param name="lstBillNo">单据号列表</param>
/// <param name="billType">单据类型</param>
/// <returns>返回Table</returns>
public DataTable LeadInDetail(List <string> lstBillNo, CE_ProcurementStatementBillTypeEnum billType)
{
string error = "";
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.Business_Settlement_ProcurementStatement_TempTable
select a;
ctx.Business_Settlement_ProcurementStatement_TempTable.DeleteAllOnSubmit(varData);
foreach (string item in lstBillNo)
{
Business_Settlement_ProcurementStatement_TempTable tempLnq = new Business_Settlement_ProcurementStatement_TempTable();
tempLnq.BillNo = item;
ctx.Business_Settlement_ProcurementStatement_TempTable.InsertOnSubmit(tempLnq);
}
ctx.SubmitChanges();
DataTable result = new DataTable();
Hashtable hsTable = new Hashtable();
hsTable.Add("@Flag", billType == CE_ProcurementStatementBillTypeEnum.零星采购加工 ? true : false);
result = GlobalObject.DatabaseServer.QueryInfoPro("Business_Settlement_ReferemceDetail", hsTable, out error);
return(result);
}
private void cmbBillType_SelectedIndexChanged(object sender, EventArgs e)
{
if (customDataGridView1.Columns.Count == 0)
{
return;
}
CE_ProcurementStatementBillTypeEnum billType =
GlobalObject.GeneralFunction.StringConvertToEnum <CE_ProcurementStatementBillTypeEnum>(cmbBillType.Text);
if (billType == CE_ProcurementStatementBillTypeEnum.零星采购加工)
{
//cmbInvoiceType.Enabled = true;
cmbTaxRate.Enabled = true;
}
else
{
//cmbInvoiceType.Enabled = false;
cmbTaxRate.Enabled = false;
}
if (billType == CE_ProcurementStatementBillTypeEnum.委托加工物资)
{
customDataGridView1.Columns["入库单价_不含税"].Visible = false;
customDataGridView1.Columns["单件委托材料"].Visible = true;
customDataGridView1.Columns["单件加工费"].Visible = true;
customDataGridView1.Columns["委托加工材料"].Visible = true;
//customDataGridView1.Columns["税额"].Visible = false;
//customDataGridView1.Columns["价税合计"].Visible = false;
}
else
{
customDataGridView1.Columns["入库单价_不含税"].Visible = true;
customDataGridView1.Columns["单件委托材料"].Visible = false;
customDataGridView1.Columns["单件加工费"].Visible = false;
customDataGridView1.Columns["委托加工材料"].Visible = false;
//customDataGridView1.Columns["税额"].Visible = true;
//customDataGridView1.Columns["价税合计"].Visible = true;
}
}
private bool customPanel1_PanelGetDataInfo(CE_FlowOperationType flowOperationType)
{
try
{
if (flowOperationType == CE_FlowOperationType.提交)
{
if (!CheckData_Submit())
{
return(false);
}
if (GlobalObject.GeneralFunction.StringConvertToEnum <CE_CommonBillStatus>(lbBillStatus.Text) == CE_CommonBillStatus.等待审核)
{
CE_ProcurementStatementBillTypeEnum billType =
GlobalObject.GeneralFunction.StringConvertToEnum <CE_ProcurementStatementBillTypeEnum>(cmbBillType.Text);
foreach (DataGridViewRow dgvr in customDataGridView1.Rows)
{
if (billType != CE_ProcurementStatementBillTypeEnum.委托加工物资)
{
if (Convert.ToDecimal(dgvr.Cells["入库金额"].Value) != Convert.ToDecimal(dgvr.Cells["发票金额"].Value) &&
dgvr.Cells["差异说明"].Value.ToString().Trim().Length == 0)
{
MessageDialog.ShowPromptMessage("入库金额与发票金额不一致的记录的差异说明不能为空");
return(false);
}
}
else
{
decimal dcTemp = Convert.ToDecimal(dgvr.Cells["入库数量"].Value) * Convert.ToDecimal(dgvr.Cells["单件委托材料"].Value);
if (Convert.ToDecimal(dgvr.Cells["入库金额"].Value) != (Convert.ToDecimal(dgvr.Cells["发票金额"].Value) + dcTemp) &&
dgvr.Cells["差异说明"].Value.ToString().Trim().Length == 0)
{
MessageDialog.ShowPromptMessage("入库金额与(发票金额 + 入库数量 * 单件委托材料) 不一致的记录的差异说明不能为空");
return(false);
}
}
}
}
}
else if (flowOperationType == CE_FlowOperationType.暂存)
{
if (!CheckData_Hold())
{
return(false);
}
}
m_lnqBillInfo = new Business_Settlement_ProcurementStatement();
m_lnqBillInfo.BillNo = txtBillNo.Text;
m_lnqBillInfo.BillType = cmbBillType.Text;
m_lnqBillInfo.InvoiceType = cmbInvoiceType.Text;
m_lnqBillInfo.SettlementCompany = txtSettlementCompany.Tag.ToString();
m_lnqBillInfo.TaxRate = Convert.ToDecimal(cmbTaxRate.Text);
m_lnqBillInfo.AccoutingDocumentNo = txtAccoutingDocumentNo.Text;
List <View_Business_Settlement_ProcurementStatementDetail> listTemp = new List <View_Business_Settlement_ProcurementStatementDetail>();
foreach (DataGridViewRow dgvr in customDataGridView1.Rows)
{
View_Business_Settlement_ProcurementStatementDetail detailTemp = new View_Business_Settlement_ProcurementStatementDetail();
detailTemp.差异说明 = dgvr.Cells["差异说明"].Value == null ? "" : dgvr.Cells["差异说明"].Value.ToString();
detailTemp.零件名称 = dgvr.Cells["零件名称"].Value == null ? "" : dgvr.Cells["零件名称"].Value.ToString();
detailTemp.物品ID = Convert.ToInt32(dgvr.Cells["物品ID"].Value);
detailTemp.零件图号 = dgvr.Cells["零件图号"].Value == null ? "" : dgvr.Cells["零件图号"].Value.ToString();
detailTemp.规格 = dgvr.Cells["规格"].Value == null ? "" : dgvr.Cells["规格"].Value.ToString();
detailTemp.单据号 = txtBillNo.Text;
detailTemp.批次号 = dgvr.Cells["批次号"].Value == null ? "" : dgvr.Cells["批次号"].Value.ToString();
detailTemp.单件加工费 = (decimal?)dgvr.Cells["单件加工费"].Value;
detailTemp.单件委托材料 = (decimal?)dgvr.Cells["单件委托材料"].Value;
detailTemp.发票单价 = Convert.ToDecimal(dgvr.Cells["发票单价"].Value);
detailTemp.发票金额 = Convert.ToDecimal(dgvr.Cells["发票金额"].Value);
detailTemp.合同申请单号 = dgvr.Cells["执行合同号_申请单"].Value == null ? "" : dgvr.Cells["执行合同号_申请单"].Value.ToString();
detailTemp.价税合计 = (decimal?)dgvr.Cells["价税合计"].Value;
detailTemp.入库单号 = dgvr.Cells["入库单号"].Value == null ? "" : dgvr.Cells["入库单号"].Value.ToString();
detailTemp.入库单价 = (decimal)dgvr.Cells["入库单价_不含税"].Value;
detailTemp.入库金额 = (decimal)dgvr.Cells["入库金额"].Value;
detailTemp.入库数量 = (decimal)dgvr.Cells["入库数量"].Value;
detailTemp.税额 = (decimal)dgvr.Cells["税额"].Value;
detailTemp.委托加工材料 = (decimal)dgvr.Cells["委托加工材料"].Value;
listTemp.Add(detailTemp);
}
this.FlowInfo_BillNo = txtBillNo.Text;
this.ResultInfo = m_lnqBillInfo;
this.ResultList = new List <object>();
this.ResultList.Add(m_listInvoice);
this.ResultList.Add(listTemp);
this.ResultList.Add(flowOperationType);
this.KeyWords = "【供应商】:" + m_lnqBillInfo.SettlementCompany;
return(true);
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return(false);
}
}