private void GetListQueryData()
{
bsDelivery.EndEdit();
bool bResult = false;
string strErrMsg = string.Empty;
GetQueryDelivery();
if (DeliveryModel.StartTime != null && DeliveryModel.EndTime != null)
{
if (DeliveryModel.StartTime.ToDateTime().Date > DeliveryModel.EndTime.ToDateTime().Date)
{
Common.Common_Func.ErrorMessage("开始日期不能大于结束日期", "查询失败");
return;
}
}
ChensControl.DividPage clientPage = pageList.dDividPage;
Common.Common_Func.GetServerPageFromClientPage(ref _serverMainPage, clientPage);
bResult = Quality_Func.GetQualityList(ref lstDelivery, DeliveryModel, ref _serverMainPage, ref strErrMsg);
Common.Common_Func.GetClientPageFromServerPage(_serverMainPage, ref clientPage);
pageList.ShowPage();
dgvList.DataSource = lstDelivery;
if (!bResult)
{
Common.Common_Func.ErrorMessage(strErrMsg, "查询失败");
}
}
private void dgvList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
bool bSucc = false;
string strErrMsg = string.Empty;
string strHeaderText = this.dgvList.Columns[e.ColumnIndex].HeaderText;
//if (AllowShowEditFormText.IndexOf(strHeaderText) < 0) return;
if (e.RowIndex >= 0 &&
e.RowIndex < this.dgvList.Rows.Count && AllowShowEditFormText.IndexOf(strHeaderText) >= 0)
{
DeliveryReceive_Model item = this.lstDelivery[e.RowIndex];
bSucc = Quality_Func.GetQualityDetails(item, ref lstDeliveryDetails, ref strErrMsg);
if (bSucc == false)
{
Common.Common_Func.ErrorMessage(strErrMsg, "编辑失败");
return;
}
using (FrmQuality FQ = new FrmQuality(item, lstDeliveryDetails))
{
FQ.ShowDialog();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void tsmiSave_Click(object sender, EventArgs e)
{
try
{
bool bSucc = false;
string strErrMsg = string.Empty;
this.dgvList.EndEdit();
bSucc = Quality_Func.SaveQualityDetailInfo(DeliveryModel, ref strErrMsg);
if (bSucc == false)
{
Common.Common_Func.ErrorMessage(strErrMsg, "保存");
}
else
{
this.Close();
}
}
catch (Exception ex)
{
Common.Common_Func.ErrorMessage(ex.Message, "异常");
}
}
private void ExportDetail()
{
if (dgvList.DataSource == null || dgvList.Rows.Count <= 0)
{
MessageBox.Show("请先查询到结果后再尝试导出明细", "导出失败");
return;
}
bsDelivery.EndEdit();
if (dtpStartDate.Checked && DeliveryModel.StartTime != dtpStartDate.Value)
{
GetListQueryData();
}
else if (!dtpStartDate.Checked && DeliveryModel.StartTime != null)
{
GetListQueryData();
}
else if (dtpEndDate.Checked && DeliveryModel.EndTime != dtpEndDate.Value)
{
GetListQueryData();
}
else if (!dtpEndDate.Checked && DeliveryModel.EndTime != null)
{
GetListQueryData();
}
string strErrMsg = string.Empty;
List <QuanlityExportInfo> lstExport = new List <QuanlityExportInfo>();
QuanlityExportInfo queryExport = new QuanlityExportInfo();
try
{
this.Cursor = Cursors.WaitCursor;
queryExport.StartTime = DeliveryModel.StartTime;
queryExport.EndTime = DeliveryModel.EndTime;
queryExport.DeliveryNo = DeliveryModel.DeliveryNo;
queryExport.MaterialDoc = DeliveryModel.MaterialDoc;
queryExport.VoucherNo = DeliveryModel.VoucherNo;
queryExport.MaterialNo = DeliveryModel.MaterialNo;
DividPage serverPage = new DividPage();
serverPage.CurrentPageNumber = 1;
serverPage.CurrentPageShowCounts = -1;
if (!Quality_Func.GetQualityExportListByPage(ref lstExport, queryExport, ref serverPage, ref strErrMsg))
{
MessageBox.Show(strErrMsg, "导出失败");
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "导出失败");
return;
}
finally
{
this.Cursor = Cursors.Default;
}
try
{
string excludecol = "ID,QualityType,StartTime,EndTime";
Dictionary <string, string> dicFields = new Dictionary <string, string>();
dicFields.Add("DeliveryNo", "送货单号");
dicFields.Add("SupplierNo", "供应商代码");
dicFields.Add("SupplierName", "供应商名称");
dicFields.Add("Plant", "工厂");
dicFields.Add("MaterialDoc", "凭证号");
dicFields.Add("CreateDate", "创建时间");
dicFields.Add("PrintedQty", "已打印次数");
dicFields.Add("PrintTime", "最后打印时间");
dicFields.Add("MoveType", "移动类型");
dicFields.Add("VoucherNo", "采购单号");
dicFields.Add("RowNo", "行号");
dicFields.Add("MaterialNo", "物料编号");
dicFields.Add("MaterialDesc", "物料描述");
dicFields.Add("ReceiveQty", "收货数量");
dicFields.Add("Unit", "计量单位");
dicFields.Add("PrdVersion", "产品版本");
dicFields.Add("QualityQty", "合格数量");
dicFields.Add("UnQualityQty", "不合格数量");
dicFields.Add("QualityType", "却先等级");
dicFields.Add("StrQualityType", "缺陷等级");
ExcelLibrary.ExcelLibrary_Func.SaveListToExcelByNPOI(lstExport, true, excludecol, dicFields, dgvList.DefaultCellStyle.Font);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "导出失败");
return;
}
}
