コード例 #1
0
        public virtual SubjectInformationDomain CreateSubjectInformationDomain()
        {
            SubjectInformationEntity entity = new SubjectInformationEntity();
            entity.SubjectInformationId = Guid.NewGuid().ToString();

            return new SubjectInformationDomain(entity);
        }
コード例 #2
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(txtSubjectName.Text.Trim()))
            {
                AlertMessage("Subject Name can not be null.");
                return;
            }
            bool isUpdate = false;
            SubjectInformationEntity entity = new SubjectInformationEntity();
            if (SubjectInformationID == "")
            {
                entity.SubjectInformationId = Guid.NewGuid().ToString();
                SubjectInformationID = entity.SubjectInformationId;
            }
            else
            {
                isUpdate = true;
                entity.SubjectInformationId = SubjectInformationID;
            }
            entity.ActionNo = txtActionNo.Text.Trim();
            entity.Name = txtSubjectName.Text.Trim();

            //Modify by Andy.gui on 2011/12/27
            //Move to Subject_License_Vehicls table
            //entity.LicenseVehicls = txtLicense.Text.Trim();


            //Modify by Andy.gui on 2011/12/27
            //Add Subject_License_Vehicls table
            if (MainService.SubjectInformationService.SaveSubjectInformation(entity, SubjectAddress, SubjectOwner, Equipment, Distribution, isUpdate, LicenseVehicls))
            {
                base.AlertMessage("Save Succeed");
                //base.CloseDialogNoRefresh();
            }
            else
            {
                base.AlertMessage("Save Failure");
            }
        }
コード例 #3
0
        private void LoadData(SubjectInformationEntity entity)
        {
            //SubjectInformation 信息
            SubjectInformationID = entity.SubjectInformationId;
            txtSubjectName.Text = entity.Name;

            //Modify by Andy.Gui on 2011/12/27
            //txtLicense.Text = entity.LicenseVehicls;


            //Subject Address 
            DataSet dsSubjectAddress = MainService.SubjectAddressService.GetBySubjectInformationID(entity.SubjectInformationId);
            if (dsSubjectAddress != null && dsSubjectAddress.Tables.Count > 0 && dsSubjectAddress.Tables[0] != null)
            {
                SubjectAddress = dsSubjectAddress.Tables[0];
                BindSubjectAddress();
            }

            //SubjectOwner
            DataSet dsSubjectOwner = MainService.SubjectOwnerService.GetBySubjectInformationID(entity.SubjectInformationId);
            if (dsSubjectOwner != null && dsSubjectOwner.Tables.Count > 0 && dsSubjectOwner.Tables[0] != null)
            {
                SubjectOwner = dsSubjectOwner.Tables[0];
                BindSubjectOwner();
            }

            //Equipment 
            DataSet dsEquipment = MainService.EquipmentBLLService.Search(entity.SubjectInformationId);
            if (dsEquipment != null && dsEquipment.Tables.Count > 0 && dsEquipment.Tables[0] != null)
            {
                Equipment = dsEquipment.Tables[0];
                BindEquipment();
            }

            //Distribution 
            DataSet dsDistribution = MainService.SubjectDistributionService.GetBySubjectInformationID(entity.SubjectInformationId);
            if (dsDistribution != null && dsDistribution.Tables.Count > 0 && dsDistribution.Tables[0] != null)
            {
                Distribution = dsDistribution.Tables[0];
                BinddrDistribution();
            }


            //LicenseVehicls  Add by Andy.Gui on 2011/12/27
            DataSet dsLicenseVehicls = MainService.SubjectLicenseVehiclsService.GetBySubjectInformationID(entity.SubjectInformationId);
            if (dsLicenseVehicls != null && dsLicenseVehicls.Tables.Count > 0 && dsLicenseVehicls.Tables[0] != null)
            {
                LicenseVehicls = dsLicenseVehicls.Tables[0];
                BindLicenseVehicls();
            }

        }
コード例 #4
0
 public virtual void UpdateSubjectInformationEntity(SubjectInformationEntity entity, DataAccessBroker broker)
 {
     DataAccess.Update(entity, broker);
 }
コード例 #5
0
 public virtual void InsertSubjectInformationEntity(SubjectInformationEntity entity, DataAccessBroker broker)
 {
     DataAccess.Insert(entity, broker);
 }
コード例 #6
0
         public virtual SubjectInformationEntity GetSubjectAddressEntityByActionNo(string actionNo)
        {
            SubjectInformationEntity entity = new SubjectInformationEntity();
            entity.ActionNo = actionNo;

            return DataAccess.SelectSingle<SubjectInformationEntity>(entity);
        }
コード例 #7
0
        //public virtual List<ChkFunctionParamEntity> GetChkFunctionParasByFunctionId(string functionId)
        //{
        //    return SelectByCondition<ChkFunctionParamEntity>(adidas.DataCollection.Common.Utils.QueryCondition.Create().Equals(ChkFunctionParamTable.C_FUNCTION_ID, functionId).Order(ChkFunctionParamTable.C_SORT_ORDER));
        //}

        //public virtual void InsertChkFUnctionParas(List<ChkFunctionParamEntity> functionParas, DataAccessBroker broker)
        //{
        //    DataAccess.Insert(functionParas, broker);
        //}

        //public virtual void DeleteChkFunctionParasByCondition(ChkFunctionParamEntity param, DataAccessBroker broker)
        //{
        //    DataAccess.DeleteEntity(param, broker);
        //}


        //Modify by Andy.gui on 2011/12/27
        //Add Subject_License_Vehicls table
        public virtual bool SaveSubjectInformation(SubjectInformationEntity entity, DataTable dtSubjectAddress, DataTable dtSubjectOwner, DataTable dtEquipment, DataTable dtDistribution, bool isUpdate, DataTable dtLicenseVehicls)
        {
            //注释Update部分, 由于除SubjectInformation外其它只允许新增和删除,所以去掉Update
            using (DataAccessBroker broker = DataAccessFactory.Instance())
            {
                broker.BeginTransaction();
                try
                {
                    if (isUpdate)
                    {
                        UpdateSubjectInformationEntity(entity, broker);
                    }
                    else
                    {
                        InsertSubjectInformationEntity(entity, broker);
                    }



                    //Save SubjectAddress
                    if (dtSubjectAddress != null && dtSubjectAddress.Rows.Count > 0)
                    {
                        string strSql = @"delete " + SubjectAddressTable.C_TableName + "  where " + SubjectAddressTable.C_Subject_Information_ID + "='" + entity.SubjectInformationId + "'";
                        broker.ExecuteNonQuery(strSql, null, CommandType.Text);

                        SubjectAddressEntity objEntity;
                        foreach (DataRow drSubjectAddress in dtSubjectAddress.Rows)
                        {
                            //insert
                            objEntity = new SubjectAddressEntity();
                            objEntity.SubjectAddressId = drSubjectAddress["Subject_Address_ID"].ToString();
                            objEntity.SubjectInformationId = entity.SubjectInformationId;

                            objEntity.ProvinceId = Convert.ToInt32(drSubjectAddress["Province_ID"].ToString());
                            objEntity.Province = drSubjectAddress["Province"].ToString();
                            objEntity.CityId = Convert.ToInt32(drSubjectAddress["City_ID"].ToString());
                            objEntity.City = drSubjectAddress["City"].ToString();
                            objEntity.SubCityId = Convert.ToInt32(drSubjectAddress["Sub_City_ID"].ToString());
                            objEntity.SubCity = drSubjectAddress["Sub_City"].ToString();
                            objEntity.Town = drSubjectAddress["Town"].ToString();
                            objEntity.Street = drSubjectAddress["Street"].ToString();
                            objEntity.Doorplate = drSubjectAddress["Doorplate"].ToString();
                            objEntity.Room = drSubjectAddress["Room"].ToString();

                            DataAccess.Insert(objEntity, broker);
                        }
                    }

                    //Save dtSubjectOwner
                    if (dtSubjectOwner != null && dtSubjectOwner.Rows.Count > 0)
                    {
                        string strSql = @"delete " + SubjectOwnerTable.C_TableName + "  where " + SubjectOwnerTable.C_Subject_Information_ID + "='" + entity.SubjectInformationId + "'";
                        broker.ExecuteNonQuery(strSql, null, CommandType.Text);

                        SubjectOwnerEntity objEntity;
                        foreach (DataRow drSubjectOwner in dtSubjectOwner.Rows)
                        {
                            //insert
                            objEntity = new SubjectOwnerEntity();
                            objEntity.SubjectOwnerId = drSubjectOwner["Subject_Owner_ID"].ToString();
                            objEntity.SubjectInformationId = entity.SubjectInformationId;


                            objEntity.Name = drSubjectOwner["Name"].ToString();
                            objEntity.Id = drSubjectOwner["ID"].ToString();
                            objEntity.OriginalAddress = drSubjectOwner["Original_Address"].ToString();
                            objEntity.Description = drSubjectOwner["Description"].ToString();

                            DataAccess.Insert(objEntity, broker);
                        }

                    }

                    //Save dtEquipment
                    if (dtEquipment != null && dtEquipment.Rows.Count > 0)
                    {
                        string strSql = @"delete " + EquipmentTable.C_TableName + "  where " + EquipmentTable.C_Action_NO + "='" + entity.SubjectInformationId + "'";
                        broker.ExecuteNonQuery(strSql, null, CommandType.Text);


                        EquipmentEntity objEntity;
                        foreach (DataRow drEquipment in dtEquipment.Rows)
                        {

                            objEntity = new EquipmentEntity();
                            objEntity.EquipmentId = drEquipment["Equipment_ID"].ToString();
                            objEntity.ActionNo = entity.SubjectInformationId;

                            objEntity.EquipmentName = drEquipment["Equipment_Name"].ToString();
                            objEntity.Amount = drEquipment["Amount"].ToString();

                            DataAccess.Insert(objEntity, broker);

                        }
                    }

                    //Save dtDistribution
                    if (dtDistribution != null && dtDistribution.Rows.Count > 0)
                    {
                        string strSql = @"delete " + SubjectDistributionTable.C_TableName + "  where " + SubjectDistributionTable.C_Subject_Information_ID + "='" + entity.SubjectInformationId + "'";
                        broker.ExecuteNonQuery(strSql, null, CommandType.Text);

                        SubjectDistributionEntity objEntity;
                        foreach (DataRow drDistribution in dtDistribution.Rows)
                        {
                            objEntity = new SubjectDistributionEntity();
                            objEntity.SubjectDistributionId = drDistribution["Subject_Distribution_ID"].ToString();
                            objEntity.SubjectInformationId = entity.SubjectInformationId;

                            objEntity.DistributionType = drDistribution["Distribution_Type"].ToString();
                            objEntity.Name = drDistribution["Name"].ToString();
                            objEntity.Address = drDistribution["Address"].ToString();
                            objEntity.Phone = drDistribution["Phone"].ToString();

                            DataAccess.Insert(objEntity, broker);
                        }
                    }


                    //Save LicenseVehicls
                    //Add by Andy.Gui on 2011/12/27 dtLicenseVehicls
                    if (dtLicenseVehicls != null && dtLicenseVehicls.Rows.Count > 0)
                    {
                        string strSql = @"delete " + SubjectLicenseVehiclsTable.C_TableName + "  where " + SubjectLicenseVehiclsTable.C_Subject_Information_ID + "='" + entity.SubjectInformationId + "'";
                        broker.ExecuteNonQuery(strSql, null, CommandType.Text);

                        SubjectLicenseVehiclsEntity objEntity;
                        foreach (DataRow drLicenseVehicls in dtLicenseVehicls.Rows)
                        {
                            objEntity = new SubjectLicenseVehiclsEntity();
                            objEntity.SubjectLicenseVehiclsId = drLicenseVehicls["Subject_License_Vehicls_ID"].ToString();
                            objEntity.SubjectInformationId = entity.SubjectInformationId;

                            objEntity.LicenseVehicls = drLicenseVehicls["License_Vehicls"].ToString();

                            DataAccess.Insert(objEntity, broker);
                        }
                    }




                    broker.Commit();
                    return true;
                }
                catch
                {
                    broker.RollBack();
                    return false;
                }
            }
        }
コード例 #8
0
 public SubjectInformationDomain(SubjectInformationEntity entity)
     : base(entity)
 {
     masterEntity = entity;
 }