protected object GetEditObject()
{
if (_facade == null)
{
_facade = new SPCFacade(base.DataProvider);
}
SPCObjectStore spcObj = (SPCObjectStore)_facade.GetSPCObjectStore(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtObjectCode.Text)),
Convert.ToDecimal(this.txtGroupIndex.Text),
FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtCKGroup.Text)),
FormatHelper.CleanString(this.txtCKItemCode.Text));
if (spcObj == null)
{
spcObj = this._facade.CreateNewSPCObjectStore();
}
spcObj.ObjectCode = this.txtObjectCode.Text;
spcObj.GroupSeq = Convert.ToDecimal(this.txtGroupIndex.Text);
spcObj.CKGroup = this.txtCKGroup.Text;
spcObj.CKItemCode = this.txtCKItemCode.Text;
spcObj.MaintainUser = this.GetUserCode();
spcObj.MaintainDate = FormatHelper.TODateInt(DateTime.Today);
spcObj.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
return(spcObj);
}
protected DataRow GetGridRow(object obj)
{
SPCObjectStore spcObj = (SPCObjectStore)obj;
//spcObj.eAttribute1 = this.txtObjectName.Text;
//return new Infragistics.WebUI.UltraWebGrid.UltraGridRow(
// new object[]{"false",
// spcObj.Serial,
// this.txtObjectCode.Text,
// this.txtObjectName.Text,
// spcObj.GroupSeq,
// spcObj.CKGroup,
// spcObj.CKItemCode,
// spcObj.MaintainUser,
// FormatHelper.ToDateString(spcObj.MaintainDate),
// FormatHelper.ToTimeString(spcObj.MaintainTime),
// ""});
DataRow row = this.DtSource.NewRow();
row["Serial"] = spcObj.Serial;
row["SPCControlItem"] = this.txtObjectCode.Text;
row["ObjectName"] = this.txtObjectName.Text;
row["GroupSeq"] = spcObj.GroupSeq;
row["CheckGroup"] = spcObj.CKGroup;
row["CHECKITEMLIST"] = spcObj.CKItemCode;
row["MaintainUser"] = spcObj.MaintainUser;
row["MaintainDate"] = FormatHelper.ToDateString(spcObj.MaintainDate);
row["MaintainTime"] = FormatHelper.ToTimeString(spcObj.MaintainTime);
return(row);
}
protected List <SPCObjectStore> GetEditObjects()
{
if (_facade == null)
{
_facade = new SPCFacade(base.DataProvider);
}
SPCObjectStore spcObj;
List <SPCObjectStore> spcObjList = new List <SPCObjectStore>();
if (this.txtCKItemCode.Text == "")
{
OQCFacade _OQCFacade = new OQCFacade(base.DataProvider);
object[] CKItemCodes = _OQCFacade.GetOQCCheckListByCheckGroup(this.txtCKGroup.Text);
if (CKItemCodes != null)
{
foreach (OQCCheckListQuery item in CKItemCodes)
{
spcObj = new SPCObjectStore();
spcObj.CKItemCode = item.CheckItemCode;
spcObj.ObjectCode = this.txtObjectCode.Text;
spcObj.GroupSeq = Convert.ToDecimal(this.txtGroupIndex.Text);
spcObj.CKGroup = this.txtCKGroup.Text;
spcObj.MaintainUser = this.GetUserCode();
spcObj.MaintainDate = FormatHelper.TODateInt(DateTime.Today);
spcObj.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
spcObjList.Add(spcObj);
}
}
}
else
{
string[] ckItemCodes = this.txtCKItemCode.Text.Split(',');
foreach (string str in ckItemCodes)
{
spcObj = new SPCObjectStore();
spcObj.CKItemCode = str;
spcObj.ObjectCode = this.txtObjectCode.Text;
spcObj.GroupSeq = Convert.ToDecimal(this.txtGroupIndex.Text);
spcObj.CKGroup = this.txtCKGroup.Text;
spcObj.MaintainUser = this.GetUserCode();
spcObj.MaintainDate = FormatHelper.TODateInt(DateTime.Today);
spcObj.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
spcObjList.Add(spcObj);
}
}
return(spcObjList);
}
protected string[] FormatExportRecord(object obj)
{
SPCObjectStore spcObj = (SPCObjectStore)obj;
//spcObj.eAttribute1 = this.txtObjectName.Text;
return(new string[] { this.txtObjectCode.Text,
this.txtObjectName.Text,
spcObj.GroupSeq.ToString(),
spcObj.CKGroup,
spcObj.CKItemCode,
spcObj.MaintainUser,
FormatHelper.ToDateString(spcObj.MaintainDate),
FormatHelper.ToTimeString(spcObj.MaintainTime) });
}
protected void SetEditObject(object obj)
{
if (obj == null)
{
this.txtGroupIndex.Text = "0";
this.txtCKGroup.Text = "";
this.txtCKItemCode.Text = "";
return;
}
SPCObjectStore spcObj = (SPCObjectStore)obj;
this.txtGroupIndex.Text = spcObj.GroupSeq.ToString();
this.txtCKGroup.Text = spcObj.CKGroup.ToString();
this.txtCKItemCode.Text = spcObj.CKItemCode.ToString();
}
/// <summary>
/// 查询产品控制对象的数据存储栏位索引
/// </summary>
/// <returns></returns>
public int GetDataColumnIndex(string itemCode, string spcObjectCode, decimal groupSequence)
{
if (htSpcDataIdx == null)
{
htSpcDataIdx = new Hashtable();
}
string strKey = itemCode + "||" + spcObjectCode + "||" + Convert.ToInt32(groupSequence).ToString();
if (htSpcDataIdx.ContainsKey(strKey) == true)
{
return(Convert.ToInt32(htSpcDataIdx[strKey]));
}
else
{
string strSql = "SELECT * FROM TBLSPCOBJECTSTORE WHERE ObjectCode='" + spcObjectCode + "' AND GroupSeq=" + groupSequence.ToString();
object[] objs = this.DataProvider.CustomQuery(typeof(SPCObjectStore), new SQLCondition(strSql));
if (objs != null && objs.Length > 0)
{
SPCObjectStore spcStore = (SPCObjectStore)objs[0];
//return Convert.ToInt32(spcStore.StoreColumn);
}
}
return(-1);
}
public void DeleteSPCObjectStore(SPCObjectStore sPCObjectStore)
{
this._helper.DeleteDomainObject(sPCObjectStore);
}
public void UpdateSPCObjectStore(SPCObjectStore sPCObjectStore)
{
this._helper.UpdateDomainObject(sPCObjectStore);
}
public void AddSPCObjectStore(SPCObjectStore sPCObjectStore)
{
this._helper.AddDomainObject(sPCObjectStore);
}
