Exemple #1
0
        public RTN_SAVE_DATA PlaceItemGroupSeqSave(List <T_PLACE_ITEM_GROUP> list, int?REG_CODE)
        {
            RTN_SAVE_DATA rtnData = new RTN_SAVE_DATA()
            {
            };

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = string.Empty;
                    foreach (T_PLACE_ITEM_GROUP Param in list)
                    {
                        sql = Global.DBAgent.LoadCondSQL(sqlBasePath + "Advertising\\PlaceItemGroup.xml", "PlaceItemGroupSeqSave"
                                                         , Param.GROUP_CODE.ToString("")
                                                         , Param.GROUP_SEQ.ToString("")
                                                         , REG_CODE

                                                         );

                        rtnData = db.ExecuteQuery <RTN_SAVE_DATA>(sql).First();
                        if (!string.IsNullOrEmpty(rtnData.ERROR_MESSAGE))
                        {
                            throw new Exception(rtnData.ERROR_MESSAGE);
                        }
                    }
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtnData.ERROR_MESSAGE = ex.Message;
            }
            return(rtnData);
        }
Exemple #2
0
        /// <summary>
        /// T_SIGNAGE_CONTROL 저장하기
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public RTN_SAVE_DATA SignageControlPlayUpdate(T_SIGNAGE_CONTROL_UPDATE Param)
        {
            RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_SIGNAGE_CONTROL.xml", "SignageControlPlayUpdate"
                                                        , Param.IDX
                                                        , Param.PLAY_FR_TIME.ToString("")
                                                        , Param.PLAY_TO_TIME.ToString("")
                                                        , Param.UPDATE_CODE.ToString("0")

                                                        );
                    rtn.DATA = db.ExecuteQuery <string>(sql).First();
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtn.ERROR_MESSAGE = ex.Message;
            }
            return(rtn);
        }
Exemple #3
0
        public RTN_SAVE_DATA Step5Save(STEP5_SAVE Param)
        {
            object        obj     = Param;
            RTN_SAVE_DATA rtnData = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\RequestADStep.xml", "Step5Save"

                                                        , Param.AD_CODE.ToString("0")
                                                        , Param.REG_CODE.ToString("0")

                                                        );
                    db.ExecuteCommand(sql);
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtnData.ERROR_MESSAGE = ex.Message;
            }

            return(rtnData);
        }
        /// <summary>
        /// 웹메뉴그룹 등록
        /// </summary>
        /// <param name="list"></param>
        /// <param name="REG_CODE"></param>
        /// <returns></returns>
        public RTN_SAVE_DATA groupMemberSave(GROUP_MEMBER_SAVE Param)
        {
            RTN_SAVE_DATA rtnData = new RTN_SAVE_DATA();
            StringBuilder sbSql   = new StringBuilder();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Common\\T_STORE_WEBMENU_GROUP_MENU.xml", "groupMemberSave"
                                                        , Param.PROJECT_SITE.ToString()
                                                        , Param.STORE_CODE.ToString("1")
                                                        , Param.GROUP_CODE.ToString("")
                                                        , Param.MEMBER_CODES.ToString("-1")
                                                        , Param.REG_CODE.ToString()

                                                        );

                    db.ExecuteCommand(sql);

                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtnData.ERROR_MESSAGE = ex.Message;
            }

            return(rtnData);
        }
        /// <summary>
        /// 사용자정보 저장하기
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public RTN_SAVE_DATA ReqPasswordChange(T_MEMBER Param)
        {
            RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER.xml", "ReqPasswordChange"
                                                        , Param.USER_ID.ToString("-1")
                                                        , Param.PASSWORD_CHANGE_URL.ToString("")

                                                        );

                    rtn.DATA = db.ExecuteQuery <DateTime>(sql).First().ToString("yyyy-MM-dd HH:mm:ss");

                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtn.ERROR_MESSAGE = ex.Message;
            }
            return(rtn);
        }
        /// <summary>
        /// 사용자정보 저장하기
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public RTN_SAVE_DATA PasswordChangeSave(T_MEMBER Param)
        {
            RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER.xml", "PasswordChangeSave"
                                                        , Param.USER_ID.ToString("")
                                                        , Param.PASSWORD.ToString("")


                                                        );

                    db.ExecuteCommand(sql);
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtn.ERROR_MESSAGE = ex.Message;
            }
            return(rtn);
        }
        public RTN_SAVE_DATA CategoryKeywordSave(CATEGORY_KEYWORD_SAVE Param)
        {
            RTN_SAVE_DATA rtnData = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = string.Empty;

                    sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\CategoryKeyword.xml"
                                                 , "CategoryKeywordSave"
                                                 , Param.CATEGORY_CODE.ToString()
                                                 , Param.KEYWORD_CODES.ToString("")
                                                 , Param.REG_CODE.ToString()
                                                 );
                    rtnData = db.ExecuteQuery <RTN_SAVE_DATA>(sql).First();
                    if (!string.IsNullOrEmpty(rtnData.ERROR_MESSAGE))
                    {
                        throw new Exception(rtnData.ERROR_MESSAGE);
                    }


                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtnData.ERROR_MESSAGE = ex.Message;
            }

            return(rtnData);
        }
        public RTN_SAVE_DATA SaveLog(T_LOG Param)
        {
            RTN_SAVE_DATA rtnData = new RTN_SAVE_DATA();
            StringBuilder sbSql   = new StringBuilder();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Common\\T_LOG.xml", "LogSave"
                                                        , Param.IDX.ToString()
                                                        , Param.STORE_CODE.ToString()
                                                        , Param.LOG_DATE.ToString("")
                                                        , Param.LOG_TYPE.ToString("")
                                                        , Param.LOG_DATA1.ToString("")
                                                        , Param.LOG_DATA2.ToString("")
                                                        , Param.LOG_DATA3.ToString("")
                                                        , Param.LOG_DESC.ToString("")
                                                        , Param.USE_IP.ToString("")
                                                        , Param.LOG_TABLE.ToString("")
                                                        , Param.INSERT_CODE.ToString()
                                                        );

                    db.ExecuteCommand(sql);

                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtnData.ERROR_MESSAGE = ex.Message;
            }

            return(rtnData);
        }
Exemple #9
0
        public RTN_SAVE_DATA MemberSnsIDUpdate(T_MEMBER_SNS_UPDATE Param)
        {
            RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Account\\MEMBER.xml", "MemberSnsIDUpdate"
                                                        , Param.USER_ID
                                                        , Param.PASSWORD
                                                        , Param.SNS_TYPE.ToString("1")
                                                        , Param.KAKAO_ID.ToString("1")
                                                        , Param.GOOGLE_ID.ToString("")
                                                        , Param.NAVER_ID.ToString("")
                                                        , Param.FACEBOOK_ID.ToString("")
                                                        , Param.UPDATE_CODE.ToString("0")

                                                        );
                    rtn = db.ExecuteQuery <RTN_SAVE_DATA>(sql).FirstOrDefault();
                    if (!string.IsNullOrEmpty(rtn.ERROR_MESSAGE))
                    {
                        throw new Exception(rtn.ERROR_MESSAGE);
                    }
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtn.ERROR_MESSAGE = ex.Message;
            }
            return(rtn);
        }
Exemple #10
0
        /// <summary>
        /// T_MEMBER_BOOKMARK 북마크 저장하기
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public RTN_SAVE_DATA MemberPasswordChange(T_MEMBER_PASSWROD_CHANGE Param)
        {
            RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Account\\Member.xml", "MemberPasswordChange"
                                                        , Param.USER_ID.ToString("")
                                                        , Param.PASSWORD.ToString("")
                                                        , Param.UPDATE_CODE.ToString("0")
                                                        );
                    rtn = db.ExecuteQuery <RTN_SAVE_DATA>(sql).FirstOrDefault();
                    if (!string.IsNullOrEmpty(rtn.ERROR_MESSAGE))
                    {
                        throw new Exception(rtn.ERROR_MESSAGE);
                    }
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtn.ERROR_MESSAGE = ex.Message;
            }
            return(rtn);
        }
        /// <summary>
        /// 직급/직책 삭제
        /// </summary>
        /// <param name="list"></param>
        /// <returns></returns>
        public RTN_SAVE_DATA PositionDelete(List <T_STORE_DEPT> list)
        {
            RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    foreach (T_STORE_DEPT data in list)
                    {
                        string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Basic\\T_STORE_POSITION.xml", "PositionDelete"
                                                            , data.STORE_CODE.ToString("0")
                                                            , data.DEPT_CODE.ToString("0")
                                                            , data.INSERT_CODE
                                                            );
                        db.ExecuteCommand(sql);
                    }
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtn.ERROR_MESSAGE = ex.Message;
            }

            return(rtn);
        }
Exemple #12
0
        /// <summary>
        /// T_SIGNAGE_CONTROL 저장하기
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public RTN_SAVE_DATA SignageControlSave(T_SIGNAGE_CONTROL Param)
        {
            RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_SIGNAGE_CONTROL.xml", "SignageControlSave"
                                                        , Param.IDX.ToString()
                                                        , Param.SIGN_CODE.ToString("")
                                                        , Param.PLAY_TYPE.ToString("")
                                                        , Param.PLAY_REQ_TIME.ToDefaultDateString()
                                                        , Param.PLAY_FR_TIME.ToDefaultDateString()
                                                        , Param.PLAY_TO_TIME.ToDefaultDateString()
                                                        , Param.CONTENT_URL.ToString("")
                                                        , Param.CONTENT.ToString("")
                                                        , Param.REQUEST_NAME.ToString("")
                                                        , Param.REQUEST_EMAIL.ToString("")
                                                        , Param.COMPLEATED_DATE.ToDefaultDateString()
                                                        , Param.HIDE.ToBooleanString("0")
                                                        , Param.INSERT_CODE.ToString("0")

                                                        );
                    rtn.DATA = db.ExecuteQuery <string>(sql).First();
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtn.ERROR_MESSAGE = ex.Message;
            }
            return(rtn);
        }
Exemple #13
0
        public RTN_SAVE_DATA Step4Save(STEP4_SAVE Param)
        {
            object        obj     = Param;
            RTN_SAVE_DATA rtnData = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    string deviceCodes = Param.DEVICE_CODE.FromArrayToString();
                    deviceCodes = string.IsNullOrEmpty(deviceCodes) ? "0" : deviceCodes;
                    string adDeviceCodes = Param.AD_DEVICE_CODE.FromArrayToString();
                    adDeviceCodes = string.IsNullOrEmpty(adDeviceCodes) ? "0" : adDeviceCodes;

                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\RequestADStep.xml", "Step4Save"
                                                        , Param.SAVE_TYPE.ToString("")
                                                        , Param.AD_CODE.ToString("0")
                                                        , deviceCodes
                                                        , adDeviceCodes
                                                        , Param.TIMEZONE_OFFSET.ToString("9")
                                                        , Param.REG_CODE.ToString("0")

                                                        );
                    db.ExecuteCommand(sql);
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtnData.ERROR_MESSAGE = ex.Message;
            }

            return(rtnData);
        }
        public RTN_SAVE_DATA MemberModify(T_MEMBER Param, T_STORE Param2)
        {
            RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    if (Param.SHARE_AUTH_NUMBER.ToString("").Length != 2)
                    {
                        Param.SHARE_AUTH_NUMBER = "00";
                    }


                    string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER.xml", "MemberSave"
                                                        , Param.MEMBER_CODE.ToString("-1")
                                                        , Param.USER_TYPE.ToString("5")
                                                        , Param.USER_ID.ToString("")
                                                        , Param.PASSWORD.ToString("")
                                                        , Param.USER_NAME.ToString("")
                                                        , Param.EMAIL.ToString("")
                                                        , Param.PHONE.ToString("")
                                                        , Param.MOBILE.ToString("")
                                                        , Param.ADDRESS1.ToString("")
                                                        , Param.ADDRESS2.ToString("")
                                                        , Param.ZIP_CODE.ToString("")
                                                        , Param.BIRTH.ToString("")
                                                        , Param.GENDER.ToString("1")
                                                        , Param.REMARK.ToString("")
                                                        , Param.PASSWORD_CHANGE_URL.ToString("")
                                                        , Param.SHARE_AUTH_NUMBER.ToString("")
                                                        , Convert.ToDateTime(Param.PASSWORD_AUTH_TIME.ToString("1901-01-01")).ToString("yyyy-MM-dd HH:mm:ss.fff")
                                                        , Param.HIDE == true ? "1" : "0"
                                                        , Param.INSERT_CODE.ToString()     /*Admin*/
                                                        );
                    var rtn2 = db.ExecuteQuery <int>(sql);
                    rtn.DATA = Convert.ToString(rtn2.First());


                    sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER_EMPLOYEE.xml", "MemberModifySave"

                                                 , Param2.COMPANY_CODE.ToString("")
                                                 , Param2.STORE_CODE.ToString("")
                                                 , Param2.COMPANY_TYPE2.ToString("7")
                                                 , Param2.BUSI_REG_NUMBER.ToString("")
                                                 , Param.INSERT_CODE.ToString()
                                                 );

                    db.ExecuteCommand(sql);
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtn.ERROR_MESSAGE = ex.Message;
            }

            return(rtn);
        }
Exemple #15
0
        public JsonResult RelativeDeviceSave(T_DEVICE Param)
        {
            RTN_SAVE_DATA data = Service.deviceService.RelativeDeviceSave(Param);

            return(new JsonResult {
                Data = data
            });
        }
        public JsonResult loggalBoxAuthReg(T_DEVICE_COND param)
        {
            RTN_SAVE_DATA data = Service.deviceService.loggalBoxAuthReg(param, SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);

            return(new JsonResult {
                Data = data
            });
        }
        public JsonResult RelativeDeviceDelete(List <T_DEVICE> list, long?RELATIVE_DEVICE_CODE)
        {
            RTN_SAVE_DATA data = Service.deviceService.RelativeDeviceDelete(list, RELATIVE_DEVICE_CODE);

            return(new JsonResult {
                Data = data
            });
        }
Exemple #18
0
        public JsonResult InitVirtualDevice(T_DEVICE Param)
        {
            RTN_SAVE_DATA data = Service.deviceService.InitVirtualDevice(Param, SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);

            return(new JsonResult {
                Data = data
            });
        }
        public JsonResult DeviceRegionSave(List <DEVICE_REGION> list)
        {
            RTN_SAVE_DATA data = Service.deviceService.DeviceRegionSave(list, SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);

            return(new JsonResult {
                Data = data
            });
        }
        public JsonResult DeviceMainSave(T_DEVICE_MAIN param)
        {
            RTN_SAVE_DATA data = Service.deviceService.DeviceMainSave(param, SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);

            return(new JsonResult {
                Data = data
            });
        }
Exemple #21
0
        public JsonResult AddVirtulaDevice(T_DEVICE Param)
        {
            RTN_SAVE_DATA data = Service.deviceService.AddVirtulaDevice(Param);

            return(new JsonResult {
                Data = data
            });
        }
        public JsonResult DeviceRegionAutoSave(CODE_DATA Cond)
        {
            RTN_SAVE_DATA data = Service.deviceService.DeviceRegionAutoSave(Cond, SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);

            return(new JsonResult {
                Data = data
            });
        }
        public JsonResult DeviceMainDelete(T_DEVICE_MAIN param)
        {
            param.UPDATE_CODE = (int)SessionHelper.LoginInfo.MEMBER.MEMBER_CODE;
            RTN_SAVE_DATA data = Service.deviceService.DeviceMainDelete(param);

            return(new JsonResult {
                Data = data
            });
        }
        public RTN_SAVE_DATA CommonSave(List <T_COMMON> list, int?REG_CODE)
        {
            RTN_SAVE_DATA rtnData = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    foreach (T_COMMON data in list)
                    {
                        if (data.MRC_EDIT_MODE != "D")
                        {
                            string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Common\\Common.xml", "CommonSave"
                                                                , data.IDX.ToString("0")
                                                                , data.MAIN_CODE.ToString("")
                                                                , data.SUB_CODE.ToString("")
                                                                , data.NAME.ToString("")
                                                                , data.LANGUAGE_CODE.ToString("")
                                                                , data.ORDER_SEQ.ToString("")
                                                                , data.REF_DATA1.ToString("")
                                                                , data.REF_DATA2.ToString("")
                                                                , data.REF_DATA3.ToString("")
                                                                , data.REF_DATA4.ToString("")
                                                                , (data.HIDE == null || data.HIDE == false ? "0" : "1")
                                                                , REG_CODE.ToString()
                                                                );

                            rtnData = db.ExecuteQuery <RTN_SAVE_DATA>(sql).First();

                            if (!string.IsNullOrEmpty(rtnData.ERROR_MESSAGE))
                            {
                                throw new Exception(rtnData.ERROR_MESSAGE);
                            }
                        }
                        else
                        {
                            string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Common\\Common.xml", "CommonDelete"
                                                                , data.IDX.ToString("0")
                                                                );

                            rtnData = db.ExecuteQuery <RTN_SAVE_DATA>(sql).First();
                            if (!string.IsNullOrEmpty(rtnData.ERROR_MESSAGE))
                            {
                                throw new Exception(rtnData.ERROR_MESSAGE);
                            }
                        }
                    }
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtnData.ERROR_MESSAGE = ex.Message;
            }

            return(rtnData);
        }
        /// <summary>
        /// T_KEYWORD 저장하기
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public RTN_SAVE_DATA T_KEYWORD_Save(List <T_KEYWORD> list, int?REG_CODE)
        {
            RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();

            try
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    foreach (T_KEYWORD Param in list)
                    {
                        if (Param.MRC_EDIT_MODE != "D")
                        {
                            string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\Keyword.xml", "T_KEYWORD_Save"
                                                                , Param.KEYWORD_CODE.ToString("-1")
                                                                , Param.KEYWORD_TYPE.ToString("")
                                                                , Param.BASE_CODE.ToString()
                                                                , Param.IS_SYNONYM.ToString()
                                                                , Param.SEQ.ToString()
                                                                , Param.KEYWORD_NAME.ToString()
                                                                , Param.KEYWORD_DESC.ToString("")
                                                                , Param.LATITUDE.ToString("")
                                                                , Param.LONGITUDE.ToString("")
                                                                , Param.CHOSUNG.ToString("")
                                                                , Param.JUNGSUNG.ToString("")
                                                                , Param.JONGSUNG.ToString("")
                                                                , Param.KEYWORD_UNITS.ToString("")
                                                                , Param.STATUS.ToString("")
                                                                , Param.REMARK.ToString("")
                                                                , Param.SEARCH_CNT.ToString()
                                                                , Param.HIDE.ToString()
                                                                , REG_CODE.ToString()

                                                                );
                            rtn = db.ExecuteQuery <RTN_SAVE_DATA>(sql).First();
                        }
                        else
                        {
                            string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\Keyword.xml", "T_KEYWORD_Delete"
                                                                , Param.KEYWORD_CODE.ToString("-1")

                                                                );
                            rtn = db.ExecuteQuery <RTN_SAVE_DATA>(sql).First();
                        }
                        if (!string.IsNullOrEmpty(rtn.ERROR_MESSAGE))
                        {
                            throw new Exception(rtn.ERROR_MESSAGE);
                        }
                    }
                    tran.Complete();
                }
            }
            catch (Exception ex)
            {
                rtn.ERROR_MESSAGE = ex.Message;
            }
            return(rtn);
        }
        public JsonResult CommonSave(List <T_COMMON> list)
        {
            int?          REG_CODE = (int)SessionHelper.LoginInfo.MEMBER.MEMBER_CODE;
            RTN_SAVE_DATA data     = Service.commoneService.CommonSave(list, REG_CODE);

            return(new JsonResult {
                Data = data
            });
        }
        public RTN_SAVE_DATA CompanySave_Exec(T_COMPANY Param, DataContext db1 = null)
        {
            if (db1 == null)
            {
                db1 = db;
            }
            RTN_SAVE_DATA rtnData = new RTN_SAVE_DATA()
            {
            };

            if (!(string.IsNullOrEmpty(Param.PASSWORD) || Param.PASSWORD == "******"))
            {
                Param.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
            }

            if (Param.SAVE_TYPE != "D")
            {
                string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Basic\\T_COMPANY.xml", "CompanySave"
                                                    , Param.COMPANY_CODE.ToString("-1")
                                                    , Param.COMPANY_ID.ToString("")
                                                    , Param.PASSWORD.ToString("")
                                                    , Param.COMPANY_NAME.ToString("")
                                                    , Param.COMPANY_TYPE.ToString("")
                                                    , Param.COMPANY_TYPE2.ToString("")
                                                    , Param.PHONE.ToString("")
                                                    , Param.MOBILE.ToString("")
                                                    , Param.EMAIL.ToString("")
                                                    , Param.ADDRESS1.ToString("")
                                                    , Param.ADDRESS2.ToString("")
                                                    , Param.ZIP_CODE.ToString("")
                                                    , Param.LATITUDE.ToString("")
                                                    , Param.LONGITUDE.ToString("")
                                                    , Param.OWNER_NAME.ToString("")
                                                    , Param.OWNER_PHONE.ToString("")
                                                    , Param.OWNER_MOBILE.ToString("")
                                                    , Param.OWNER_EMAIL.ToString("")
                                                    , (Param.STORE_SYNC == null || Param.STORE_SYNC == false) ? "0" : "1"
                                                    , Param.STATUS.ToString("9")
                                                    , Param.CULTURE_NAME.ToString("ko-KR")
                                                    , Param.THEME_NAME.ToString("SPICYX")
                                                    , Param.REMARK.ToString("")
                                                    , Param.INSERT_CODE.ToString("0")

                                                    );
                rtnData = db1.ExecuteQuery <RTN_SAVE_DATA>(sql).First();
            }
            else
            {
                string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Basic\\T_COMPANY.xml", "CompanyDelete"
                                                    , Param.COMPANY_CODE.ToString("-1")
                                                    , Param.INSERT_CODE
                                                    );
                rtnData = db1.ExecuteQuery <RTN_SAVE_DATA>(sql).First();
            }

            return(rtnData);
        }
        public JsonResult GetSession(string name)
        {
            RTN_SAVE_DATA data = new RTN_SAVE_DATA();

            data.DATA = JsonConvert.SerializeObject(Session[name]);
            return(new JsonResult {
                Data = data
            });
        }
        public JsonResult DeviceSave(List <T_DEVICE> list)
        {
            SessionHelper.LOG_NAME = "기기저장";
            RTN_SAVE_DATA data = Service.deviceService.DeviceSave(list, SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);

            return(new JsonResult {
                Data = data
            });
        }
Exemple #30
0
        public JsonResult MemberModifySave(T_MEMBER Param, T_STORE Param2)
        {
            if (Param2 == null || Param2.STORE_CODE == null)
            {
                Param2 = new T_STORE {
                    COMPANY_TYPE2     = SessionHelper.LoginInfo.STORE.COMPANY_TYPE2
                    , BUSI_REG_NUMBER = ""
                }
            }
            ;

            Param2.COMPANY_CODE = Param2.COMPANY_CODE;
            Param2.STORE_CODE   = Param2.STORE_CODE;

            string msg = string.Empty;

            //Param.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
            Param.BIRTH = Param.BIRTH.RemoveDateString();

            T_MEMBER memData = new AccountService().GetMemberList(new T_MEMBER_COND {
                USER_ID = Param.USER_ID
            }).FirstOrDefault();
            RTN_SAVE_DATA data = new RTN_SAVE_DATA();

            if (Param.PASSWORD != "******")
            {
                if (!string.IsNullOrEmpty(Param.PASSWORD))
                {
                    memData.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
                }
            }
            memData.BIRTH       = Param.BIRTH;
            memData.USER_NAME   = Param.USER_NAME;
            memData.ZIP_CODE    = Param.ZIP_CODE;
            memData.ADDRESS1    = Param.ADDRESS1;
            memData.ADDRESS2    = Param.ADDRESS2;
            memData.PHONE       = Param.PHONE;
            memData.GENDER      = Param.GENDER;
            memData.INSERT_CODE = (int)(SessionHelper.LoginInfo.MEMBER == null ? 0 : SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);
            ///memData.MEMBER_CODE = (int)(SessionHelper.LoginInfo.MEMBER == null ? 0 : SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);


            data = new AccountService().MemberModify(memData, Param2);

            data.RETURN_URL = "/";

            memData = new AccountService().GetMemberList(new T_MEMBER_COND {
                USER_ID = Param.USER_ID
            }).FirstOrDefault();
            // SessionHelper.LoginInfo.STORE = new ALT.BizService.BasicService().GetStoreList(new T_STORE_COND { STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE }).First();
            // SessionHelper.LoginInfo.MEMBER = memData;

            return(new JsonResult {
                Data = data
            });
        }