public Q51(ConditionMaterial condition)
{
InitializeComponent();
IList <Model.ProduceMaterialExitDetail> list = detailManager.SelectBycondition(condition.StartDate, condition.EndDate, condition.ProduceMaterialId0, condition.ProduceMaterialId1, condition.Product0, condition.Product1, condition.DepartmentId0, condition.DepartmentId1, condition.PronoteHeaderId0, condition.PronoteHeaderId1);
if (list == null || list.Count <= 0)
{
throw new global::Helper.InvalidValueException();
}
if (!global::Helper.DateTimeParse.DateTimeEquls(condition.StartDate, global::Helper.DateTimeParse.NullDate))
{
this.xrLabelDateRange.Text = "自 " + DateTime.Now.ToShortDateString();
}
this.xrLabelDateRange.Text += "至 " + condition.EndDate.ToShortDateString();
this.xrLabelRepotName.Text = BL.Settings.CompanyChineseName;
this.ReportTitle.Text = Properties.Resources.ProduceMaterialExitDetail;
this.DataSource = list;
this.xrTableProID.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id);
this.xrTableDate.DataBindings.Add("Text", this.DataSource, "ProduceMaterialExit." + Model.ProduceMaterialExit.PRO_ProduceExitMaterialDate, "{0:yyyy-MM-dd}");
this.xrTableProName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
this.xrTableQuanTity.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_ProduceQuantity);
this.xrTableGuiGe.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductSpecification);
this.xrTableMaterialExitId.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_ProduceMaterialExitId);
this.xrTableUnit.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_ProductUnit);
//this.xrTableXOid.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_InvoiceXOId);
this.xrTableDepot.DataBindings.Add("Text", this.DataSource, "Depot." + Model.Depot.PRO_DepotName);
this.xrTableDepotPosition.DataBindings.Add("Text", this.DataSource, "DepotPosition." + Model.DepotPosition.PROPERTY_ID);
}
public Q50_2(ConditionMaterial condition)
{
InitializeComponent();
this.MaterialCondidtion = condition;
IList <Model.ProduceMaterial> list = produceMaterialManager.SelectBycondition(condition.StartDate, condition.EndDate, condition.ProduceMaterialId0, condition.ProduceMaterialId1, condition.Product0, condition.Product1, condition.DepartmentId0, condition.DepartmentId1, condition.PronoteHeaderId0, condition.PronoteHeaderId1, condition.CusInvoiceXOId);
if (list == null || list.Count <= 0)
{
throw new global::Helper.InvalidValueException("查詢無記錄.");
}
this.xrLabelDates.Text += System.DateTime.Now.ToString("yyyy-MM-dd");
this.xrLabelRepotName.Text = BL.Settings.CompanyChineseName;
this.xrLabelData.Text = Properties.Resources.ProduceMaterialInfo;
this.DataSource = list;
//this.xrLabelProduceMaterialId.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_ProduceMaterialID);
//this.xrLabelDepartment.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_WorkhouseName);
//this.xrLabelPronoteHeaderID.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_InvoiceId);
//this.xrLabelProduceMaterialDate.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_ProduceMaterialDate, "{0:yyyy-MM-dd}");
//this.xrLabelProduct.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_ParenProductName, "{0:yyyy-MM-dd}");
//this.xrSubreport1.ReportSource = new Q50_1();
//this.xrLabelCusXOId.DataBindings.Add("Text", this.DataSource, "CusXOId");
//数据加总
StringBuilder str = new StringBuilder();
foreach (Model.ProduceMaterial detail in list)
{
if (detail.ProduceMaterialID != null)
{
str.Append("'" + detail.ProduceMaterialID + "',");
}
}
IList <Model.ProduceMaterialdetails> detailTotal = (new BL.ProduceMaterialdetailsManager()).SelectTotalByProduceMaterialID(this.MaterialCondidtion.Product0, this.MaterialCondidtion.Product1, str.ToString().Length > 1 ? str.ToString().Substring(0, str.Length - 1) : "''");
foreach (Model.ProduceMaterialdetails detail in detailTotal)
{
this.xrRichText1.Text += "\r\n" + detail.ProductName + " :" + " 总数:" + detail.Materialprocessum + " 已领数量:" + detail.Materialprocesedsum;
}
}
protected override void OnOK()
{
if (this.condition == null)
{
this.condition = new ConditionMaterial();
}
if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditStartDate.DateTime, new DateTime()))
{
this.condition.StartDate = global::Helper.DateTimeParse.NullDate;
}
else
{
this.condition.StartDate = this.dateEditStartDate.DateTime;
}
if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditEndDate.DateTime, new DateTime()))
{
this.condition.EndDate = global::Helper.DateTimeParse.EndDate;
}
else
{
this.condition.EndDate = this.dateEditEndDate.DateTime;
}
this.condition.ProduceMaterialId0 = this.buttonEditMaterial1.EditValue == null ? null : this.buttonEditMaterial1.EditValue.ToString();
this.condition.ProduceMaterialId1 = this.buttonEditMaterial2.EditValue == null ? null : this.buttonEditMaterial2.EditValue.ToString();
this.condition.Product0 = this.buttonEditProduct1.EditValue == null ? null : this.buttonEditProduct1.EditValue as Model.Product;
this.condition.Product1 = this.buttonEditProduct2.EditValue == null ? null : this.buttonEditProduct2.EditValue as Model.Product;
this.condition.PronoteHeaderId0 = this.buttonEditPronoteHeader1.EditValue == null ? null : this.buttonEditPronoteHeader1.Text;
this.condition.PronoteHeaderId1 = this.buttonEditPronoteHeader2.EditValue == null ? null : this.buttonEditPronoteHeader2.Text;
this.condition.DepartmentId0 = (this.newChooseWorkHouse.EditValue as Model.WorkHouse) == null ? null : (this.newChooseWorkHouse.EditValue as Model.WorkHouse).WorkHouseId;
this.condition.CusInvoiceXOId = this.txtCusInvoiceXOId.Text;
this.condition.CustomerId = (this.ncc_Customer.EditValue == null ? null : (this.ncc_Customer.EditValue as Model.Customer).CustomerId);
}
public Q50(ConditionMaterial condition)
{
InitializeComponent();
this.MaterialCondidtion = condition;
IList <Model.ProduceMaterial> list = produceMaterialManager.SelectBycondition(condition.StartDate, condition.EndDate, condition.ProduceMaterialId0, condition.ProduceMaterialId1, condition.Product0, condition.Product1, condition.DepartmentId0, condition.DepartmentId1, condition.PronoteHeaderId0, condition.PronoteHeaderId1, condition.CusInvoiceXOId, condition.HandBookId);
if (list == null || list.Count <= 0)
{
throw new global::Helper.InvalidValueException("查詢無記錄.");
}
this.xrLabelDates.Text += System.DateTime.Now.ToString("yyyy-MM-dd");
this.xrLabelRepotName.Text = BL.Settings.CompanyChineseName;
this.xrLabelData.Text = Properties.Resources.ProduceMaterialInfo;
#region 注释 获取 加工单商品名称
//Model.InvoiceXO invoiceXO;
//foreach (Model.ProduceMaterial pm in list)
//{
// if (pm.SourceType != 1)
// {
// Model.PronoteHeader pheader = this.pronoteHeaderManager.Get(pm.InvoiceId);
// if (pheader != null)
// {
// pm.ParenProductName = string.IsNullOrEmpty(pheader.Product.CustomerProductName) ? pheader.Product.ProductName : pheader.Product.ProductName + "{" + pheader.Product.CustomerProductName + "}";
// }
// }
// if (!string.IsNullOrEmpty(pm.InvoiceXOId))
// {
// invoiceXO = invoiceXOManager.Get(pm.InvoiceXOId);
// if (invoiceXO != null)
// pm.CusXOId = invoiceXO == null ? string.Empty : invoiceXO.CustomerInvoiceXOId;
// }
//}
#endregion
this.DataSource = list;
this.xrLabelProduceMaterialId.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_ProduceMaterialID);
this.xrLabelDepartment.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_WorkhouseName);
this.xrLabelPronoteHeaderID.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_InvoiceId);
this.xrLabelProduceMaterialDate.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_ProduceMaterialDate, "{0:yyyy-MM-dd}");
this.xrLabelProduct.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterial.PRO_ParenProductName, "{0:yyyy-MM-dd}");
this.xrSubreport1.ReportSource = new Q50_1();
this.xrLabelCusXOId.DataBindings.Add("Text", this.DataSource, "CusXOId");
//数据加总
StringBuilder str = new StringBuilder();
foreach (Model.ProduceMaterial detail in list)
{
if (detail.ProduceMaterialID != null)
{
str.Append("'" + detail.ProduceMaterialID + "',");
}
}
IList <Model.ProduceMaterialdetails> detailTotal = (new BL.ProduceMaterialdetailsManager()).SelectTotalByProduceMaterialID(this.MaterialCondidtion.Product0, this.MaterialCondidtion.Product1, str.ToString().Length > 1 ? str.ToString().Substring(0, str.Length - 1) : "''");
foreach (Model.ProduceMaterialdetails detail in detailTotal)
{
this.xrRichText1.Text += "\r\n" + detail.ProductName + " :" + " 总数:" + detail.Materialprocessum + " 已领数量:" + detail.Materialprocesedsum;
}
}
