/// <summary>
/// 根据画面上控件的值，生成EntityVo
/// </summary>
private TFactoryMs getVoFromForm()
{
TFactoryMs facVo = new TFactoryMs();
#region
facVo.ICompanyCd = this.txtCompany.Text;
facVo.IFacCd = this.txtFactory.Text;
facVo.IFacArgDesc = this.txtAbbreviation.Text;
facVo.IFacDesc = this.txtName.Text;
facVo.IFacDescKana = this.txtPinyin.Text;
facVo.IMailNo = this.txtZipCD.Text;
facVo.ICountryCd = this.cbbCountry.Selectedvalue;
facVo.IAddress1 = this.txtAddress1.Text;
facVo.IAddress2 = this.txtAddress2.Text;
facVo.IAddress3 = this.txtAddress3.Text;
facVo.ITel = this.txtTel.Text;
facVo.IFaxNo = this.txtFax.Text;
facVo.ILanguageCd = this.cbbLanguage.Selectedvalue;
facVo.ITimezoneCd = this.cbbTimezone.Selectedvalue;
facVo.IBaseCd = this.txtBase.Text;
facVo.ISectionCd = this.txtDepart.Text;
facVo.IEgChgCls = this.cbbChange.Selectedvalue;
facVo.IMrpPeriod = Convert.ToDecimal(this.txtAutoPeriod.Text);
facVo.IAlcPeriod = Convert.ToDecimal(this.txtStockPeriod.Text);
facVo.IPoCreatePeriod = Convert.ToDecimal(this.txtArrange.Text);
facVo.ISafeStockCls = this.cbbSafe.Selectedvalue;
facVo.IRateCls = this.cbbRate.Selectedvalue;
facVo.IPlanCrtCls = this.cbbPlan.Selectedvalue;
facVo.IRsltCstCalcCls = this.cbbCost.Selectedvalue;
facVo.IPoCreateCls = this.cbbDecide.Selectedvalue;
#endregion
return(facVo);
}
/// <summary>
/// 根据画面输入条件，抽出数据
/// </summary>
private void LoadData()
{
IAction_Factory ac = ComponentLocator.Instance().Resolve <IAction_Factory>();
TFactoryMs facVo = ac.GetFactoryByCd(this.txtFactory.Text);
this.SetVoToForm(facVo);
}
//public TRateMs getTRateMs(string facCd)
//{
// TRateMs rateMs = null;
// return rateMs;
//}
#region Sample
public TFactoryMs getFactoryByCd(string facCd)
{
TFactoryMs factory = null;
ISession ss = holder.CreateSession(typeof(TFactoryMsDaoOracleImp));
ITransaction tran = ss.BeginTransaction();
try
{
//result = (IList<MFunctioncatalog>)FindAll(typeof(MFunctioncatalog));
ScalarQuery <TFactoryMs> q = new ScalarQuery <TFactoryMs>(typeof(TFactoryMs), @"
from TFactoryMs where IFacCd=:IFacCd");
q.SetParameter("IFacCd", facCd);
factory = q.Execute();
//FindByPrimaryKey找不到数据的时候是抛出ActiveRecordException，不太好处理
//termms = (TTermMs)FindByPrimaryKey(typeof(TTermMs), userid);
}
catch (Castle.ActiveRecord.Framework.ActiveRecordException ex)
{
tran.Rollback();
throw new ApplicationException(ex.Message, ex);
}
catch (DbException ex)
{
tran.Rollback();
throw new ApplicationException(ex.Message, ex);
}
finally
{
tran.Dispose();
}
return(factory);
}
public Boolean SaveDataToStp(String strMode, TFactoryMs facVo)
{
Boolean rtnValue = true;
LoginUserInfoVo uservo = (LoginUserInfoVo)SessionUtils.GetSession(SessionUtils.COMMON_LOGIN_USER_INFO);
TFcConditionStp facStp = new TFcConditionStp();
PropertiesCopier.CopyProperties(facVo, facStp);
facStp.Id.IJournalNo = 10001;
facStp.Id.ICompanyCd = facVo.ICompanyCd;
facStp.IPrcsCls = CommonUtil.GET_I_PRCS_CLS(strMode);
facStp.IUserId = uservo.Userid;
facStp.IPrcsDate = DateTime.Now;
facStp.IPrcsTime = DateTime.Now.ToShortTimeString();
facStp.IUpdCls = "0";
facStp.IConditionCd = "000001";
//facStp.IDlCurrCd = card.C4_DL_CURR_CD;//取引通貨
facStp.IDelWhInCd = "";
facStp.IDelWhOutCd = "";
facStp.IRjtWhCd = "";
facStp.INonAllocLocation = "";
facStp.IOsWhCd = "";
facStp.IInspectonLocation = "";
facStp.IPlanCycCls = CommonUtil.NullToSpace(facStp.IPlanCycCls);
facStp.IWkTime = CommonUtil.NullToZero(facStp.IWkTime);
facStp.IPoCreateCls = CommonUtil.NullToSpace(facStp.IPoCreateCls);
facStp.ISalesCls = CommonUtil.NullToSpace(facStp.ISalesCls);
facStp.IPoSlcCls = CommonUtil.NullToSpace(facStp.IPoSlcCls);
facStp.IMrpCls = CommonUtil.NullToSpace(facStp.IMrpCls);
facStp.ILinkFlg = CommonUtil.NullToSpace(facStp.ILinkFlg);
facStp.IShipInvCls = CommonUtil.NullToSpace(facStp.IShipInvCls);
facStp.IAcpInvCls = CommonUtil.NullToSpace(facStp.IAcpInvCls);
facStp.IAmtRecalcCls = CommonUtil.NullToSpace(facStp.IAmtRecalcCls);
facStp.IReserve1 = null;
facStp.IReserve2 = null;
facStp.IReserve3 = null;
facStp.ISys1Cls = " ";
facStp.ISys2Cls = " ";
facStp.ISys3Cls = " ";
facStp.IUsr1Cls = " ";
facStp.IUsr2Cls = " ";
facStp.IUsr3Cls = " ";
facStp.IInqItem = null;
//facStp.IObjectId = card.C4_OBJECT_ID;//オブジェクトＩＤ???
//facStp.IEntryDate = ServerFunction.GetDateTime();//登録日
//facStp.IUpdDate = ServerFunction.GetDateTime();//更新日
facStp.IEntryDate = DateTime.Now;
facStp.IUpdDate = DateTime.Now;
//facStp.IPgId = PE002201PgInfo._PROGRAM_ID; ;//プログラムＩＤ
//facStp.IUpdTimestamp = wk_upd_timestamp;//更新タイムスタンプ
ITFcConditionStpDao td = ComponentLocator.Instance().Resolve <ITFcConditionStpDao>();
rtnValue = td.Insert(facStp);
rtnValue = true;
return(rtnValue);
}
public TFactoryMs GetFactoryByCd(String facCd)
{
TFactoryMs facVo = new TFactoryMs();
ITFactoryMsDao td = ComponentLocator.Instance().Resolve <ITFactoryMsDao>();
facVo = td.getFactoryByCd(facCd);
return(facVo);
}
/// <summary>
/// 根据工厂代码，检查数据表中是否存在
/// <param name="facCd">工厂代码</param>
/// <returns>Boolean</returns>
/// </summary>
public Boolean Check01Bool(String facCd)
{
Boolean rtnVal = false;
TFactoryMs vo = Check01Vo(facCd);
if (vo != null && !String.IsNullOrEmpty(vo.IFacCd))
{
rtnVal = true;
}
return(rtnVal);
}
public FactoryVo GetFactoryByCd(string FacCd)
{
ITFactoryMsDao dao = ComponentLocator.Instance().Resolve <ITFactoryMsDao>();
TFactoryMs factoryms = dao.getFactoryByCd(FacCd);
if (factoryms == null)
{
throw new ApplicationException(MessageUtils.GetMessage("E0001"));
}
else
{
FactoryVo factoryvo = new FactoryVo();
PropertiesCopier.CopyProperties(factoryms, factoryvo);
return(factoryvo);
}
}
/// <summary>
/// 工厂代码存在Check
/// </summary>
private void ruleFactoryExist_CustomValidationMethod(object sender, CustomValidationEventArgs e)
{
CheckFactory check = new CheckFactory();
this.lblFactoryNm.Text = "";
TFactoryMs vo = check.Check01Vo(this.atxtFactoryCd.Text);
if (vo != null && !String.IsNullOrEmpty(vo.IFacCd))
{
e.IsValid = true;
this.lblFactoryNm.Text = vo.IFacArgDesc;
}
else
{
e.IsValid = false;
}
}
/// <summary>
/// 根据工厂代码，检查数据表中是否存在
/// <param name="facCd">工厂代码</param>
/// <returns>TFactoryMs</returns>
/// </summary>
public TFactoryMs Check01Vo(String facCd)
{
TFactoryMs vo = new TFactoryMs();
try
{
if (!String.IsNullOrEmpty(facCd))
{
ITFactoryMsDao d = ComponentLocator.Instance().Resolve <ITFactoryMsDao>();
vo = d.getFactoryByCd(facCd);
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
return(vo);
}
/// <summary>
/// 根据EntityVo的值给画面上的控件赋值
/// </summary>
private void SetVoToForm(TFactoryMs facVo)
{
#region
this.txtAbbreviation.Text = facVo.IFacArgDesc;
this.txtName.Text = facVo.IFacDesc;
this.txtPinyin.Text = facVo.IFacDescKana;
this.txtZipCD.Text = facVo.IMailNo;
this.cbbCountry.Selectedvalue = facVo.ICountryCd;
this.txtAddress1.Text = facVo.IAddress1;
this.txtAddress2.Text = facVo.IAddress2;
this.txtAddress3.Text = facVo.IAddress3;
this.txtTel.Text = facVo.ITel;
this.txtFax.Text = facVo.IFaxNo;
this.cbbLanguage.Selectedvalue = facVo.ILanguageCd;
this.cbbTimezone.Selectedvalue = facVo.ITimezoneCd;
this.txtBase.Text = facVo.IBaseCd;
this.txtDepart.Text = facVo.ISectionCd;
CheckSection secCheck = new CheckSection();
TSectionMs secVo = secCheck.Check01Vo(this.txtCompany.Text, facVo.ISectionCd);
if (secVo != null && !String.IsNullOrEmpty(secVo.Id.ISectionCd))
{
this.lblDepartNM.Text = secVo.ISectionDesc;
}
else
{
this.lblDepartNM.Text = "";
}
this.cbbChange.Selectedvalue = facVo.IEgChgCls;
this.txtAutoPeriod.Text = facVo.IMrpPeriod.ToString();
this.txtStockPeriod.Text = facVo.IAlcPeriod.ToString();
this.txtArrange.Text = facVo.IPoCreatePeriod.ToString();
this.cbbSafe.Selectedvalue = facVo.ISafeStockCls;
this.cbbRate.Selectedvalue = facVo.IRateCls;
this.cbbPlan.Selectedvalue = facVo.IPlanCrtCls;
this.cbbCost.Selectedvalue = facVo.IRsltCstCalcCls;
this.cbbDecide.Selectedvalue = facVo.IPoCreateCls;
#endregion
}
/// <summary>
/// 根据画面输入内容，更新数据库
/// </summary>
private void SaveData()
{
IAction_Factory ac = ComponentLocator.Instance().Resolve <IAction_Factory>();
TFactoryMs facVo = this.getVoFromForm();
Boolean val = ac.SaveDataToStp(strMode, facVo);
}
