Example #1
0
        /// <summary>
        /// 新增排班计划班次数据。
        /// </summary>
        /// <param name="dsParams">包含排班计划班次数据的数据集对象。</param>
        /// <returns>包含执行结果的数据集对象。</returns>
        public DataSet AddShift(DataSet dsParams)
        {
            DataSet       dsReturn   = new DataSet();
            DbConnection  dbConn     = null;
            DbTransaction dbTran     = null;
            string        sqlCommand = "";

            if (null != dsParams && dsParams.Tables.Contains(CAL_SHIFT.DATABASE_TABLE_NAME))
            {
                try
                {
                    dbConn = db.CreateConnection();
                    dbConn.Open();
                    //Create Transaction
                    dbTran = dbConn.BeginTransaction();
                    DataTable dtParams = dsParams.Tables[CAL_SHIFT.DATABASE_TABLE_NAME];
                    //创建cal_shift对应的对象
                    CAL_SHIFT shiftFields = new CAL_SHIFT();
                    string    shiftKey    = dtParams.Rows[0][CAL_SHIFT.FIELD_SHIFT_KEY].ToString();
                    string    scheduleKey = dtParams.Rows[0][CAL_SCHEDULE.FIELD_SCHEDULE_KEY].ToString();
                    sqlCommand = DatabaseTable.BuildInsertSqlStatement(shiftFields, dtParams, 0,
                                                                       new Dictionary <string, string>()
                    {
                        { CAL_SHIFT.FIELD_CREATE_TIME, null },
                        { CAL_SHIFT.FIELD_EDIT_TIME, null }
                    },
                                                                       new List <string>()
                    {
                        CAL_SCHEDULE.FIELD_SCHEDULE_KEY
                    }
                                                                       );
                    db.ExecuteNonQuery(dbTran, CommandType.Text, sqlCommand);

                    sqlCommand = string.Format(@"INSERT INTO CAL_SCHEDULE_SHIFT(SCHEDULE_KEY,SHIFT_KEY) 
                                                VALUES('{0}','{1}')",
                                               scheduleKey.PreventSQLInjection(),
                                               shiftKey.PreventSQLInjection());
                    db.ExecuteNonQuery(dbTran, CommandType.Text, sqlCommand);
                    dbTran.Commit();
                }
                catch (Exception ex)
                {
                    dbTran.Rollback();
                    FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
                    LogService.LogError("AddShift Error: " + ex.Message);
                }
                finally
                {
                    dbTran.Dispose();
                    dbConn.Close();
                    dbConn.Dispose();
                }
            }
            else
            {
                FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, "${res:FanHai.Hemera.Modules.EMS.CalShiftEngine.TableIsNotExist}");
            }
            return(dsReturn);
        }
Example #2
0
        public override bool Insert()
        {
            DataSet   dataSet    = new DataSet();
            DataTable shiftTable = CAL_SHIFT.CreateDataTable();
            //准备插入到数据库中的数据。 modi by chao.pang
            Dictionary <string, string> dataRow = new Dictionary <string, string>()
            {
                { CAL_SHIFT.FIELD_SHIFT_KEY, _shiftKey },
                { CAL_SHIFT.FIELD_SHIFT_NAME, _shiftName },
                { CAL_SHIFT.FIELD_DESCRIPTIONS, _descriptions },
                { CAL_SHIFT.FIELD_START_TIME, _starTime },
                { CAL_SHIFT.FIELD_END_TIME, _endTime },
                { CAL_SHIFT.FIELD_OVER_DAY, _overDay },
                { CAL_SHIFT.FIELD_CREATOR, Creator },
                { CAL_SHIFT.FIELD_CREATE_TIMEZONE, CreateTimeZone },
                { CAL_SHIFT.FIELD_EDITOR, Creator },
                { CAL_SHIFT.FIELD_EDIT_TIMEZONE, CreateTimeZone },
                { CAL_SCHEDULE.FIELD_SCHEDULE_KEY, _scheduleKey }
            };

            FanHai.Hemera.Utils.Common.Utils.AddRowDataToDataTable(ref shiftTable, dataRow);
            //为远程调用函数准备参数。 modi by chao.Pang
            dataSet.Tables.Add(shiftTable);
            try
            {
                DataSet           dsReturn      = null;
                IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject();
                if (null != serverFactory)
                {
                    //远程调用进行添加操作 modi by chao.pang
                    dsReturn  = serverFactory.CreateIShift().AddShift(dataSet);
                    _errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
                    if (_errorMsg != "")
                    {
                        return(false);
                    }
                    else
                    {
                        this.ResetDirtyList();
                    }
                }
            }
            catch (Exception ex)
            {
                _errorMsg = ex.Message;
            }
            finally
            {
                CallRemotingService.UnregisterChannel();
            }
            return(true);
        }