/// <summary>
/// Update a ProductOnlineCheck.
/// </summary>
public void Update(Model.ProductOnlineCheck productOnlineCheck)
{
//
// todo: add other logic here.
//
Validate(productOnlineCheck);
try
{
BL.V.BeginTransaction();
productOnlineCheck.UpdateTime = DateTime.Now;
accessor.Update(productOnlineCheck);
(new BL.ProductOnlineCheckDetailManager()).DelectByProductOnlineCheckId(productOnlineCheck.ProductOnlineCheckId);
foreach (Model.ProductOnlineCheckDetail model in productOnlineCheck.Detail)
{
(new BL.ProductOnlineCheckDetailManager()).Insert(model);
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public RO(Model.ProductOnlineCheck model)
: this()
{
this.lbl_CompanyName.Text = BL.Settings.CompanyChineseName;
this.lbl_ReportName.Text = Properties.Resources.ProductOnlineCheck;
this.lbl_PrintDate.Text += DateTime.Now.ToString("yyyy-MM-dd");
this.lbl_Id.Text = model.ProductOnlineCheckId;
this.lbl_ProductOnlineCheckDate.Text = model.ProductOnlineCheckDate.Value.ToString("yyyy-MM-dd");
this.lbl_OnlineDate.Text = model.OnlineDate.Value.ToString("yyyy-MM-dd");
this.lbl_InvoiceXOId.Text = model.InvoiceXOId;
this.lbl_PronoteHeaderId.Text = model.PronoteHeaderId;
this.lbl_ProductName.Text = model.Product == null ? null : model.Product.ProductName;
this.lbl_Employee.Text = model.Employee == null ? null : model.Employee.EmployeeName;
this.xrRichText1.Rtf = model.Remark;
foreach (Model.ProductOnlineCheckDetail detail in model.Detail)
{
detail.MaoBian = this.Scaler(detail.MaoBian);
detail.CaShang = this.Scaler(detail.CaShang);
detail.SuoShui = this.Scaler(detail.SuoShui);
detail.DuiSe = this.Scaler(detail.DuiSe);
detail.Zhepian = this.Scaler(detail.Zhepian);
}
this.DataSource = model.Detail;
this.TC_CheckDate.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_CheckDate, "{0:yyyy-MM-dd}");
this.TC_CaShang.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_CaShang);
this.TC_MaoBian.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_MaoBian);
this.TC_SuoShui.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_SuoShui);
this.TC_DuiSe.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_DuiSe);
this.TC_ZhePian.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_Zhepian);
this.TC_Exception.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_Remark);
}
protected override void MoveLast()
{
if (this.LastFlag == 1)
{
this.LastFlag = 0; return;
}
this._ProductOnlineCheck = this._ProductOnlineCheckManager.GetLast();
}
public RO(Model.ProductOnlineCheck model)
: this()
{
this.lbl_CompanyName.Text = BL.Settings.CompanyChineseName;
this.lbl_ReportName.Text = "首件上线检查表"; //Properties.Resources.ProductOnlineCheck;
//this.lbl_PrintDate.Text += DateTime.Now.ToString("yyyy-MM-dd");
this.lbl_Id.Text = model.ProductOnlineCheckId;
//this.lbl_ProductOnlineCheckDate.Text = model.ProductOnlineCheckDate.Value.ToString("yyyy-MM-dd");
this.lbl_OnlineDate.Text = model.OnlineDate.Value.ToString("yyyy-MM-dd");
if (model.InvoiceXO != null)
{
this.lbl_InvoiceXOId.Text = model.InvoiceXO.CustomerInvoiceXOId;
}
else if (model.PronoteHeader != null)
{
this.lbl_InvoiceXOId.Text = model.PronoteHeader.InvoiceXO == null ? "" : model.PronoteHeader.InvoiceXO.CustomerInvoiceXOId;
}
this.lbl_PronoteHeaderId.Text = model.PronoteHeaderId;
this.lbl_ProductName.Text = model.Product == null ? null : model.Product.ProductName;
this.lbl_Employee.Text = model.Employee == null ? null : model.Employee.EmployeeName;
//this.xrRichText1.Rtf = model.Remark;
this.lbl_Note.Text = model.Note;
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_CustomerProductName.Text = model.Product == null ? null : model.Product.CustomerProductName;
if (model.Product != null)
{
if (string.IsNullOrEmpty(model.Product.CustomerProductName))
{
this.lbl_CustomerProductName.Text = CommonHelp.GetCustomerProductNameByPronoteHeaderId(model.PronoteHeaderId, model.ProductId);
}
else
{
this.lbl_CustomerProductName.Text = model.Product.CustomerProductName;
}
}
foreach (Model.ProductOnlineCheckDetail detail in model.Detail)
{
detail.MaoBian = this.Scaler(detail.MaoBian);
detail.CaShang = this.Scaler(detail.CaShang);
detail.SuoShui = this.Scaler(detail.SuoShui);
detail.DuiSe = this.Scaler(detail.DuiSe);
detail.Zhepian = this.Scaler(detail.Zhepian);
}
this.DataSource = model.Detail.OrderBy(d => d.CheckDate).ToList();
this.TC_CheckDate.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_CheckDate, "{0:yyyy-MM-dd HH:mm:ss}");
this.TC_CaShang.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_CaShang);
this.TC_MaoBian.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_MaoBian);
this.TC_SuoShui.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_SuoShui);
this.TC_DuiSe.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_DuiSe);
this.TC_ZhePian.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_Zhepian);
this.TC_Exception.DataBindings.Add("Text", DataSource, Model.ProductOnlineCheckDetail.PRO_Remark);
this.xrTBusinessHours.DataBindings.Add("Text", DataSource, "BusinessHours." + Model.BusinessHours.PROPERTY_BUSINESSHOURSNAME);
}
protected override void MoveNext()
{
Model.ProductOnlineCheck model = this._ProductOnlineCheckManager.GetNext(this._ProductOnlineCheck);
if (model == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._ProductOnlineCheck = model;
}
protected override void AddNew()
{
this._ProductOnlineCheck = new Book.Model.ProductOnlineCheck();
this._ProductOnlineCheck.ProductOnlineCheckId = this._ProductOnlineCheckManager.GetId();
this._ProductOnlineCheckManager.TiGuiExists(this._ProductOnlineCheck);
this._ProductOnlineCheck.ProductOnlineCheckDate = DateTime.Now;
this.action = "insert";
}
public override void Refresh()
{
if (this._ProductOnlineCheck == null)
{
this.AddNew();
}
else
{
if (this.action == "view")
{
this._ProductOnlineCheck = this._ProductOnlineCheckManager.Get(this._ProductOnlineCheck.ProductOnlineCheckId);
}
}
this.txt_Id.EditValue = this._ProductOnlineCheck.ProductOnlineCheckId;
//this.date_ProductOnlineCheck.EditValue = this._ProductOnlineCheck.ProductOnlineCheckDate;
this.date_Online.EditValue = this._ProductOnlineCheck.OnlineDate;
this.newCCEmployee.EditValue = this._ProductOnlineCheck.Employee;
this.txt_ProductName.EditValue = this._ProductOnlineCheck.Product == null ? null : this._ProductOnlineCheck.Product.ToString();
if (this._ProductOnlineCheck.InvoiceXO != null)
{
this.txt_InvoiceXOId.EditValue = this._ProductOnlineCheck.InvoiceXO.CustomerInvoiceXOId;
}
else if (this._ProductOnlineCheck.PronoteHeader != null)
{
this.txt_InvoiceXOId.EditValue = this._ProductOnlineCheck.PronoteHeader.InvoiceXO == null ? "" : this._ProductOnlineCheck.PronoteHeader.InvoiceXO.CustomerInvoiceXOId;
}
this.txt_PronoteHeaderId.EditValue = this._ProductOnlineCheck.PronoteHeaderId;
this.richTextBoxRemark.Rtf = this._ProductOnlineCheck.Remark;
this.newChooseContorlAuditEmp.EditValue = this._ProductOnlineCheck.AuditEmp;
this.txt_AuditState.EditValue = this.GetAuditName(this._ProductOnlineCheck.AuditState);
this.memoEdit1.EditValue = this._ProductOnlineCheck.Note;
this.spinEditCheckNum.EditValue = this._ProductOnlineCheck.CheckNum;
this.spinEditPassNum.EditValue = this._ProductOnlineCheck.PassNum;
this.cobProductUnit.EditValue = this._ProductOnlineCheck.ProductUnit;
this._ProductOnlineCheck.Detail = this._detailManager.SelectByProductOnlineCheckId(this._ProductOnlineCheck.ProductOnlineCheckId);
this.bindingSource1.DataSource = this._ProductOnlineCheck.Detail;
this.gridControl1.RefreshDataSource();
base.Refresh();
switch (this.action)
{
case "view":
this.gridView1.OptionsBehavior.Editable = false;
break;
default:
this.gridView1.OptionsBehavior.Editable = true;
break;
}
this.txt_Id.Enabled = true;
this.txt_Id.Properties.ReadOnly = true;
}
public Editform(Model.ProductOnlineCheck ProductOnlineCheck, string action)
: this()
{
this._ProductOnlineCheck = ProductOnlineCheck;
this.action = action;
if (this.action == "view")
{
LastFlag = 1;
}
}
public Editform(string ProductOnlineCheckId)
: this()
{
this._ProductOnlineCheck = this._ProductOnlineCheckManager.Get(ProductOnlineCheckId);
if (this._ProductOnlineCheck != null)
{
this._ProductOnlineCheck.Detail = this._detailManager.SelectByProductOnlineCheckId(this._ProductOnlineCheck.ProductOnlineCheckId);
}
this.action = "view";
this.flag = 1;
}
protected override void AddNew()
{
this._ProductOnlineCheck = new Book.Model.ProductOnlineCheck();
this._ProductOnlineCheck.ProductOnlineCheckId = this._ProductOnlineCheckManager.GetId();
this._ProductOnlineCheckManager.TiGuiExists(this._ProductOnlineCheck);
this._ProductOnlineCheck.OnlineDate = DateTime.Now;
//this._ProductOnlineCheck.Employee = BL.V.ActiveOperator.Employee;
//if (this._ProductOnlineCheck.Employee != null)
// this._ProductOnlineCheck.EmployeeId = this._ProductOnlineCheck.Employee.EmployeeId;
this.action = "insert";
}
private void Validate(Model.ProductOnlineCheck model)
{
//if (model.ProductOnlineCheckDate == null)
// throw new Helper.RequireValueException(Model.ProductOnlineCheck.PRO_ProductOnlineCheckDate);
if (model.OnlineDate == null)
{
throw new Helper.RequireValueException(Model.ProductOnlineCheck.PRO_OnlineDate);
}
if (model.ProductId == null)
{
throw new Helper.RequireValueException(Model.ProductOnlineCheck.PRO_ProductId);
}
}
public Editform(Model.ProductOnlineCheck ProductOnlineCheck)
: this()
{
if (ProductOnlineCheck == null)
{
throw new ArithmeticException("invoiceid");
}
this._ProductOnlineCheck = ProductOnlineCheck;
this.action = "view";
if (this.action == "view")
{
LastFlag = 1;
}
}
public Editform(string invoiceId)
: this()
{
this._ProductOnlineCheck = this._ProductOnlineCheckManager.Get(invoiceId);
if (this._ProductOnlineCheck == null)
{
throw new ArithmeticException("invoiceid");
}
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.ProductOnlineCheck model = f.SelectItem as Model.ProductOnlineCheck;
if (model != null)
{
this._ProductOnlineCheck = model;
this.action = "view";
this.Refresh();
}
}
}
public void TiGuiExists(Model.ProductOnlineCheck model)
{
if (this.ExistsPrimary(model.ProductOnlineCheckId))
{
//设置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.ProductOnlineCheckId = this.GetId(DateTime.Now);
TiGuiExists(model);
//throw new Helper.InvalidValueException(Model.Product.PRO_Id);
}
}
protected override void Delete()
{
if (this._ProductOnlineCheck == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Model.ProductOnlineCheck model = this._ProductOnlineCheckManager.GetNext(this._ProductOnlineCheck);
this._ProductOnlineCheckManager.Delete(this._ProductOnlineCheck.ProductOnlineCheckId);
if (model == null)
{
this._ProductOnlineCheck = this._ProductOnlineCheckManager.GetLast();
}
else
{
this._ProductOnlineCheck = model;
}
}
}
public void Update(Model.ProductOnlineCheck e)
{
this.Update <Model.ProductOnlineCheck>(e);
}
public bool HasRowsAfter(Model.ProductOnlineCheck e)
{
return(accessor.HasRowsAfter(e));
}
public Model.ProductOnlineCheck GetNext(Model.ProductOnlineCheck e)
{
return(accessor.GetNext(e));
}
public bool HasRowsAfter(Model.ProductOnlineCheck e)
{
return(sqlmapper.QueryForObject <bool>("ProductOnlineCheck.has_rows_after", e));
}
public bool HasRowsBefore(Model.ProductOnlineCheck e)
{
return(accessor.HasRowsBefore(e));
}
protected override void MoveFirst()
{
this._ProductOnlineCheck = this._ProductOnlineCheckManager.GetFirst();
}
public Model.ProductOnlineCheck GetNext(Model.ProductOnlineCheck e)
{
return(sqlmapper.QueryForObject <Model.ProductOnlineCheck>("ProductOnlineCheck.get_next", e));
}
public Model.ProductOnlineCheck GetPrev(Model.ProductOnlineCheck e)
{
return(sqlmapper.QueryForObject <Model.ProductOnlineCheck>("ProductOnlineCheck.get_prev", e));
}
public void Insert(Model.ProductOnlineCheck e)
{
this.Insert <Model.ProductOnlineCheck>(e);
}
public bool HasRowsBefore(Model.ProductOnlineCheck e)
{
return(sqlmapper.QueryForObject <bool>("ProductOnlineCheck.has_rows_before", e));
}
