public RO2(Model.PCFirstOnlineCheck model)
: this()
{
this.lbl_CompanyName.Text = BL.Settings.CompanyChineseName;
//this.lbl_ReportName.Text = "首件上线检查表";
this.lbl_Id.Text = model.PCFirstOnlineCheckId;
this.lbl_OnlineDate.Text = model.OnlineDate.Value.ToString("yyyy-MM-dd");
this.lbl_PronoteHeaderId.Text = model.PronoteHeaderId;
this.lblCheckNum.Text = model.CheckNum == null ? "" : model.CheckNum.Value.ToString("0.##");
this.lblPassNum.Text = model.PassNum == null ? "" : model.PassNum.Value.ToString("0.##");
this.lblProductUnit.Text = model.ProductUnit;
this.DataSource = model.Detail.OrderBy(d => d.CheckDate).ToList();
this.TC_InvoiceCusId.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_InvoiceXOCusId);
this.TC_Product.DataBindings.Add("Text", DataSource, "Product.ProductName");
this.TC_CheckDate.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_CheckDate, "{0:yyyy-MM-dd HH:mm}");
this.TC_Biduixiandu.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_DuibiXiandu);
this.xrTBusinessHours.DataBindings.Add("Text", DataSource, "BusinessHours." + Model.BusinessHours.PROPERTY_BUSINESSHOURSNAME);
this.TC_Jihao.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Jihao);
this.TC_Waiguan.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Waiguan);
this.TC_Note.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Remark);
this.TC_Employee.DataBindings.Add("Text", DataSource, "Employee.EmployeeName");
}
private void Validate(Model.PCFirstOnlineCheck model)
{
if (model.OnlineDate == null)
{
throw new Helper.RequireValueException(Model.PCFirstOnlineCheck.PRO_OnlineDate);
}
}
/// <summary>
/// Insert a PCFirstOnlineCheck.
/// </summary>
public void Insert(Model.PCFirstOnlineCheck pCFirstOnlineCheck)
{
//
// todo:add other logic here
//
Validate(pCFirstOnlineCheck);
TiGuiExists(pCFirstOnlineCheck);
try
{
BL.V.BeginTransaction();
pCFirstOnlineCheck.InsertTime = DateTime.Now;
pCFirstOnlineCheck.UpdateTime = DateTime.Now;
accessor.Insert(pCFirstOnlineCheck);
foreach (Model.PCFirstOnlineCheckDetail model in pCFirstOnlineCheck.Detail)
{
model.PCFirstOnlineCheckId = pCFirstOnlineCheck.PCFirstOnlineCheckId;
detailAccessor.Insert(model);
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
protected override void MoveLast()
{
if (this.LastFlag == 1)
{
this.LastFlag = 0; return;
}
this._PCFirstOnlineCheck = this._PCFirstOnlineCheckManager.GetLast();
}
protected override void AddNew()
{
this._PCFirstOnlineCheck = new Book.Model.PCFirstOnlineCheck();
this._PCFirstOnlineCheck.PCFirstOnlineCheckId = this._PCFirstOnlineCheckManager.GetId();
this._PCFirstOnlineCheckManager.TiGuiExists(this._PCFirstOnlineCheck);
this._PCFirstOnlineCheck.OnlineDate = DateTime.Now;
this.action = "insert";
}
protected override void MovePrev()
{
Model.PCFirstOnlineCheck model = this._PCFirstOnlineCheckManager.GetPrev(this._PCFirstOnlineCheck);
if (model == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._PCFirstOnlineCheck = model;
}
public Editform_BackUp(Model.PCFirstOnlineCheck PCFirstOnlineCheck, string action)
: this()
{
this._PCFirstOnlineCheck = PCFirstOnlineCheck;
this.action = action;
if (this.action == "view")
{
LastFlag = 1;
}
}
public RO(Model.PCFirstOnlineCheck model)
: this()
{
this.lbl_CompanyName.Text = BL.Settings.CompanyChineseName;
//this.lbl_ReportName.Text = "首件上线检查表";
this.lbl_Id.Text = model.PCFirstOnlineCheckId;
this.lbl_OnlineDate.Text = model.OnlineDate.Value.ToString("yyyy-MM-dd");
this.lbl_PronoteHeaderId.Text = model.PronoteHeaderId;
this.lblCheckNum.Text = model.CheckNum == null ? "" : model.CheckNum.Value.ToString("0.##");
this.lblPassNum.Text = model.PassNum == null ? "" : model.PassNum.Value.ToString("0.##");
this.lblProductUnit.Text = model.ProductUnit;
this.lbl_CheckedStandard.Text = model.CheckedStandard;
this.lbl_Note.Text = model.Note;
if (model.PronoteHeader != null)
{
this.lbl_ProductName.Text = model.PronoteHeader.Product.ProductName;
this.lbl_CusXOId.Text = model.PronoteHeader.InvoiceCusId;
if (!string.IsNullOrEmpty(model.PronoteHeader.Product.CustomerProductName))
{
this.lbl_CustomerProduct.Text = model.PronoteHeader.Product.CustomerProductName;
}
else
{
this.lbl_CustomerProduct.Text = CommonHelp.GetCustomerProductNameByPronoteHeaderId(model.PronoteHeaderId, model.PronoteHeader.ProductId);
}
}
this.DataSource = model.Detail.OrderBy(d => d.CheckDate).ToList();
//this.TC_InvoiceCusId.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_InvoiceXOCusId);
//this.TC_Product.DataBindings.Add("Text", DataSource, "Product.ProductName");
this.TC_CheckDate.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_CheckDate, "{0:yyyy-MM-dd HH:mm}");
this.TC_Biduixiandu.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_DuibiXiandu);
this.xrTBusinessHours.DataBindings.Add("Text", DataSource, "BusinessHours." + Model.BusinessHours.PROPERTY_BUSINESSHOURSNAME);
this.TC_Jihao.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Jihao);
this.TC_Waiguan.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Waiguan);
this.TC_Guangxue.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Guangxue);
this.TC_Houdu.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Houdu);
this.TC_Chongji.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Chongji);
this.TC_Note.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Remark);
this.TC_Employee.DataBindings.Add("Text", DataSource, "Employee.EmployeeName");
this.TC_Jiagongbie.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Jiagongbie);
this.TC_Sehao.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Sehao);
this.TC_Size.DataBindings.Add("Text", DataSource, Model.PCFirstOnlineCheckDetail.PRO_Chicun);
this.subReportGX.ReportSource = new subReportGX("2");
this.subReportHD.ReportSource = new subReportHD("2");
this.subreportChongji.ReportSource = new ROImpactCheck();
}
public Model.PCFirstOnlineCheck GetDetail(string pCFirstOnlineCheckId)
{
Model.PCFirstOnlineCheck model = this.Get(pCFirstOnlineCheckId);
if (model != null)
{
model.Detail = detailAccessor.SelectByHeaderId(pCFirstOnlineCheckId);
}
return(model);
}
public Editform_BackUp(string invoiceId)
: this()
{
this._PCFirstOnlineCheck = this._PCFirstOnlineCheckManager.Get(invoiceId);
if (this._PCFirstOnlineCheck == null)
{
throw new ArithmeticException("invoiceid");
}
this.action = "view";
if (this.action == "view")
{
LastFlag = 1;
}
}
public Editform_BackUp(Model.PCFirstOnlineCheck PCFirstOnlineCheck)
: this()
{
if (PCFirstOnlineCheck == null)
{
throw new ArithmeticException("invoiceid");
}
this._PCFirstOnlineCheck = PCFirstOnlineCheck;
this.action = "view";
if (this.action == "view")
{
LastFlag = 1;
}
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
List f = new List();
if (f.ShowDialog(this) == DialogResult.OK)
{
Model.PCFirstOnlineCheck model = f.SelectItem as Model.PCFirstOnlineCheck;
if (model != null)
{
this._PCFirstOnlineCheck = model;
this.action = "view";
this.Refresh();
}
}
}
public void TiGuiExists(Model.PCFirstOnlineCheck model)
{
if (this.ExistsPrimary(model.PCFirstOnlineCheckId))
{
//设置KEY值
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, DateTime.Now.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, DateTime.Now.Year, DateTime.Now.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, DateTime.Now.ToString("yyyy-MM-dd"));
string sequencekey = string.Format(invoiceKind);
SequenceManager.Increment(sequencekey_y);
SequenceManager.Increment(sequencekey_m);
SequenceManager.Increment(sequencekey_d);
SequenceManager.Increment(sequencekey);
model.PCFirstOnlineCheckId = this.GetId(DateTime.Now);
TiGuiExists(model);
}
}
protected override void Delete()
{
if (this._PCFirstOnlineCheck == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Model.PCFirstOnlineCheck model = this._PCFirstOnlineCheckManager.GetNext(this._PCFirstOnlineCheck);
this._PCFirstOnlineCheckManager.Delete(this._PCFirstOnlineCheck.PCFirstOnlineCheckId);
if (model == null)
{
this._PCFirstOnlineCheck = this._PCFirstOnlineCheckManager.GetLast();
}
else
{
this._PCFirstOnlineCheck = model;
}
}
}
/// <summary>
/// Update a PCFirstOnlineCheck.
/// </summary>
public void Update(Model.PCFirstOnlineCheck pCFirstOnlineCheck)
{
//
// todo: add other logic here.
//
Validate(pCFirstOnlineCheck);
try
{
BL.V.BeginTransaction();
pCFirstOnlineCheck.UpdateTime = DateTime.Now;
accessor.Update(pCFirstOnlineCheck);
detailAccessor.DelectByHeaderId(pCFirstOnlineCheck.PCFirstOnlineCheckId);
foreach (Model.PCFirstOnlineCheckDetail model in pCFirstOnlineCheck.Detail)
{
detailAccessor.Insert(model);
}
//IList<Model.PCFirstOnlineCheckDetail> details = detailAccessor.SelectByHeaderId(pCFirstOnlineCheck.PCFirstOnlineCheckId);
//foreach (var item in pCFirstOnlineCheck.Detail)
//{
// if (details.Any(d => d.PCFirstOnlineCheckDetailId == item.PCFirstOnlineCheckDetailId))
// detailAccessor.Update(item);
// else
// detailAccessor.Insert(item);
//}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public Model.PCFirstOnlineCheck GetNext(Model.PCFirstOnlineCheck e)
{
return(accessor.GetNext(e));
}
public bool HasRowsBefore(Model.PCFirstOnlineCheck e)
{
return(accessor.HasRowsBefore(e));
}
public void Update(Model.PCFirstOnlineCheck e)
{
this.Update<Model.PCFirstOnlineCheck>(e);
}
public void Insert(Model.PCFirstOnlineCheck e)
{
this.Insert<Model.PCFirstOnlineCheck>(e);
}
public bool HasRowsAfter(Model.PCFirstOnlineCheck e)
{
return sqlmapper.QueryForObject<bool>("PCFirstOnlineCheck.has_rows_after", e);
}
public bool HasRowsBefore(Model.PCFirstOnlineCheck e)
{
return sqlmapper.QueryForObject<bool>("PCFirstOnlineCheck.has_rows_before", e);
}
public Model.PCFirstOnlineCheck GetNext(Model.PCFirstOnlineCheck e)
{
return sqlmapper.QueryForObject<Model.PCFirstOnlineCheck>("PCFirstOnlineCheck.get_next", e);
}
public Model.PCFirstOnlineCheck GetPrev(Model.PCFirstOnlineCheck e)
{
return sqlmapper.QueryForObject<Model.PCFirstOnlineCheck>("PCFirstOnlineCheck.get_prev", e);
}
public override void Refresh()
{
if (this._PCFirstOnlineCheck == null)
{
this.AddNew();
}
else
{
if (this.action == "view")
{
this._PCFirstOnlineCheck = this._PCFirstOnlineCheckManager.GetDetail(this._PCFirstOnlineCheck.PCFirstOnlineCheckId);
}
}
this.txt_Id.EditValue = this._PCFirstOnlineCheck.PCFirstOnlineCheckId;
//this.date_PCFirstOnlineCheck.EditValue = this._PCFirstOnlineCheck.PCFirstOnlineCheckDate;
this.date_Online.EditValue = this._PCFirstOnlineCheck.OnlineDate;
this.txt_PronoteHeaderId.EditValue = this._PCFirstOnlineCheck.PronoteHeaderId;
this.newChooseContorlAuditEmp.EditValue = this._PCFirstOnlineCheck.AuditEmp;
this.txt_AuditState.EditValue = this.GetAuditName(this._PCFirstOnlineCheck.AuditState);
this.spinEditCheckNum.EditValue = this._PCFirstOnlineCheck.CheckNum;
this.spinEditPassNum.EditValue = this._PCFirstOnlineCheck.PassNum;
this.cobProductUnit.EditValue = this._PCFirstOnlineCheck.ProductUnit;
this.txt_CustomerProduct.EditValue = this._PCFirstOnlineCheck.PronoteHeader == null ? "" : this._PCFirstOnlineCheck.PronoteHeader.Product.CustomerProductName;
this.txt_CheckedStandard.EditValue = this._PCFirstOnlineCheck.CheckedStandard;
this.bindingSourceDetail.DataSource = this._PCFirstOnlineCheck.Detail;
this.gridControl1.RefreshDataSource();
base.Refresh();
switch (this.action)
{
case "view":
//this.gridView1.OptionsBehavior.Editable = false;
this.gridColumn1.OptionsColumn.AllowEdit = false;
this.gridColumn2.OptionsColumn.AllowEdit = false;
this.gridColumn3.OptionsColumn.AllowEdit = false;
this.gridColumn4.OptionsColumn.AllowEdit = false;
this.gridColumn5.OptionsColumn.AllowEdit = false;
this.gridColumn6.OptionsColumn.AllowEdit = false;
this.gridColumn7.OptionsColumn.AllowEdit = false;
this.gridColumn8.OptionsColumn.AllowEdit = false;
this.gridColumn9.OptionsColumn.AllowEdit = true;
this.gridColumn10.OptionsColumn.AllowEdit = true;
this.gridColumn11.OptionsColumn.AllowEdit = true;
break;
default:
//this.gridView1.OptionsBehavior.Editable = true;
this.gridColumn1.OptionsColumn.AllowEdit = true;
this.gridColumn2.OptionsColumn.AllowEdit = false;
this.gridColumn3.OptionsColumn.AllowEdit = true;
this.gridColumn4.OptionsColumn.AllowEdit = false;
this.gridColumn5.OptionsColumn.AllowEdit = true;
this.gridColumn6.OptionsColumn.AllowEdit = true;
this.gridColumn7.OptionsColumn.AllowEdit = true;
this.gridColumn8.OptionsColumn.AllowEdit = true;
this.gridColumn9.OptionsColumn.AllowEdit = true;
this.gridColumn10.OptionsColumn.AllowEdit = true;
this.gridColumn11.OptionsColumn.AllowEdit = true;
break;
}
this.txt_Id.Enabled = true;
this.txt_Id.Properties.ReadOnly = true;
this.txt_CustomerProduct.Properties.ReadOnly = true;
}
protected override void MoveFirst()
{
this._PCFirstOnlineCheck = this._PCFirstOnlineCheckManager.GetFirst();
}
public bool HasRowsAfter(Model.PCFirstOnlineCheck e)
{
return(accessor.HasRowsAfter(e));
}
