public Ro(Model.PCMouldOnlineCheck model)
: this()
{
this.DataSource = model.Detail;
this.lblCompanyName.Text = BL.Settings.CompanyChineseName;
this.lblDate.Text = model.PCMouldOnlineCheckDate.Value.ToString("yyyy-MM-dd");
this.lblEmployee.Text = model.Employee == null ? null : model.Employee.EmployeeName;
this.TCProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
this.TCInvoiceCusId.DataBindings.Add("Text", this.DataSource, "InvoiceXO." + Model.InvoiceXO.PRO_CustomerInvoiceXOId);
this.TCOnlineDate.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_OnlineDate, "{0:MM-dd HH:mm}");
this.TCCheckDate.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_CheckDate, "{0:MM-dd HH:mm}");
this.TCBurr.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_Burr);
this.TCBruise.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_Bruise);
this.TCShrink.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_Shrink);
this.TCForColor.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_ForColor);
this.TCFlap.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_Flap);
this.TCSandwichedConfirm.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_SandwichedConfirm);
this.TCMark.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_Mark);
this.TCAbnormal.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_Abnormal);
this.TCEmployee.DataBindings.Add("Text", this.DataSource, "Employee." + Model.Employee.PROPERTY_EMPLOYEENAME);
//2018年8月30日17:49:26
this.TCAppearance.DataBindings.Add("Text", this.DataSource, Model.PCMouldOnlineCheckDetail.PRO_Appearance);
}
/// <summary>
/// Update a PCMouldOnlineCheck.
/// </summary>
public void Update(Model.PCMouldOnlineCheck pCMouldOnlineCheck)
{
//
// todo: add other logic here.
//
try
{
BL.V.BeginTransaction();
this.Validate(pCMouldOnlineCheck);
pCMouldOnlineCheck.UpdateTime = DateTime.Now;
accessor.Update(pCMouldOnlineCheck);
//删除详细
Detailaccessor.DeleteByHeaderId(pCMouldOnlineCheck.PCMouldOnlineCheckId);
//增加详细
foreach (var item in pCMouldOnlineCheck.Detail)
{
item.PCMouldOnlineCheckId = pCMouldOnlineCheck.PCMouldOnlineCheckId;
Detailaccessor.Insert(item);
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
protected override void MoveLast()
{
if (LastFlag == 1)
{
LastFlag = 0; return;
}
this._pCMouldOnlineCheck = this.manager.GetLast();
}
protected override void AddNew()
{
this._pCMouldOnlineCheck = new Book.Model.PCMouldOnlineCheck();
this._pCMouldOnlineCheck.PCMouldOnlineCheckId = this.manager.GetId();
this._pCMouldOnlineCheck.PCMouldOnlineCheckDate = DateTime.Now;
this.action = "insert";
}
protected override void MoveNext()
{
Model.PCMouldOnlineCheck p = this.manager.GetNext(this._pCMouldOnlineCheck);
if (p == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._pCMouldOnlineCheck = p;
}
public Book.Model.PCMouldOnlineCheck GetDetail(string p)
{
Model.PCMouldOnlineCheck model = this.Get(p);
if (model != null)
{
model.Detail = Detailaccessor.SelectByHeaderId(p);
}
return(model);
}
public EditForm(Model.PCMouldOnlineCheck model, string action)
: this()
{
this._pCMouldOnlineCheck = model;
this.action = action;
if (this.action == "view")
{
LastFlag = 1;
}
}
public EditForm(Model.PCMouldOnlineCheck model)
: this()
{
if (model == null)
{
throw new ArithmeticException("invoiceid");
}
this._pCMouldOnlineCheck = model;
this.action = "view";
if (this.action == "view")
{
LastFlag = 1;
}
}
//搜索
private void barButtonItemSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
ListFrom f = new ListFrom();
if (f.ShowDialog(this) == DialogResult.OK)
{
Model.PCMouldOnlineCheck model = f.SelectItem.PCMouldOnlineCheck as Model.PCMouldOnlineCheck;
if (model != null)
{
this._pCMouldOnlineCheck = model;
this.action = "view";
this.Refresh();
}
}
}
public void Delete(Model.PCMouldOnlineCheck pCMouldOnlineCheck)
{
try
{
BL.V.BeginTransaction();
//删除详细
Detailaccessor.DeleteByHeaderId(pCMouldOnlineCheck.PCMouldOnlineCheckId);
accessor.Delete(pCMouldOnlineCheck.PCMouldOnlineCheckId);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
private void TiGuiExists(Model.PCMouldOnlineCheck model)
{
if (this.ExistsPrimary(model.PCMouldOnlineCheckId))
{
//设置KEY值
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, model.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.InsertTime.Value.Year, model.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.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.PCMouldOnlineCheckId = this.GetId(model.InsertTime.Value);
TiGuiExists(model);
}
}
public void Validate(Model.PCMouldOnlineCheck model)
{
if (model.PCMouldOnlineCheckDate == null)
{
throw new Helper.InvalidValueException(Model.PCMouldOnlineCheck.PRO_PCMouldOnlineCheckDate);
}
foreach (var item in model.Detail)
{
if (item.OnlineDate == null)
{
throw new Helper.InvalidValueException(Model.PCMouldOnlineCheckDetail.PRO_OnlineDate);
}
if (item.CheckDate == null)
{
throw new Helper.InvalidValueException(Model.PCMouldOnlineCheckDetail.PRO_CheckDate);
}
}
}
protected override void Delete()
{
if (this._pCMouldOnlineCheck == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Model.PCMouldOnlineCheck model = this.manager.GetNext(this._pCMouldOnlineCheck);
this.manager.Delete(this._pCMouldOnlineCheck);
if (model == null)
{
this._pCMouldOnlineCheck = this.manager.GetLast();
}
else
{
this._pCMouldOnlineCheck = model;
}
}
}
/// <summary>
/// Insert a PCMouldOnlineCheck.
/// </summary>
public void Insert(Model.PCMouldOnlineCheck pCMouldOnlineCheck)
{
//
// todo:add other logic here
//
try
{
BL.V.BeginTransaction();
this.Validate(pCMouldOnlineCheck);
pCMouldOnlineCheck.InsertTime = DateTime.Now;
pCMouldOnlineCheck.UpdateTime = DateTime.Now;
this.TiGuiExists(pCMouldOnlineCheck);
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, pCMouldOnlineCheck.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, pCMouldOnlineCheck.InsertTime.Value.Year, pCMouldOnlineCheck.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, pCMouldOnlineCheck.InsertTime.Value.ToString("yyyy-MM-dd"));
string sequencekey = string.Format(invoiceKind);
SequenceManager.Increment(sequencekey_y);
SequenceManager.Increment(sequencekey_m);
SequenceManager.Increment(sequencekey_d);
SequenceManager.Increment(sequencekey);
accessor.Insert(pCMouldOnlineCheck);
foreach (var item in pCMouldOnlineCheck.Detail)
{
item.PCMouldOnlineCheckId = pCMouldOnlineCheck.PCMouldOnlineCheckId;
Detailaccessor.Insert(item);
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public override void Refresh()
{
if (this._pCMouldOnlineCheck == null)
{
this.AddNew();
}
else
{
if (this.action == "view")
{
this._pCMouldOnlineCheck = this.manager.GetDetail(this._pCMouldOnlineCheck.PCMouldOnlineCheckId);
}
}
this.txt_Id.EditValue = this._pCMouldOnlineCheck.PCMouldOnlineCheckId;
this.dateEdit1.EditValue = this._pCMouldOnlineCheck.PCMouldOnlineCheckDate;
this.nccEmployee.EditValue = this._pCMouldOnlineCheck.Employee;
this.txt_Note.Text = this._pCMouldOnlineCheck.Note;
this.bindingSourceDetail.DataSource = this._pCMouldOnlineCheck.Detail;
base.Refresh();
switch (this.action)
{
case "insert":
this.gridView1.OptionsBehavior.Editable = true;
break;
case "update":
this.gridView1.OptionsBehavior.Editable = true;
break;
case "view":
this.gridView1.OptionsBehavior.Editable = false;
break;
}
}
public Model.PCMouldOnlineCheck GetNext(Model.PCMouldOnlineCheck e)
{
return sqlmapper.QueryForObject<Model.PCMouldOnlineCheck>("PCMouldOnlineCheck.get_next", e);
}
public Model.PCMouldOnlineCheck GetPrev(Model.PCMouldOnlineCheck e)
{
return sqlmapper.QueryForObject<Model.PCMouldOnlineCheck>("PCMouldOnlineCheck.get_prev", e);
}
public bool HasRowsBefore(Model.PCMouldOnlineCheck e)
{
return sqlmapper.QueryForObject<bool>("PCMouldOnlineCheck.has_rows_before", e);
}
public bool HasRowsAfter(Model.PCMouldOnlineCheck e)
{
return sqlmapper.QueryForObject<bool>("PCMouldOnlineCheck.has_rows_after", e);
}
public void Insert(Model.PCMouldOnlineCheck e)
{
this.Insert<Model.PCMouldOnlineCheck>(e);
}
public void Update(Model.PCMouldOnlineCheck e)
{
this.Update<Model.PCMouldOnlineCheck>(e);
}
public Model.PCMouldOnlineCheck GetNext(Model.PCMouldOnlineCheck e)
{
return(accessor.GetNext(e));
}
public bool HasRowsAfter(Model.PCMouldOnlineCheck e)
{
return(accessor.HasRowsAfter(e));
}
public bool HasRowsBefore(Model.PCMouldOnlineCheck e)
{
return(accessor.HasRowsBefore(e));
}
public override void Refresh()
{
if (this._pCMouldOnlineCheck == null)
{
this.AddNew();
}
else
{
if (this.action == "view")
{
this._pCMouldOnlineCheck = this.manager.GetDetail(this._pCMouldOnlineCheck.PCMouldOnlineCheckId);
}
}
this.txt_Id.EditValue = this._pCMouldOnlineCheck.PCMouldOnlineCheckId;
this.dateEdit1.EditValue = this._pCMouldOnlineCheck.PCMouldOnlineCheckDate;
this.nccEmployee.EditValue = this._pCMouldOnlineCheck.Employee;
#region LookUpEditor
DataTable dt = new DataTable();
//DataColumn dc = new DataColumn("id", typeof(string));
DataColumn dc1 = new DataColumn("name", typeof(string));
//dt.Columns.Add(dc);
dt.Columns.Add(dc1);
DataRow dr;
dr = dt.NewRow();
//dr[0] = "-1";
dr[0] = string.Empty;
dt.Rows.Add(dr);
dr = dt.NewRow();
//dr[0] = "0";
dr[0] = "√";
dt.Rows.Add(dr);
dr = dt.NewRow();
//dr[0] = "1";
dr[0] = "△";
dt.Rows.Add(dr);
dr = dt.NewRow();
//dr[0] = "2";
dr[0] = "X";
dt.Rows.Add(dr);
for (int i = 0; i < this.gridView1.Columns.Count; i++)
{
if (this.gridView1.Columns[i].ColumnEdit is DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit && this.gridView1.Columns[i].Name != "gridColumnEmployee")
{
((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).DataSource = dt;
((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).Columns.Clear();
((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] {
new DevExpress.XtraEditors.Controls.LookUpColumnInfo("name", 25, "标识"),
});
((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).DisplayMember = "name";
((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).ValueMember = "name";
((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).NullText = "";
}
}
#endregion
this.bindingSourceDetail.DataSource = this._pCMouldOnlineCheck.Detail;
base.Refresh();
switch (this.action)
{
case "insert":
this.gridView1.OptionsBehavior.Editable = true;
break;
case "update":
this.gridView1.OptionsBehavior.Editable = true;
break;
case "view":
this.gridView1.OptionsBehavior.Editable = false;
break;
}
}
protected override void MoveFirst()
{
this._pCMouldOnlineCheck = this.manager.GetFirst();
}
