Ejemplo n.º 1
0
        public MemberMaster SignUp(RegisterViewModel model)
        {
            if (IsValid(model.UserName, model.Password))
            {
                return(null);
            }

            var member = new MemberMaster
            {
                Email_Login  = model.UserName,
                Password     = model.Password,
                MemberRoleId = model.RoleId
            };
            {
                member.RegisteredDate        = DateTime.Now;
                member.RegisteredIP          = UtilHelper.GetVisitorIPAddress();
                member.ActivationCode        = Crypto.HashPassword(model.Password);
                member.ActivationCodeExpired = DateTime.Now.AddDays(AppSettingsHelper.GetValue <int>(AppSettings.KEYS.ACCOUNT_ACTIVATION_EXPIRED_DAYS));

                _repository.Insert(member);

                return(member);
            }
        }
Ejemplo n.º 2
0
        protected void Page_Load(object sender, System.EventArgs e)
        {
            iconIBN.Attributes.Add("href", ResolveUrl("~/portal.ico"));

            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/windows.css");
            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/Theme.css");

            if (!PortalConfig.SystemIsActive)
            {
                lblText.InnerHtml = String.Format(CHelper.GetResFileString(GlobalResourceManager.Strings["BottomsTextResourceKey"]), Mediachase.Ibn.IbnConst.FullVersion);
            }
            else
            {
                if (!IsPostBack)
                {
                    if (Request["sid"] != null)
                    {
                        ProcessSid();
                    }
                    else if (Request["outlookticketid"] != null)
                    {
                        ProcessOutlook();
                    }
                    else if (Request["login"] != null && Request["password"] != null)
                    {
                        ProcessLogin();
                    }
                    else if (Request.IsAuthenticated)
                    {
                        ProcessRedirect();
                    }
                }

                Response.Redirect("Public/default.aspx", true);
            }
        }
Ejemplo n.º 3
0
        private void RegisterScripts()
        {
            // Styles
            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/windows.css");
            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/Theme.css");
            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/ibn.css");
            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/mcCalendClient.css");
            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/mcBlockMenu.css");
            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/menuStyle.css");

            // Scripts
            UtilHelper.RegisterScript(Page, "~/Scripts/IbnFramework/JsDebug.js");
            UtilHelper.RegisterScript(Page, "~/Scripts/browser.js");
            UtilHelper.RegisterScript(Page, "~/Scripts/buttons.js");
            UtilHelper.RegisterScript(Page, "~/Scripts/common.js");
            UtilHelper.RegisterScript(Page, "~/Scripts/toptabsnew.js");

            if (loadExtJs)
            {
                CHelper.LoadExtJSGridScriptsToHead(Page);
            }

            CommonHelper.RegisterLocationScript(Page, sTitle);
        }
Ejemplo n.º 4
0
        public static List <string> PrepSqlUpdateFields <T>(T model, List <string> fields = null, List <string> skipFields = null) where T : new()
        {
            // En el update no podemos modificar el campo 'createdDate'
            if (fields.Contains("createdDate"))
            {
                fields.Remove("createdDate");
            }

            List <string> sql = new List <string>();
            List <KeyValuePair <string, string> > list = SqlFields(model, fields, skipFields);
            List <string> keys     = new List <string>();
            string        sqlField = null;

            foreach (KeyValuePair <string, string> obj in list)
            {
                keys.Add(obj.Key);

                sqlField = " [" + obj.Key + "] = " + obj.Value;
                sql.Add(sqlField);
            }

            if (fields == null || fields.Count == 0)
            {
                fields = UtilHelper.GetClassProperties(model);
            }

            string temp = "modifiedDate";

            if (fields.Contains(temp) && !keys.Contains(temp))
            {
                sqlField = " [" + temp + "] = [dbo].[Fn.TimeStamp.GetTimeStampDate]()";
                sql.Add(sqlField);
            }

            return(sql);
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 模拟达达
        /// </summary>
        /// <param name="orderCode"></param>
        /// <param name="url"></param>
        /// <returns></returns>
        private async Task <string> DadaSimulation(string orderCode, string url, string msg = null)
        {
            var appData = HttpContext.RequestServices.GetService <AppData>();
            var trans   = new DadaTrans {
                Timestamp = UtilHelper.ConvertDateTimeToInt(DateTime.Now)
            };

            trans.App_key    = appData.DadaAppKey;
            trans.App_secret = appData.DadaAppSecret;
            trans.Source_id  = appData.DadaSourceId;
            trans.Body       = JsonConvert.SerializeObject(new { order_id = orderCode, reason = msg });
            trans.Generator();
            using (var hc = new HttpClient())
            {
                var p = JsonConvert.SerializeObject(trans, new JsonSerializerSettings {
                    ContractResolver = new CamelCasePropertyNamesContractResolver()
                });
                var body = new StringContent(p);
                body.Headers.ContentType = new MediaTypeHeaderValue("application/json");
                var result = await hc.PostAsync(appData.DadaDomain + url, body);

                return(await result.Content.ReadAsStringAsync());
            }
        }
Ejemplo n.º 6
0
        /// <summary>
        /// 根据线上仓名称查询可用线上仓信息。
        /// </summary>
        /// <param name="storeName">线上仓名称,使用逗号(,)分隔。</param>
        /// <returns>包含重工线上仓信息的数据集对象。</returns>
        public DataSet GetReworkStore(string storeName)
        {
            DataSet dsReturn   = new DataSet();
            string  sqlCommand = string.Empty;

            try
            {
                sqlCommand = @"SELECT A.STORE_KEY,A.STORE_NAME,A.STORE_TYPE FROM WST_STORE A  WHERE 1=1 AND A.OBJECT_STATUS='1' ";
                if (!string.IsNullOrEmpty(storeName))
                {
                    sqlCommand = sqlCommand + UtilHelper.BuilderWhereConditionString("A.STORE_NAME", storeName.Split(','));
                }
                sqlCommand = sqlCommand + " ORDER BY STORE_NAME";
                dsReturn   = db.ExecuteDataSet(CommandType.Text, sqlCommand);
                dsReturn.Tables[0].TableName = WST_STORE_FIELDS.DATABASE_TABLE_NAME;
                FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, "");
            }
            catch (Exception ex)
            {
                FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
                LogService.LogError("GetReworkStroe Error: " + ex.Message);
            }
            return(dsReturn);
        }
        private void CheckUpdate()
        {
            CheckUpdateLoading = true;

            HttpHelper.GetAsync(new RequestGetModel <AppInfoModel>
            {
                Path  = "/api/v1/sgw2/info",
                Query = new Dictionary <string, string>
                {
                    { "version", Assembly.GetExecutingAssembly().GetName().Version.ToString() },
                },
                SuccessCallback = (res) =>
                {
                    var appInfo      = res.result;
                    LatestVersion    = appInfo.version;
                    LatestVersionSrc = appInfo.setupSrc;

                    if (UtilHelper.GetVersionWeight(LatestVersion) <= UtilHelper.GetVersionWeight(Version))
                    {
                        CheckUpdateText = "当前是最新版本";
                    }
                },
                ErrorCallback = ex =>
                {
                    CheckUpdateText = "请求出错";
                },
                CompleteCallback = () =>
                {
                    new Thread(() =>
                    {
                        Thread.Sleep(UtilHelper.GetRandomNumber(1000, 2000));
                        CheckUpdateLoading = false;
                    }).Start();
                }
            });
        }
Ejemplo n.º 8
0
        public IActionResult PutGrantPhone([FromBody] dynamic data)
        {
            var encrytedData = data.encrytedData.ToString();
            var iv           = data.iv.ToString();
            var skey         = int.Parse(Request.Headers["X-WX-Skey"]);
            var session      = Service.Set <SessionData>().Find(skey);
            var sessionKey   = session.SessionKey;
            var phoneMsg     = UtilHelper.AESDecrypt(encrytedData, sessionKey, iv);
            var phone        = JsonConvert.DeserializeObject <WxPhone>(phoneMsg);

            if (string.IsNullOrEmpty(phone.PurePhoneNumber))
            {
                return(Ok(new WxRetInfo
                {
                    Code = -1,
                    Message = "微信未绑定手机号"
                }));
            }
            Service.GrantPhone(session.UserId, phone.PurePhoneNumber);
            return(Ok(new WxRetInfo
            {
                Data = phone.PurePhoneNumber
            }));
        }
Ejemplo n.º 9
0
        private void PreparePage()
        {
            fckEditor.Language      = Security.CurrentUser.Culture;
            fckEditor.EnableSsl     = Request.IsSecureConnection;
            fckEditor.SslUrl        = ResolveUrl("~/Common/Empty.html");
            fckEditor.DesignModeCss = UtilHelper.ResolveUrl(Page, "~/Styles/IbnFramework/windows.css");

            if (ArticleId > 0)
            {
                secHeader.Title = LocRM.GetString("tArticleEdit");
            }
            else
            {
                secHeader.Title = LocRM.GetString("tArticleNew");
            }

            btnSave.Text   = LocRM2.GetString("Save");
            btnCancel.Text = LocRM2.GetString("Cancel");

            btnCancel.Attributes.Add("onclick", "DisableButtons(this);");
            btnSave.Attributes.Add("onclick", "DisableButtons(this);");
            btnSave.CustomImage = Page.ResolveUrl("~/Layouts/Images/saveitem.gif");
            secHeader.AddImageLink(Page.ResolveUrl("~/Layouts/Images/cancel.gif"), LocRM.GetString("atclBackToList"), Page.ResolveUrl("~/Apps/HelpDeskManagement/Pages/ArticleListMain.aspx"));
        }
Ejemplo n.º 10
0
        /// <summary>
        /// Returns formatted string back
        /// </summary>
        /// <param name="date"></param>
        /// <returns></returns>
        public static string FormatDateTime(DateTime date)
        {
            string   formatted  = "";
            DateTime userUtcNow = GetUserDateTimeNow();
            DateTime userDate   = GetUserDateTime(date);

            // make Today and Yesterday bold
            if ((userDate.DayOfYear == userUtcNow.DayOfYear) && (userDate.Year == userUtcNow.Year))
            {
                formatted  = "<b>" + UtilHelper.GetResFileString("{SharedStrings:Today}") + "</b>, ";
                formatted += userDate.ToString("t");
            }
            else if ((userDate.DayOfYear == (userUtcNow.DayOfYear - 1)) && (userDate.Year == userUtcNow.Year))
            {
                formatted  = "<b>" + UtilHelper.GetResFileString("{SharedStrings:Yesterday}") + "</b>, ";
                formatted += userDate.ToString("t");
            }
            else
            {
                formatted = userDate.ToString();
            }

            return(formatted);
        }
Ejemplo n.º 11
0
        protected void Page_Load(object sender, System.EventArgs e)
        {
            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/windows.css");
            UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/Theme.css");

            UtilHelper.RegisterScript(Page, "~/Scripts/browser.js");
            UtilHelper.RegisterScript(Page, "~/Scripts/buttons.js");
            UtilHelper.RegisterScript(Page, "~/Scripts/common.js");

            lbUsers.Attributes.Add("ondblclick", "DisableButtons(this);" + Page.ClientScript.GetPostBackEventReference(btnAdd, ""));
            //btnSave.Attributes.Add("onclick","DisableButtons(this);");
            btnAdd.Attributes.Add("onclick", "DisableButtons(this);");
            btnAddGroup.Attributes.Add("onclick", "DisableButtons(this);");
            if (cbConfirmed.Checked)
            {
                btnAddGroup.Style.Add("display", "none");
            }
            else
            {
                btnAddGroup.Style.Add("display", "inline");
            }
            lblError.Visible = false;
            if (!IsPostBack)
            {
                ViewState["SearchMode"] = false;
                cbConfirmed.Text        = LocRM.GetString("MustBeConfirmed");
                btnAdd.InnerText        = LocRM.GetString("Add");
                btnAddGroup.InnerText   = LocRM.GetString("AddGroup");
                btnSearch.Text          = LocRM.GetString("FindNow");
                lblError.Text           = LocRM.GetString("EmrtySearch");
                GetEventData();
                BindGroups();
                BinddgMemebers();
            }
            cbConfirmed.Attributes.Add("onclick", "ChangeButtonState();");
        }
Ejemplo n.º 12
0
        private string GetBaseInfo()
        {
            String result = "";

            context.Response.ContentType = "application/json";
            DataClassesDataContext dc = new DataClassesDataContext();

            string id;

            if (context.Request.Params["aplID"] != null)
            {
                id = context.Request.Params["aplID"];
                ViewPosApl exs = dc.ViewPosApl.SingleOrDefault(es => es.F_ID.Equals(id));
                result = UtilHelper.GetJSON(exs);
            }
            else
            {
                id = context.Session[SessionMgm.UserID].ToString(); // 当前登录用户即该业务的申请者
                User usr = dc.User.SingleOrDefault(es => es.F_ID.Equals(id));
                result = UtilHelper.GetJSON(usr);
                result = result.Replace("F_ID", "F_UserID");
            }
            return(result);
        }
Ejemplo n.º 13
0
        public ActionResult GetPhotoPeople(int id)
        {
            if (id <= 0)
            {
                return(null);
            }

            PeopleViewModel peopleModel;

            try
            {
                peopleModel = repository.GetPeople(id);
                if (peopleModel == null)
                {
                    return(null);
                }

                return(File(UtilHelper.HttpPostedFileBaseToByte(peopleModel.PhotoPeople), peopleModel.PhotoMIMEType));
            }
            catch
            {
                return(null);
            }
        }
Ejemplo n.º 14
0
        /// <summary>
        /// 新订单
        /// </summary>
        /// <returns></returns>
        public async Task <IActionResult> Order([FromServices] IThirdOrderRepository service)
        {
            var business = await service.GetBusinessByMtPoi(formDic["app_poi_code"]);

            if (business == null || !business.MT_AutoRecieved)
            {
                return(Json(new { data = "ok" }));
            }
            //Log.Debug($"美团[新]订单:{business.Name}-{formDic["app_poi_code"]}-{formDic["day_seq"]}");
            // 如果设置了美团自动接单,则调用商户确认接口
            var url = "https://waimaiopen.meituan.com/api/v1/order/confirm";
            var mt  = new MTInputData(business.MT_AppKey, url);

            mt.SetValue("timestamp", DateTime.Now.ToTimestamp());
            mt.SetValue("app_id", business.MT_AppId);
            mt.SetValue("order_id", formDic["order_id"]);
            var sig = mt.MakeSign();

            mt.SetValue("sig", sig);
            url = $"{url}?{mt.ToUrl()}";
            await UtilHelper.RequestAsync(url, method : "get");

            return(Json(new { data = "ok" }));
        }
        private void Install(string name)
        {
            var TempAddonList      = _ConfigManager.GetAddonList(GameType);
            var willInstallAddon   = TempAddonList.Find(item => item.name == name);
            var applicationVersion = Assembly.GetExecutingAssembly().GetName().Version.ToString();

            if (willInstallAddon == null)
            {
                return;
            }

            if (!string.IsNullOrEmpty(willInstallAddon.limitExeVersion))
            {
                if (UtilHelper.GetVersionWeight(applicationVersion) < UtilHelper.GetVersionWeight(willInstallAddon.limitExeVersion))
                {
                    UtilHelper.ShowAlertDialog(new AlertDialogInterfaceModel {
                        Content = "StartGuildwars2 版本太低,请先更新"
                    });
                    return;
                }
            }

            var willInstallAddonList = GetWillInstallList(name);
            var steps = new List <AddonStepModel>();

            foreach (var willInstallAddonName in willInstallAddonList)
            {
                steps.Add(new AddonStepModel
                {
                    Action    = "INSTALL",
                    AddonName = willInstallAddonName,
                });
            }

            ShowAddonProgressDialog(steps);
        }
Ejemplo n.º 16
0
        //Atomic functions area
        private int ByConstructor(Type type)
        {
            //validation for auto-generated inner-classes for events
            if (UtilHelper.IsSameOrSubclass(typeof(MulticastDelegate), type))
            {
                return(0);
            }

            int count = 0;
            var ctors = type.GetConstructors(BindingFlags.DeclaredOnly | BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic);

            switch (ComplementValue)
            {
            case nameof(Constructor.NoArgs):
                foreach (ConstructorInfo ctor in ctors)
                {
                    if (ctor.GetParameters().Count() == 0)
                    {
                        count++;
                    }
                }
                break;

            case nameof(Constructor.WithArgs):
                foreach (ConstructorInfo ctor in ctors)
                {
                    if (ctor.GetParameters().Count() > 0)
                    {
                        count++;
                    }
                }
                break;
            }

            return(count);
        }
Ejemplo n.º 17
0
        private string GetTopMenuWelcomeText(string resourceString)
        {
            string fullName = CustomerContext.Current.CurrentContact.FullName;

            return(string.Format("{0}, {1}", (object)UtilHelper.GetResFileString(resourceString), string.IsNullOrEmpty(fullName) ? (object)SecurityContext.Current.CurrentUserName : (object)fullName));
        }
Ejemplo n.º 18
0
 private void BindFromObject(ToolBarItem[] itemCollection, List <McToolbarItem> toolbarItemsCollection)
 {
     if (itemCollection == null)
     {
         return;
     }
     foreach (ToolBarItem toolBarItem in itemCollection)
     {
         McToolbarItem mcToolbarItem1 = new McToolbarItem();
         if (toolBarItem is Menu)
         {
             mcToolbarItem1.ItemType = McToolbarItemType.Menu;
         }
         else if (toolBarItem is Button)
         {
             mcToolbarItem1.ItemType = McToolbarItemType.Button;
         }
         else if (toolBarItem is SplitButton)
         {
             mcToolbarItem1.ItemType = McToolbarItemType.SplitButton;
         }
         else if (toolBarItem is Text)
         {
             mcToolbarItem1.ItemType = McToolbarItemType.Text;
         }
         else if (toolBarItem is Splitter)
         {
             mcToolbarItem1.ItemType = McToolbarItemType.Splitter;
         }
         McToolbarItemAlign    toolbarItemAlign    = McToolbarItemAlign.Left;
         McToolbarItemSplitter toolbarItemSplitter = McToolbarItemSplitter.None;
         if (!string.IsNullOrEmpty(toolBarItem.align))
         {
             try
             {
                 toolbarItemAlign = (McToolbarItemAlign)Enum.Parse(typeof(McToolbarItemAlign), toolBarItem.align);
             }
             catch
             {
                 throw;
             }
         }
         if (!string.IsNullOrEmpty(toolBarItem.itemSplitter))
         {
             try
             {
                 toolbarItemSplitter = (McToolbarItemSplitter)Enum.Parse(typeof(McToolbarItemSplitter), toolBarItem.itemSplitter);
             }
             catch
             {
                 throw;
             }
         }
         if (toolBarItem.imageUrl != string.Empty && (mcToolbarItem1.ItemType == McToolbarItemType.Button || mcToolbarItem1.ItemType == McToolbarItemType.SplitButton || mcToolbarItem1.ItemType == McToolbarItemType.Menu))
         {
             mcToolbarItem1.CssClass += "x-btn-wrap x-btn x-btn-text-icon ";
         }
         mcToolbarItem1.Id        = toolBarItem.id;
         mcToolbarItem1.Text      = this.IsTopMenuWelcomeText(toolBarItem.text) ? this.GetTopMenuWelcomeText(toolBarItem.text) : UtilHelper.GetResFileString(toolBarItem.text);
         mcToolbarItem1.ImageUrl  = this.ResolveClientUrl(toolBarItem.imageUrl);
         mcToolbarItem1.CssClass += toolBarItem.cssClass;
         mcToolbarItem1.ItemAlign = toolbarItemAlign;
         mcToolbarItem1.Handler   = toolBarItem.handler;
         mcToolbarItem1.Tooltip   = UtilHelper.GetResFileString(toolBarItem.tooltip);
         bool isEnabled = true;
         if (!string.IsNullOrEmpty(toolBarItem.commandName))
         {
             CommandParameters           cp         = new CommandParameters(toolBarItem.commandName);
             Dictionary <string, string> dictionary = new Dictionary <string, string>();
             dictionary.Add("GridId", this.GridId);
             dictionary.Add("GridClientId", this.GridClientId);
             dictionary.Add("permissions", toolBarItem.permissions);
             if (!string.IsNullOrEmpty(this.ContainerId))
             {
                 dictionary.Add("ContainerId", this.ContainerId);
             }
             cp.CommandArguments = dictionary;
             string str = CommandManager.GetCurrent(this.Page).AddCommand(this.ClassName, this.ViewName, this.PlaceName, cp, out isEnabled);
             dictionary.Add("CommandManagerScript", str);
             cp.CommandArguments    = dictionary;
             mcToolbarItem1.Params  = cp.ToString();
             mcToolbarItem1.Handler = "defaultToolbarOnClick";
         }
         if (mcToolbarItem1.ItemType == McToolbarItemType.Menu || mcToolbarItem1.ItemType == McToolbarItemType.SplitButton)
         {
             if (toolBarItem is Menu)
             {
                 this.BindFromObject((toolBarItem as Menu).Items, mcToolbarItem1.Items);
             }
             else if (toolBarItem is SplitButton)
             {
                 this.BindFromObject((toolBarItem as SplitButton).Items, mcToolbarItem1.Items);
             }
         }
         if (isEnabled && (toolbarItemSplitter == McToolbarItemSplitter.Both || toolbarItemSplitter == McToolbarItemSplitter.Left))
         {
             McToolbarItem mcToolbarItem2 = new McToolbarItem(McToolbarItemType.Splitter);
             mcToolbarItem2.ItemAlign = toolbarItemAlign;
             toolbarItemsCollection.Add(mcToolbarItem2);
         }
         if (isEnabled)
         {
             toolbarItemsCollection.Add(mcToolbarItem1);
         }
         if (isEnabled && (toolbarItemSplitter == McToolbarItemSplitter.Both || toolbarItemSplitter == McToolbarItemSplitter.Right))
         {
             McToolbarItem mcToolbarItem2 = new McToolbarItem(McToolbarItemType.Splitter);
             mcToolbarItem2.ItemAlign = toolbarItemAlign;
             toolbarItemsCollection.Add(mcToolbarItem2);
         }
     }
 }
Ejemplo n.º 19
0
        //ds为柜明细表中取值的托信息的数据集,dt为前台gridview中的数据
        public DataSet UpdateArkInf(DataSet ds, DataTable dt, int flag)
        {
            DataSet      retDS = new DataSet();
            DbConnection dbCon = db.CreateConnection();

            dbCon.Open();
            DbTransaction dbTrans = dbCon.BeginTransaction();
            string        sql     = string.Empty;

            try
            {
                #region
                //0.判定柜是是新组柜还是已经存在的柜
                //  无托信息柜组柜
                //1.新增信息到柜抬头表
                //2.新增组柜信息到明细表
                //3.修改包装表中托状态为已组柜1
                if (flag == 1)
                {
                    string    key     = UtilHelper.GenerateNewKey(0);
                    DataTable dtHash  = ds.Tables["HASH"];
                    Hashtable hsTable = FanHai.Hemera.Share.Common.CommonUtils.ConvertToHashtable(dtHash);
                    string    sql01   = string.Format(@"INSERT INTO AWMS_CONTAINER(CONTAINER_KEY,CONTAINER_CODE,STATUS) VALUES('{0}','{1}','0')",
                                                      key,
                                                      hsTable["CONTAINER_CODE"].ToString()
                                                      );
                    db2.ExecuteNonQuery(CommandType.Text, sql01);

                    if (dt != null)
                    {
                        string  sql02 = string.Format(@"SELECT CONTAINER_KEY,CONTAINER_CODE FROM AWMS_CONTAINER WHERE STATUS = '0' AND CONTAINER_CODE ='{0}'", hsTable["CONTAINER_CODE"].ToString());
                        DataSet ds02  = db2.ExecuteDataSet(CommandType.Text, sql02);

                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            string sql03 = string.Format(@"INSERT INTO  AWMS_CONTAINER_DETAIL(CONTAINER_KEY,CONTAINER_CODE,PALLET_NO,CREATOR,CDATE,STATUS)
                                                        VALUES('{0}','{1}','{2}','{3}',GETDATE(),'1')",
                                                         ds02.Tables[0].Rows[0]["CONTAINER_KEY"].ToString(),
                                                         ds02.Tables[0].Rows[0]["CONTAINER_CODE"].ToString(),
                                                         dt.Rows[i]["PALLET_NO"],
                                                         hsTable["CREATOR"].ToString()
                                                         );
                            db2.ExecuteNonQuery(CommandType.Text, sql03);
                        }

                        DataTable dt04    = dt;
                        string    strPlus = string.Empty;
                        for (int i = 0; i < dt04.Rows.Count; i++)
                        {
                            strPlus += "'" + dt04.Rows[i]["PALLET_NO"].ToString().Trim() + "',";
                        }
                        if (string.IsNullOrEmpty(strPlus))
                        {
                            strPlus = "'',";
                        }
                        string str   = strPlus.Substring(0, strPlus.Length - 1);
                        string sql04 = string.Format(@"UPDATE WIP_CONSIGNMENT SET ARK_FLAG = '1' WHERE PALLET_NO IN({0})",
                                                     str
                                                     );
                        db.ExecuteNonQuery(CommandType.Text, sql04);
                        dbTrans.Commit();

                        FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(retDS, string.Empty);
                    }
                }
                #endregion

                //  有柜组柜
                //  明细表中没有托信息则不执行1  2两步
                //1.删除明细表中该柜主键的所有托信息
                //2.修改包装表中对应的托状态为未组柜0
                //3.新增组柜托信息到明细表
                //4.修改包装表中对应托状态为已组柜1
                else if (flag == 0)
                {
                    string    key     = UtilHelper.GenerateNewKey(0);
                    DataTable dtHash  = ds.Tables["HASH"];
                    Hashtable hsTable = FanHai.Hemera.Share.Common.CommonUtils.ConvertToHashtable(dtHash);

                    #region
                    if (dt != null)
                    {
                        string sql01 = string.Format(@"SELECT CONTAINER_KEY,CONTAINER_CODE FROM AWMS_CONTAINER WHERE STATUS = '0' AND CONTAINER_CODE ='{0}'"
                                                     , hsTable["CONTAINER_CODE"].ToString());
                        DataSet ds01 = db2.ExecuteDataSet(CommandType.Text, sql01);
                        if (ds01 != null)
                        {
                            if (ds01.Tables[0].Rows.Count == 1)
                            {
                                string sql02 = string.Format(@"SELECT PALLET_NO FROM AWMS_CONTAINER_DETAIL WHERE CONTAINER_KEY = '{0}'"
                                                             , ds01.Tables[0].Rows[0]["CONTAINER_KEY"].ToString());
                                DataSet ds02 = db2.ExecuteDataSet(CommandType.Text, sql02);


                                string sql03 = string.Format(@"DELETE FROM AWMS_CONTAINER_DETAIL WHERE CONTAINER_KEY = '{0}'"
                                                             , ds01.Tables[0].Rows[0]["CONTAINER_KEY"].ToString());
                                db2.ExecuteNonQuery(CommandType.Text, sql03);

                                string    strPlus04 = string.Empty;
                                DataTable dt04      = ds02.Tables[0];
                                for (int i = 0; i < dt04.Rows.Count; i++)
                                {
                                    strPlus04 += "'" + dt04.Rows[i]["PALLET_NO"].ToString().Trim() + "',";
                                }
                                if (string.IsNullOrEmpty(strPlus04))
                                {
                                    strPlus04 = "'',";
                                }
                                string str04 = strPlus04.Substring(0, strPlus04.Length - 1);

                                string sql04 = string.Format(@"UPDATE WIP_CONSIGNMENT SET ARK_FLAG = '0' WHERE PALLET_NO IN({0})"
                                                             , str04);
                                db.ExecuteNonQuery(CommandType.Text, sql04);

                                for (int i = 0; i < dt.Rows.Count; i++)
                                {
                                    string sql05 = string.Format(@"INSERT INTO  AWMS_CONTAINER_DETAIL(CONTAINER_KEY,CONTAINER_CODE,PALLET_NO,CREATOR,CDATE,STATUS)
                                                                VALUES('{0}','{1}','{2}','{3}',GETDATE(),'1')",
                                                                 ds01.Tables[0].Rows[0]["CONTAINER_KEY"].ToString(),
                                                                 ds01.Tables[0].Rows[0]["CONTAINER_CODE"].ToString(),
                                                                 dt.Rows[i]["PALLET_NO"],
                                                                 hsTable["CREATOR"].ToString()
                                                                 );
                                    db2.ExecuteNonQuery(CommandType.Text, sql05);
                                }

                                DataTable dt06      = dt;
                                string    strPlus06 = string.Empty;
                                for (int i = 0; i < dt06.Rows.Count; i++)
                                {
                                    strPlus06 += "'" + dt06.Rows[i]["PALLET_NO"].ToString().Trim() + "',";
                                }
                                if (string.IsNullOrEmpty(strPlus06))
                                {
                                    strPlus06 = "'',";
                                }
                                string str06 = strPlus06.Substring(0, strPlus06.Length - 1);
                                string sql06 = string.Format(@"UPDATE WIP_CONSIGNMENT SET ARK_FLAG = '1' WHERE PALLET_NO IN({0})",
                                                             str06
                                                             );
                                db.ExecuteNonQuery(CommandType.Text, sql06);
                            }
                            else
                            {
                                for (int i = 0; i < dt.Rows.Count; i++)
                                {
                                    string sql05 = string.Format(@"INSERT INTO  AWMS_CONTAINER_DETAIL(CONTAINER_KEY,CONTAINER_CODE,PALLET_NO,CREATOR,CDATE,STATUS)
                                                                VALUES('{0}','{1}','{2}','{3}',GETDATE(),'1')",
                                                                 ds01.Tables[0].Rows[0]["CONTAINER_KEY"].ToString(),
                                                                 ds01.Tables[0].Rows[0]["CONTAINER_CODE"].ToString(),
                                                                 dt.Rows[i]["PALLET_NO"],
                                                                 hsTable["CREATOR"].ToString()
                                                                 );
                                    db2.ExecuteNonQuery(CommandType.Text, sql05);
                                }

                                DataTable dt06      = dt;
                                string    strPlus06 = string.Empty;
                                for (int i = 0; i < dt06.Rows.Count; i++)
                                {
                                    strPlus06 += "'" + dt06.Rows[i]["PALLET_NO"].ToString().Trim() + "',";
                                }
                                if (string.IsNullOrEmpty(strPlus06))
                                {
                                    strPlus06 = "'',";
                                }
                                string str06 = strPlus06.Substring(0, strPlus06.Length - 1);
                                string sql06 = string.Format(@"UPDATE WIP_CONSIGNMENT SET ARK_FLAG = '1' WHERE PALLET_NO IN({0})",
                                                             str06
                                                             );
                                db.ExecuteNonQuery(CommandType.Text, sql06);
                            }
                        }
                        dbTrans.Commit();

                        FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(retDS, string.Empty);
                    }
                    #endregion
                    //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
                    if (dt == null)
                    {
                        string sql01 = string.Format(@"SELECT CONTAINER_KEY,CONTAINER_CODE FROM AWMS_CONTAINER WHERE STATUS = '0' AND CONTAINER_CODE ='{0}'"
                                                     , hsTable["CONTAINER_CODE"].ToString());
                        DataSet ds01 = db2.ExecuteDataSet(CommandType.Text, sql01);
                        if (ds01 != null)
                        {
                            if (ds01.Tables[0].Rows.Count == 1)
                            {
                                string sql02 = string.Format(@"SELECT PALLET_NO FROM AWMS_CONTAINER_DETAIL WHERE CONTAINER_KEY = '{0}'"
                                                             , ds01.Tables[0].Rows[0]["CONTAINER_KEY"].ToString());
                                DataSet ds02 = db2.ExecuteDataSet(CommandType.Text, sql02);


                                string sql03 = string.Format(@"DELETE FROM AWMS_CONTAINER_DETAIL WHERE CONTAINER_KEY = '{0}'"
                                                             , ds01.Tables[0].Rows[0]["CONTAINER_KEY"].ToString());
                                db2.ExecuteNonQuery(CommandType.Text, sql03);

                                string    strPlus04 = string.Empty;
                                DataTable dt04      = ds02.Tables[0];
                                for (int i = 0; i < dt04.Rows.Count; i++)
                                {
                                    strPlus04 += "'" + dt04.Rows[i]["PALLET_NO"].ToString().Trim() + "',";
                                }
                                if (string.IsNullOrEmpty(strPlus04))
                                {
                                    strPlus04 = "'',";
                                }
                                string str04 = strPlus04.Substring(0, strPlus04.Length - 1);

                                string sql04 = string.Format(@"UPDATE WIP_CONSIGNMENT SET ARK_FLAG = '0' WHERE PALLET_NO IN({0})"
                                                             , str04);
                                db.ExecuteNonQuery(CommandType.Text, sql04);

                                dbTrans.Commit();

                                FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(retDS, string.Empty);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                dbTrans.Rollback();
                FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(retDS, ex.Message);
                LogService.LogError("UpdateArkInf Error: " + ex.Message);
            }
            return(retDS);
        }
Ejemplo n.º 20
0
        /// <summary>
        /// 转返工单作业。
        /// </summary>
        /// <param name="dsParams"></param>
        /// <returns></returns>
        public DataSet LotExchange(DataSet dsParams)
        {
            DataSet dsReturn = new DataSet();

            //参数数据。
            if (dsParams == null ||
                !dsParams.Tables.Contains(TRANS_TABLES.TABLE_PARAM) ||                      //存放附加参数数据
                !dsParams.Tables.Contains(POR_LOT_FIELDS.DATABASE_TABLE_NAME)               //存放批次数据
                )
            {
                ReturnMessageUtils.AddServerReturnMessage(dsReturn, "传入参数不正确,请检查。");
                return(dsReturn);
            }

            try
            {
                DataTable dtParams      = dsParams.Tables[TRANS_TABLES.TABLE_PARAM];
                DataTable dtLots        = dsParams.Tables[POR_LOT_FIELDS.DATABASE_TABLE_NAME];
                Hashtable htParams      = CommonUtils.ConvertToHashtable(dtParams);
                string    editor        = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_EDITOR]);       //编辑人
                string    opComputer    = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_OPR_COMPUTER]); //编辑人
                string    enterpriseKey = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_ROUTE_ENTERPRISE_VER_KEY]);
                string    routeKey      = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_CUR_ROUTE_VER_KEY]);
                string    stepKey       = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_CUR_STEP_VER_KEY]);
                string    activity      = Convert.ToString(htParams[WIP_TRANSACTION_FIELDS.FIELD_ACTIVITY]);
                using (DbConnection dbConn = db.CreateConnection())
                {
                    dbConn.Open();
                    using (DbTransaction dbTran = dbConn.BeginTransaction())
                    {
                        foreach (DataRow dr in dtLots.Rows)
                        {
                            string lotKey    = Convert.ToString(dr[POR_LOT_FIELDS.FIELD_LOT_KEY]);
                            string lotNumber = Convert.ToString(dr[POR_LOT_FIELDS.FIELD_LOT_NUMBER]);
                            string ttime     = Convert.ToString(dr[WIP_IV_TEST_FIELDS.FIELDS_T_DATE]);
                            string palletNo  = Convert.ToString(dr[POR_LOT_FIELDS.FIELD_PALLET_NO]);

                            //检查记录是否过期。防止重复修改。
                            KeyValuePair <string, string>         kvp           = new KeyValuePair <string, string>(POR_LOT_FIELDS.FIELD_LOT_KEY, lotKey);
                            List <KeyValuePair <string, string> > listCondition = new List <KeyValuePair <string, string> >();
                            listCondition.Add(kvp);
                            string opEditTime = Convert.ToString(dr[POR_LOT_FIELDS.FIELD_EDIT_TIME]);
                            //如果记录过期,当前编辑时间<数据库中的记录编辑时间。结束方法执行。
                            if (UtilHelper.CheckRecordExpired(db, POR_LOT_FIELDS.DATABASE_TABLE_NAME, listCondition, opEditTime))
                            {
                                ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Format("组件{0}信息已过期,请确认。", lotNumber));
                                return(dsReturn);
                            }
                            //获取批次数据
                            string sqlQueryLot = string.Format(@"SELECT A.*,
                                                                        B.ENTERPRISE_NAME,
                                                                        B.ENTERPRISE_VERSION,
                                                                        C.ROUTE_NAME ,
                                                                        D.ROUTE_STEP_NAME
                                                                    FROM POR_LOT A
                                                                    LEFT JOIN POR_ROUTE_ENTERPRISE_VER B ON B.ROUTE_ENTERPRISE_VER_KEY=  A.ROUTE_ENTERPRISE_VER_KEY
                                                                    LEFT JOIN POR_ROUTE_ROUTE_VER C ON C.ROUTE_ROUTE_VER_KEY=A.CUR_ROUTE_VER_KEY
                                                                    LEFT JOIN POR_ROUTE_STEP D ON D.ROUTE_STEP_KEY=A.CUR_STEP_VER_KEY
                                                                    WHERE A.STATUS < 2
                                                                    AND A.LOT_NUMBER='{0}'",
                                                               lotNumber.PreventSQLInjection());
                            DataTable dtTable        = db.ExecuteDataSet(dbTran, CommandType.Text, sqlQueryLot).Tables[0];
                            DataRow   drLotInfo      = dtTable.Rows[0];
                            string    transactionKey = CommonUtils.GenerateNewKey(0);
                            AddWIPLot(dbTran, transactionKey, lotKey);
                            //向WIP_TRANSACTION表插入批次转返工单的操作记录。
                            Hashtable htTransaction = new Hashtable();
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_TRANSACTION_KEY, transactionKey);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_ACTIVITY, activity);
                            if (htParams.Contains(WIP_TRANSACTION_FIELDS.FIELD_ACTIVITY_COMMENT))
                            {
                                htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_ACTIVITY_COMMENT, htParams[WIP_TRANSACTION_FIELDS.FIELD_ACTIVITY_COMMENT]);
                            }
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_EDIT_TIME, null);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_EDIT_TIMEZONE_KEY, drLotInfo[POR_LOT_FIELDS.FIELD_EDIT_TIMEZONE]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_EDITOR, htParams[WIP_TRANSACTION_FIELDS.FIELD_EDITOR]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_ENTERPRISE_KEY, drLotInfo[POR_LOT_FIELDS.FIELD_ROUTE_ENTERPRISE_VER_KEY]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_ENTERPRISE_NAME, drLotInfo[POR_ROUTE_ENTERPRISE_VER_FIELDS.FIELD_ENTERPRISE_NAME]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_EQUIPMENT_KEY, null);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_LINE_KEY, null);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_OPERATOR, editor);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_OPR_COMPUTER, opComputer);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_OPR_LINE, null);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_OPR_LINE_PRE, drLotInfo[POR_LOT_FIELDS.FIELD_LINE_NAME]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_PIECE_KEY, drLotInfo[POR_LOT_FIELDS.FIELD_LOT_KEY]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_PIECE_TYPE, 0);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_QUANTITY_IN, drLotInfo[POR_LOT_FIELDS.FIELD_QUANTITY]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_QUANTITY_OUT, drLotInfo[POR_LOT_FIELDS.FIELD_QUANTITY]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_REWORK_FLAG, drLotInfo[POR_LOT_FIELDS.FIELD_IS_REWORKED]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_ROUTE_KEY, drLotInfo[POR_LOT_FIELDS.FIELD_CUR_ROUTE_VER_KEY]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_ROUTE_NAME, drLotInfo[POR_ROUTE_ROUTE_VER_FIELDS.FIELD_ROUTE_NAME]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_SHIFT_KEY, htParams[WIP_TRANSACTION_FIELDS.FIELD_SHIFT_KEY]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_SHIFT_NAME, htParams[WIP_TRANSACTION_FIELDS.FIELD_SHIFT_NAME]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_STATE_FLAG, drLotInfo[POR_LOT_FIELDS.FIELD_STATE_FLAG]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_STEP_KEY, drLotInfo[POR_LOT_FIELDS.FIELD_CUR_STEP_VER_KEY]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_STEP_NAME, drLotInfo[POR_ROUTE_STEP_FIELDS.FIELD_ROUTE_STEP_NAME]);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_TIME_STAMP, null);
                            htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_WORK_ORDER_KEY, drLotInfo[POR_LOT_FIELDS.FIELD_WORK_ORDER_KEY]);
                            WIP_TRANSACTION_FIELDS wipFields = new WIP_TRANSACTION_FIELDS();
                            string sql = DatabaseTable.BuildInsertSqlStatement(wipFields, htTransaction, null);
                            db.ExecuteNonQuery(dbTran, CommandType.Text, sql);
                            //更新批次数据
                            string updateLot = string.Format(@"UPDATE POR_LOT 
                                                              SET STATE_FLAG=0,
                                                                  {12}
                                                                  DELETED_TERM_FLAG=0,
                                                                  ROUTE_ENTERPRISE_VER_KEY='{1}',
                                                                  CUR_ROUTE_VER_KEY='{2}',
                                                                  CUR_STEP_VER_KEY='{3}',
                                                                  EDITOR='{4}',
                                                                  EDIT_TIME=GETDATE(),
                                                                  FACTORYROOM_KEY='{5}',
                                                                  FACTORYROOM_NAME='{6}',
                                                                  WORK_ORDER_NO='{7}',
                                                                  WORK_ORDER_KEY='{8}',
                                                                  PART_NUMBER='{9}',
                                                                  PRO_ID='{10}',
                                                                  CUR_PRODUCTION_LINE_KEY=NULL,
                                                                  LINE_NAME=NULL,
                                                                  START_WAIT_TIME=GETDATE(),
                                                                  START_PROCESS_TIME=NULL,
                                                                  PALLET_NO=NULL,
                                                                  PALLET_TIME=NULL,
                                                                  OPR_COMPUTER='{4}',
                                                                  OPR_LINE=NULL,
                                                                  OPERATOR='{11}'
                                                              WHERE LOT_KEY='{0}'",
                                                             lotKey.PreventSQLInjection(),
                                                             enterpriseKey.PreventSQLInjection(),
                                                             routeKey.PreventSQLInjection(),
                                                             stepKey.PreventSQLInjection(),
                                                             editor.PreventSQLInjection(),
                                                             dr[POR_LOT_FIELDS.FIELD_FACTORYROOM_KEY],
                                                             dr[POR_LOT_FIELDS.FIELD_FACTORYROOM_NAME],
                                                             dr["NEW_WORK_ORDER_NO"],
                                                             dr["NEW_WORK_ORDER_KEY"],
                                                             dr["NEW_PART_NUMBER"],
                                                             dr["NEW_PRO_ID"],
                                                             opComputer.PreventSQLInjection(),
                                                             activity == ACTIVITY_FIELD_VALUES.FIELD_ACTIVITY_CHANGE_PROID?  "REWORK_FLAG=REWORK_FLAG+1," : string.Empty);
                            this.db.ExecuteNonQuery(dbTran, CommandType.Text, updateLot);
                            //如果有有效测试数据,更新测试数据
                            if (!string.IsNullOrEmpty(ttime))
                            {
                                string updateIVTest = string.Format(@"UPDATE WIP_IV_TEST 
                                                              SET VC_TYPE='{1}',I_IDE='{2}',I_PKID='{3}',VC_MODNAME='{4}',VC_WORKORDER='{5}'
                                                              WHERE LOT_NUM='{0}'
                                                              AND VC_DEFAULT='1'",
                                                                    lotNumber.PreventSQLInjection(),
                                                                    dr[WIP_IV_TEST_FIELDS.FIELDS_VC_TYPE],
                                                                    dr[WIP_IV_TEST_FIELDS.FIELDS_I_IDE],
                                                                    dr[WIP_IV_TEST_FIELDS.FIELDS_I_PKID],
                                                                    dr[WIP_IV_TEST_FIELDS.FIELDS_VC_MODNAME],
                                                                    dr["NEW_WORK_ORDER_NO"]);
                                this.db.ExecuteNonQuery(dbTran, CommandType.Text, updateIVTest);
                            }
                        }
                        //更新包装数据。
                        var lnq = dtLots.AsEnumerable().Where(dr => string.IsNullOrEmpty(Convert.ToString(dr[POR_LOT_FIELDS.FIELD_PALLET_NO])) == false)
                                  .Select(dr => Convert.ToString(dr[POR_LOT_FIELDS.FIELD_PALLET_NO]))
                                  .Distinct();
                        foreach (string palletNo in lnq)
                        {
                            string consignmentKey = CommonUtils.GenerateNewKey(0);
                            //新增包装明细数据
                            string sql = string.Format(@"INSERT INTO WIP_CONSIGNMENT_DETAIL
                                                        (CONSIGNMENT_KEY,ITEM_NO,LOT_NUMBER,WORK_NUMBER,PART_NUMBER,PRO_ID,PRO_LEVEL,
                                                        COLOR,POWER_LEVEL,PS_CODE,PS_DTL_CODE,FULL_QTY,PS_SEQ,AVG_POWER_RANGE,CREATOR,CREATE_TIME)
                                                       SELECT '{0}',
                                                               ROW_NUMBER() OVER(PARTITION BY a.CONSIGNMENT_KEY ORDER BY b.ITEM_NO) ITEM_NO,
                                                               b.LOT_NUMBER,
                                                               b.WORK_NUMBER,
                                                               b.PART_NUMBER,
                                                               b.PRO_ID,
                                                               b.PRO_LEVEL,
                                                               b.COLOR,
                                                               b.POWER_LEVEL,
                                                               b.PS_CODE,
                                                               b.PS_DTL_CODE,
                                                               b.FULL_QTY,
                                                               b.PS_SEQ,
                                                               b.AVG_POWER_RANGE,
                                                               b.CREATOR,
                                                               b.CREATE_TIME
                                                        FROM WIP_CONSIGNMENT a
                                                        INNER JOIN WIP_CONSIGNMENT_DETAIL b ON b.CONSIGNMENT_KEY=a.CONSIGNMENT_KEY
                                                        INNER JOIN POR_LOT c ON c.PALLET_NO=a.VIRTUAL_PALLET_NO AND c.LOT_NUMBER=b.LOT_NUMBER 
                                                        WHERE a.ISFLAG=1
                                                        AND a.PALLET_NO='{1}'",
                                                       consignmentKey,
                                                       palletNo.PreventSQLInjection());
                            this.db.ExecuteNonQuery(dbTran, CommandType.Text, sql);
                            //新增包装数据
                            sql = string.Format(@"INSERT INTO WIP_CONSIGNMENT(CONSIGNMENT_KEY,VIRTUAL_PALLET_NO,PALLET_NO,WORKNUMBER,CS_DATA_GROUP,
                                                    SAP_NO,POWER_LEVEL,GRADE,SHIFT,PS_CODE,PS_DTL_SUBCODE,
                                                    LAST_PALLET,CREATER,CREATE_TIME,EDITOR,EDIT_TIME,ISFLAG,
                                                    ROOM_KEY,CUSTOMER_NO,LOT_NUMBER_QTY,FULL_QTY,TOTLE_POWER,
                                                    AVG_POWER,PRO_ID,PALLET_NO_NEW,PALLET_TYPE,
                                                    CODE_TYPE,LINE_NAME,LINE_KEY,EQUIPMENT_KEY,EQUIPMENT_NAME,
                                                    AVG_POWER_RANGE,LOT_COLOR,PS_SEQ,CHECKER,CHECK_TIME,
                                                    TO_WH,TO_WH_TIME,OUT_WH,OUT_WH_TIME,MEMO1,ARK_FLAG)
                                                SELECT '{0}', a.VIRTUAL_PALLET_NO,a.PALLET_NO,a.WORKNUMBER,a.CS_DATA_GROUP,
                                                       a.SAP_NO,a.POWER_LEVEL,a.GRADE,a.SHIFT,a.PS_CODE,a.PS_DTL_SUBCODE,
                                                       a.LAST_PALLET,a.CREATER,a.CREATE_TIME,'{2}',GETDATE(),a.ISFLAG,
                                                       a.ROOM_KEY,a.CUSTOMER_NO,a.LOT_NUMBER_QTY,a.FULL_QTY,a.TOTLE_POWER,
                                                       a.AVG_POWER,a.PRO_ID,a.PALLET_NO_NEW,a.PALLET_TYPE,
                                                       a.CODE_TYPE,a.LINE_NAME,a.LINE_KEY,a.EQUIPMENT_KEY,a.EQUIPMENT_NAME,
                                                       a.AVG_POWER_RANGE,a.LOT_COLOR,a.PS_SEQ,a.CHECKER,a.CHECK_TIME,
                                                       a.TO_WH,a.TO_WH_TIME,a.OUT_WH,a.OUT_WH_TIME,a.MEMO1,a.ARK_FLAG
                                                FROM WIP_CONSIGNMENT a
                                                WHERE a.ISFLAG=1
                                                AND a.PALLET_NO='{1}'",
                                                consignmentKey,
                                                palletNo.PreventSQLInjection(),
                                                editor.PreventSQLInjection());
                            this.db.ExecuteNonQuery(dbTran, CommandType.Text, sql);

                            //更新原来的包装数据为无效
                            sql = string.Format(@"UPDATE WIP_CONSIGNMENT
                                            SET ISFLAG=0,EDITOR='{2}',EDIT_TIME=GETDATE(),MEMO1='转/返工单 {3} {4}'
                                            WHERE ISFLAG=1
                                            AND PALLET_NO='{1}'
                                            AND CONSIGNMENT_KEY!='{0}'",
                                                consignmentKey,
                                                palletNo.PreventSQLInjection(),
                                                editor.PreventSQLInjection(),
                                                activity,
                                                htParams[WIP_TRANSACTION_FIELDS.FIELD_ACTIVITY_COMMENT]);
                            this.db.ExecuteNonQuery(dbTran, CommandType.Text, sql);
                            //更新现有的包装数据,为其第一条数据的基本数据
                            sql = string.Format(@"UPDATE a
                                                SET    a.WORKNUMBER=b.WORK_NUMBER,
                                                       a.SAP_NO=b.PART_NUMBER,
                                                       a.POWER_LEVEL=b.POWER_LEVEL,
                                                       a.GRADE=b.PRO_LEVEL,
                                                       a.PS_CODE=b.PS_CODE,
                                                       a.PS_DTL_SUBCODE=b.PS_DTL_CODE,
                                                       a.LOT_NUMBER_QTY=(SELECT COUNT(1) FROM WIP_CONSIGNMENT_DETAIL aa WHERE aa.CONSIGNMENT_KEY=a.CONSIGNMENT_KEY),
                                                       a.FULL_QTY=b.FULL_QTY,
                                                       a.TOTLE_POWER=(SELECT ISNULL(SUM(bb.COEF_PMAX),0)
                                                                      FROM WIP_CONSIGNMENT_DETAIL aa
                                                                      INNER JOIN WIP_IV_TEST bb ON bb.LOT_NUM=aa.LOT_NUMBER AND bb.VC_DEFAULT='1'
                                                                      WHERE aa.CONSIGNMENT_KEY=a.CONSIGNMENT_KEY),
                                                       a.PRO_ID=b.PRO_ID,
                                                       a.LOT_COLOR=b.COLOR,
                                                       a.PS_SEQ=b.PS_SEQ,
                                                       a.AVG_POWER_RANGE=b.AVG_POWER_RANGE
                                                FROM WIP_CONSIGNMENT a
                                                LEFT JOIN WIP_CONSIGNMENT_DETAIL b ON b.CONSIGNMENT_KEY=a.CONSIGNMENT_KEY AND b.ITEM_NO=1
                                                WHERE a.CONSIGNMENT_KEY='{0}'",
                                                consignmentKey);
                            this.db.ExecuteNonQuery(dbTran, CommandType.Text, sql);

                            sql = string.Format(@"UPDATE a
                                                SET    a.AVG_POWER=CASE WHEN a.LOT_NUMBER_QTY=0 THEN 0 ELSE a.TOTLE_POWER/a.LOT_NUMBER_QTY END,
                                                       a.ISFLAG=CASE WHEN a.LOT_NUMBER_QTY>0 THEN 1 ELSE 0 END
                                                FROM WIP_CONSIGNMENT a
                                                WHERE a.CONSIGNMENT_KEY='{0}'",
                                                consignmentKey);
                            this.db.ExecuteNonQuery(dbTran, CommandType.Text, sql);
                        }
                        dbTran.Commit();
                    }
                    dbConn.Close();
                }
            }
            catch (Exception ex)
            {
                ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
                LogService.LogError("LotOperationEngine.LotExchange Error: " + ex.Message);
            }
            return(dsReturn);
        }
Ejemplo n.º 21
0
        /// <summary>
        /// Adds the acl group.
        /// </summary>
        /// <param name="group">The group.</param>
        /// <param name="treeNode">The tree node.</param>
        /// <returns></returns>
        private int AddAclGroup(AclGroup group, TreeNode treeNode)
        {
            int      childrenChecked = -1; // 1 - checked, 2 - unchecked, 0 - some checked, -1 - not set
            TreeNode groupNode       = new TreeNode();

            groupNode.Value        = GetTreeNodeUniqueId(_groupNodePrefix, group.ID);
            groupNode.Text         = UtilHelper.GetResFileString(group.Name);
            groupNode.ShowCheckBox = true;
            groupNode.ImageUrl     = Page.ResolveUrl("~/Apps/Profile/images/security_folder.png");
            groupNode.SelectAction = TreeNodeSelectAction.Expand;
            treeNode.ChildNodes.Add(groupNode);

            // add child groups
            foreach (AclGroup childGroup in group.Groups)
            {
                int result = AddAclGroup(childGroup, groupNode);
                if (result == 2 && childrenChecked == 1)
                {
                    childrenChecked = 0;
                }
                else if (result == 2 && childrenChecked == -1)
                {
                    childrenChecked = 2;
                }
                else if (result == 1 && childrenChecked == -1)
                {
                    childrenChecked = 1;
                }
                else if (result == 1 && childrenChecked == 2)
                {
                    childrenChecked = 0;
                }
                else if (result == 0)
                {
                    childrenChecked = 0;
                }
            }

            // add permissions
            foreach (AclPermission permission in group.Permissions)
            {
                TreeNode permissionNode = new TreeNode();
                permissionNode.Value        = GetTreeNodeUniqueId(_permissionNodePrefix, permission.ToString());
                permissionNode.Text         = UtilHelper.GetResFileString(permission.Name);
                permissionNode.SelectAction = TreeNodeSelectAction.None;
                permissionNode.ImageUrl     = Page.ResolveUrl("~/Apps/Profile/images/security_key.png");

                // check node if permission is set
                if (_Permission != null)
                {
                    PermissionDto.RolePermissionRow[] permissionRows = (PermissionDto.RolePermissionRow[])_Permission.RolePermission.Select(String.Format("Permission='{0}'", permission.ToString()));
                    if (permissionRows != null && permissionRows.Length > 0)
                    {
                        permissionNode.Checked = true;
                        if (childrenChecked == -1)
                        {
                            childrenChecked = 1;
                        }
                    }
                }

                if (!permissionNode.Checked && childrenChecked == 1)
                {
                    childrenChecked = 0;
                }
                if (!permissionNode.Checked && childrenChecked == -1)
                {
                    childrenChecked = 2;
                }

                groupNode.ChildNodes.Add(permissionNode);
            }

            groupNode.Checked = childrenChecked == 1;

            if (childrenChecked == 0)
            {
                groupNode.Select();
                groupNode.Expand();
            }
            else
            {
                groupNode.Collapse();
            }

            return(childrenChecked);
        }
Ejemplo n.º 22
0
        /// <summary>
        /// Handles the Load event of the Page control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
        protected void Page_Load(object sender, EventArgs e)
        {
            //set application name to page title
            Literal1.Text = String.Format("{0} - {1}", AppContext.Current.ApplicationName, UtilHelper.GetResFileString("{SharedStrings:Mediachase_Commerce_Manager_5_0}"));

            Response.Cache.SetNoStore();
            GetDefaultLink();
            RegisterScripts();

            ManagementHelper.RegisterBrowserStyles(this);
        }
Ejemplo n.º 23
0
        public void ColumnResize(string ContextKey, int ColumnIndex, int NewSize)
        {
            EcfListViewContextKey key = UtilHelper.JsonDeserialize <EcfListViewContextKey>(ContextKey);

            try
            {
                // get old settings
                string gridSettingsKey       = CMPageSettings.MakeGridSettingsKey(key.AppId, key.ViewId);
                string oldGridSettings       = ProfileContext.Current.Profile.PageSettings.GetSettingString(gridSettingsKey);
                EcfListViewPreferences prefs = null;
                if (!String.IsNullOrEmpty(oldGridSettings))
                {
                    prefs = UtilHelper.JsonDeserialize <EcfListViewPreferences>(oldGridSettings);
                }

                if (prefs == null)
                {
                    prefs = new EcfListViewPreferences(key.AppId, key.ViewId);
                }

                int       index = ColumnIndex;
                AdminView view  = ManagementContext.Current.FindView(key.AppId, key.ViewId);
                if (view != null && view.Columns.Count > ColumnIndex)
                {
                    // get real index of a column with visibleIndex==ColumnIndex
                    // start search from column with index == ColumnIndex because its visibleIndex<=ColumnIndex
                    for (int i = ColumnIndex; i < view.Columns.Count; i++)
                    {
                        if (view.Columns[i].ColumnVisibleIndex == ColumnIndex)
                        {
                            index = i;
                            break;
                        }
                    }
                }
                prefs.ColumnProperties[index.ToString()] = NewSize.ToString();

                // save new settings
                ProfileContext.Current.Profile.PageSettings.SetSettingString(gridSettingsKey, UtilHelper.JsonSerialize(prefs));
                ProfileContext.Current.Profile.Save();
            }
            catch (Exception ex)
            {
                // TODO: handle exception
            }
        }
Ejemplo n.º 24
0
        public async Task <IActionResult> Save([FromBody] ProductModel product, [FromServices] IHostingEnvironment host)
        {
            var result = new JsonData();

            if (!string.IsNullOrEmpty(product.Img400))
            {
                var file = new ProductImage
                {
                    CreateTime = DateTime.Now,
                    Name       = Guid.NewGuid().ToString().ToLower(),
                    Type       = ImageType.Product,
                    Length     = Convert.FromBase64String(product.Img400.Replace("data:image/jpeg;base64,", "")).Length
                };
                // 上传图片
                var msg = await Service.UploadImageAsync(AppData.ApiUri + "/Product", Business.ID, file.Name + "." + file.ExtensionName, product.Img400, product.Img200, product.Img100);

                if (msg != "ok")
                {
                    result.Msg = msg;
                    return(Json(result));
                }
                product.Images = new List <ProductImage> {
                    file
                };
            }

            // 图片上传成功后,保存商品
            foreach (var item in product.Formats)
            {
                item.Code = Service.GetNextProductFormat();
            }
            var entity = new Product
            {
                BusinessId     = Business.ID,
                Description    = product.Description,
                MinBuyQuantity = product.MinBuyQuantity,
                Name           = product.Name,
                Pinyin         = UtilHelper.GetPinyin(product.Name),
                FirstLetter    = UtilHelper.GetFirstPinyin(product.Name),
                ProductTypeId  = product.ProductTypeId,
                UnitName       = product.UnitName,
                Scope          = product.Scope,
                Images         = product.Images,
                Formats        = product.Formats,
                Attributes     = product.Attributes,
                ProductIdSet   = product.ProductIdSet,
                Feature        = product.Feature,
                IsDiscount     = product.IsDiscount
            };

            Service.Add(entity);
            entity.Code = entity.ID.ToString().PadLeft(6, '0');
            Service.Commit();
            if (entity.Feature == ProductFeature.SetMeal && !string.IsNullOrEmpty(product.ProductIdSet))
            {
                product.ProductIdSet.Split(',').ToList().ForEach(a => {
                    var item = new ProductRelative {
                        SetMealId = entity.ID, ProductId = Convert.ToInt32(a)
                    };
                    Service.Add(item);
                });
            }
            result.Success = true;
            result.Msg     = "保存成功";
            return(Ok(result));
        }
Ejemplo n.º 25
0
 public BusinessController(IBusinessRepository service, UtilHelper helper)
 {
     this.service = service;
     this.helper  = helper;
 }
Ejemplo n.º 26
0
        public static List <EventDetails> GetEventsList()
        {
            DateTime eventDate = DateTime.Now.AddHours(2);

            var retSource = new List <EventDetails>
            {
                new EventDetails
                {
                    EventStart     = UtilHelper.ConvertDateToSqlDate(eventDate),
                    EventEnd       = UtilHelper.ConvertDateToSqlDate(eventDate.AddHours(1)),
                    EventLocation  = "AEC Offices",
                    EventTitle     = "Flight to Salt Lake city",
                    EventId        = 1,
                    Status         = "Declined",
                    PhoneNumber    = "01234567890",
                    Email          = "*****@*****.**",
                    AdditionalInfo = "Dress code is required",
                    JobPostId      = "12345"
                }
            };

            eventDate = eventDate.AddHours(2);
            retSource.Add(new EventDetails
            {
                EventStart     = UtilHelper.ConvertDateToSqlDate(eventDate),
                EventEnd       = UtilHelper.ConvertDateToSqlDate(eventDate.AddHours(1.5)),
                EventLocation  = "HDRF - Olaya street",
                EventTitle     = "Team Meeting",
                EventId        = 2,
                Status         = "Accepted",
                PhoneNumber    = "01234567890",
                Email          = "*****@*****.**",
                AdditionalInfo = "Dress code is required",
                JobPostId      = "13645"
            });

            eventDate = eventDate.AddDays(1).AddHours(-2);
            retSource.Add(new EventDetails
            {
                EventStart     = UtilHelper.ConvertDateToSqlDate(eventDate),
                EventEnd       = UtilHelper.ConvertDateToSqlDate(eventDate.AddHours(1)),
                EventLocation  = "CBA Limited - Riyah, KSA",
                EventTitle     = "Ford project Initialization",
                EventId        = 3,
                Status         = "Accepted",
                PhoneNumber    = "01234567890",
                Email          = "*****@*****.**",
                AdditionalInfo = "Dress code is required",
                JobPostId      = "2"
            });

            eventDate = eventDate.AddHours(3);
            retSource.Add(new EventDetails
            {
                EventStart     = UtilHelper.ConvertDateToSqlDate(eventDate),
                EventEnd       = UtilHelper.ConvertDateToSqlDate(eventDate.AddHours(1)),
                EventLocation  = "Google Office - Dubai",
                EventTitle     = "Google Conference",
                EventId        = 4,
                Status         = "Accepted",
                PhoneNumber    = "01234567890",
                Email          = "*****@*****.**",
                AdditionalInfo = "Dress code is required",
                JobPostId      = "3"
            });

            eventDate = eventDate.AddDays(1).AddHours(3);
            retSource.Add(new EventDetails
            {
                EventStart     = UtilHelper.ConvertDateToSqlDate(eventDate),
                EventEnd       = UtilHelper.ConvertDateToSqlDate(eventDate.AddHours(1)),
                EventLocation  = "Excel centre - London UK",
                EventTitle     = "Developers Conference",
                EventId        = 5,
                Status         = "Declined",
                PhoneNumber    = "01234567890",
                Email          = "*****@*****.**",
                AdditionalInfo = "Dress code is required",
                JobPostId      = "4"
            });


            eventDate = eventDate.AddDays(3);
            retSource.Add(new EventDetails
            {
                EventStart     = UtilHelper.ConvertDateToSqlDate(eventDate),
                EventEnd       = UtilHelper.ConvertDateToSqlDate(eventDate.AddHours(1)),
                EventLocation  = "office abc - Riyah, KSA",
                EventTitle     = "Client meetup",
                EventId        = 6,
                Status         = "Accepted",
                PhoneNumber    = "01234567890",
                Email          = "*****@*****.**",
                AdditionalInfo = "Dress code is required",
                JobPostId      = "5"
            });

            return(retSource);
        }
Ejemplo n.º 27
0
 public override void Init()
 {
     slider = UtilHelper.Find <Slider>(transform, "Slider");
 }
Ejemplo n.º 28
0
        private void GetToolbarItemsFromXml(XPathNavigator node, List <McToolbarItem> itemsCollection)
        {
            foreach (XPathNavigator node1 in node.SelectChildren(string.Empty, string.Empty))
            {
                McToolbarItem mcToolbarItem1 = new McToolbarItem();
                switch (node1.Name)
                {
                case "Text":
                    mcToolbarItem1.ItemType = McToolbarItemType.Text;
                    break;

                case "Splitter":
                    mcToolbarItem1.ItemType = McToolbarItemType.Splitter;
                    break;

                case "Button":
                    mcToolbarItem1.ItemType = McToolbarItemType.Button;
                    break;

                case "Menu":
                    mcToolbarItem1.ItemType = McToolbarItemType.Menu;
                    break;

                case "SplitButton":
                    mcToolbarItem1.ItemType = McToolbarItemType.SplitButton;
                    break;

                default:
                    throw new NotSupportedException(string.Format("Unknown nodeType: {0}", (object)node.Name));
                }
                string                attribute1          = node1.GetAttribute("id", string.Empty);
                string                attribute2          = node1.GetAttribute("text", string.Empty);
                string                attribute3          = node1.GetAttribute("imageUrl", string.Empty);
                string                attribute4          = node1.GetAttribute("cssClass", string.Empty);
                string                attribute5          = node1.GetAttribute("align", string.Empty);
                string                attribute6          = node1.GetAttribute("handler", string.Empty);
                string                attribute7          = node1.GetAttribute("commandName", string.Empty);
                string                attribute8          = node1.GetAttribute("itemSplitter", string.Empty);
                string                attribute9          = node1.GetAttribute("tooltip", string.Empty);
                string                attribute10         = node1.GetAttribute("permissions", string.Empty);
                McToolbarItemAlign    toolbarItemAlign    = McToolbarItemAlign.Left;
                McToolbarItemSplitter toolbarItemSplitter = McToolbarItemSplitter.None;
                if (attribute5 != string.Empty)
                {
                    try
                    {
                        toolbarItemAlign = (McToolbarItemAlign)Enum.Parse(typeof(McToolbarItemAlign), attribute5);
                    }
                    catch
                    {
                        throw;
                    }
                }
                if (attribute8 != string.Empty)
                {
                    try
                    {
                        toolbarItemSplitter = (McToolbarItemSplitter)Enum.Parse(typeof(McToolbarItemSplitter), attribute8);
                    }
                    catch
                    {
                        throw;
                    }
                }
                mcToolbarItem1.Id   = attribute1;
                mcToolbarItem1.Text = UtilHelper.GetResFileString(attribute2);
                if (attribute3 != string.Empty && (mcToolbarItem1.ItemType == McToolbarItemType.Button || mcToolbarItem1.ItemType == McToolbarItemType.SplitButton || mcToolbarItem1.ItemType == McToolbarItemType.Menu))
                {
                    mcToolbarItem1.CssClass += "x-btn-wrap x-btn x-btn-text-icon ";
                }
                mcToolbarItem1.ImageUrl  = this.ResolveClientUrl(attribute3);
                mcToolbarItem1.CssClass += attribute4;
                mcToolbarItem1.ItemAlign = toolbarItemAlign;
                mcToolbarItem1.Handler   = attribute6;
                mcToolbarItem1.Tooltip   = UtilHelper.GetResFileString(attribute9);
                CommandParameters           cp         = new CommandParameters(attribute7);
                Dictionary <string, string> dictionary = new Dictionary <string, string>();
                dictionary.Add("GridId", this.GridId);
                dictionary.Add("GridClientId", this.GridClientId);
                dictionary.Add("permissions", attribute10);
                if (!string.IsNullOrEmpty(this.ContainerId))
                {
                    dictionary.Add("ContainerId", this.ContainerId);
                }
                cp.CommandArguments = dictionary;
                bool isEnabled = true;
                if (attribute7 != string.Empty)
                {
                    string str = CommandManager.GetCurrent(this.Page).AddCommand(this.ClassName, this.ViewName, this.PlaceName, cp, out isEnabled);
                    dictionary.Add("CommandManagerScript", str);
                    cp.CommandArguments    = dictionary;
                    mcToolbarItem1.Params  = cp.ToString();
                    mcToolbarItem1.Handler = "defaultToolbarOnClick";
                }
                if (mcToolbarItem1.ItemType == McToolbarItemType.Menu || mcToolbarItem1.ItemType == McToolbarItemType.SplitButton)
                {
                    if (node1.SelectChildren(string.Empty, string.Empty).Count > 0)
                    {
                        this.GetToolbarItemsFromXml(node1, mcToolbarItem1.Items);
                        if (mcToolbarItem1.Items.Count == 0)
                        {
                            continue;
                        }
                    }
                    else
                    {
                        continue;
                    }
                }
                if (isEnabled && (toolbarItemSplitter == McToolbarItemSplitter.Both || toolbarItemSplitter == McToolbarItemSplitter.Left))
                {
                    McToolbarItem mcToolbarItem2 = new McToolbarItem(McToolbarItemType.Splitter);
                    mcToolbarItem2.ItemAlign = toolbarItemAlign;
                    itemsCollection.Add(mcToolbarItem2);
                }
                if (isEnabled)
                {
                    itemsCollection.Add(mcToolbarItem1);
                }
                if (isEnabled && (toolbarItemSplitter == McToolbarItemSplitter.Both || toolbarItemSplitter == McToolbarItemSplitter.Right))
                {
                    McToolbarItem mcToolbarItem2 = new McToolbarItem(McToolbarItemType.Splitter);
                    mcToolbarItem2.ItemAlign = toolbarItemAlign;
                    itemsCollection.Add(mcToolbarItem2);
                }
            }
        }
Ejemplo n.º 29
0
        /// <summary>
        /// 电池片补片操作。
        /// </summary>
        /// <remarks>
        /// 操作名称:<see cref="ACTIVITY_FIELD_VALUES.FIELD_ACTIVITY_PATCH"/>。
        /// </remarks>
        /// <param name="dsParams">包含补片信息的数据集对象。</param>
        /// <returns>包含结果数据的数据集对象。</returns>
        public DataSet LotPatch(DataSet dsParams)
        {
            DataSet       dsReturn = new DataSet();
            DbConnection  dbConn   = null;
            DbTransaction dbTran   = null;

            try
            {
                dbConn = db.CreateConnection();
                dbConn.Open();
                dbTran = dbConn.BeginTransaction();
                //参数数据。
                if (dsParams == null ||
                    !dsParams.Tables.Contains(TRANS_TABLES.TABLE_PARAM) ||                              //存放附加参数数据
                    !dsParams.Tables.Contains(WIP_TRANSACTION_FIELDS.DATABASE_TABLE_NAME))              //存放操作数据
                {
                    ReturnMessageUtils.AddServerReturnMessage(dsReturn, "传入参数不正确,请检查。");
                    return(dsReturn);
                }

                DataTable dtParams      = dsParams.Tables[TRANS_TABLES.TABLE_PARAM];                    //存放附加参数数据
                DataTable dtTransaction = dsParams.Tables[WIP_TRANSACTION_FIELDS.DATABASE_TABLE_NAME];  //存放操作数据
                Hashtable htTransaction = FanHai.Hemera.Share.Common.CommonUtils.ConvertToHashtable(dtTransaction);
                Hashtable htParams      = FanHai.Hemera.Share.Common.CommonUtils.ConvertToHashtable(dtParams);
                string    opEditTime    = Convert.ToString(htParams[COMMON_FIELDS.FIELD_COMMON_EDIT_TIME]); //操作时编辑时间
                string    lotKey        = Convert.ToString(htTransaction[WIP_TRANSACTION_FIELDS.FIELD_PIECE_KEY]);
                string    editTimeZone  = Convert.ToString(htTransaction[WIP_TRANSACTION_FIELDS.FIELD_EDIT_TIMEZONE_KEY]);
                string    editor        = Convert.ToString(htTransaction[WIP_TRANSACTION_FIELDS.FIELD_EDITOR]);
                double    leftQty       = Convert.ToDouble(htTransaction[WIP_TRANSACTION_FIELDS.FIELD_QUANTITY_OUT]);
                string    activity      = Convert.ToString(htTransaction[WIP_TRANSACTION_FIELDS.FIELD_ACTIVITY]);
                //操作动作必须是 PATCH
                if (activity != ACTIVITY_FIELD_VALUES.FIELD_ACTIVITY_PATCH)
                {
                    ReturnMessageUtils.AddServerReturnMessage(dsReturn, "传入参数的补片操作动作不正确,请检查。");
                    return(dsReturn);
                }
                //如果数据集中包含名称WIP_PATCH_FIELDS.DATABASE_TABLE_NAME的数据表对象。
                if (dsParams.Tables.Contains(WIP_PATCH_FIELDS.DATABASE_TABLE_NAME))
                {
                    string transactionKey              = UtilHelper.GenerateNewKey(0);
                    string sql                         = string.Empty;
                    double sumPatchedQty               = 0;
                    WIP_TRANSACTION_FIELDS wipFields   = new WIP_TRANSACTION_FIELDS();
                    WIP_PATCH_FIELDS       patchFields = new WIP_PATCH_FIELDS();
                    DataTable dtPatch                  = dsParams.Tables[WIP_PATCH_FIELDS.DATABASE_TABLE_NAME]; //存放补片明细数据
                    //遍历批次的报废数据。
                    for (int i = 0; i < dtPatch.Rows.Count; i++)
                    {
                        DataRow   drPatch         = dtPatch.Rows[i];
                        Hashtable htPatch         = CommonUtils.ConvertRowToHashtable(drPatch);
                        string    patchedLotKey   = Convert.ToString(htPatch[WIP_PATCH_FIELDS.FIELD_PATCHED_LOT_KEY]);
                        double    patchedQuantity = Convert.ToDouble(htPatch[WIP_PATCH_FIELDS.FIELD_PATCH_QUANTITY]);
                        sumPatchedQty += patchedQuantity;   //总的补片数量。
                        int isOnlyPatch = Convert.ToInt32(htPatch[WIP_PATCH_FIELDS.FIELD_IS_ONLY_PATCHED]);
                        //获取被补片批次的信息
                        DataSet dsPatchLotInfo = LotManagement.GetLotBasicInfo(db, dbTran, patchedLotKey);
                        DataRow drPatchLotInfo = dsPatchLotInfo.Tables[0].Rows[0];
                        double  quantityIn     = Convert.ToDouble(drPatchLotInfo[POR_LOT_FIELDS.FIELD_QUANTITY]);
                        //isOnlyPatch=0 先报废后补片,所以数量不需要改变。isOnlyPatch=1 仅做补片。
                        double quantityOut           = isOnlyPatch == 0? quantityIn: quantityIn + patchedQuantity;
                        string enterpriseKey         = Convert.ToString(drPatchLotInfo[POR_LOT_FIELDS.FIELD_ROUTE_ENTERPRISE_VER_KEY]);
                        string enterpriseName        = Convert.ToString(drPatchLotInfo[POR_ROUTE_ENTERPRISE_VER_FIELDS.FIELD_ENTERPRISE_NAME]);
                        string routeKey              = Convert.ToString(drPatchLotInfo[POR_LOT_FIELDS.FIELD_CUR_ROUTE_VER_KEY]);
                        string routeName             = Convert.ToString(drPatchLotInfo[POR_ROUTE_ROUTE_VER_FIELDS.FIELD_ROUTE_NAME]);
                        string stepKey               = Convert.ToString(drPatchLotInfo[POR_LOT_FIELDS.FIELD_CUR_STEP_VER_KEY]);
                        string stepName              = Convert.ToString(drPatchLotInfo[POR_ROUTE_STEP_FIELDS.FIELD_ROUTE_STEP_NAME]);
                        string workOrderKey          = Convert.ToString(drPatchLotInfo[POR_LOT_FIELDS.FIELD_WORK_ORDER_KEY]);
                        string stateFlag             = Convert.ToString(drPatchLotInfo[POR_LOT_FIELDS.FIELD_STATE_FLAG]);
                        string reworkFlag            = Convert.ToString(drPatchLotInfo[POR_LOT_FIELDS.FIELD_IS_REWORKED]);
                        string lineKey               = Convert.ToString(drPatchLotInfo[POR_LOT_FIELDS.FIELD_CUR_PRODUCTION_LINE_KEY]);
                        string lineName              = Convert.ToString(drPatchLotInfo[POR_LOT_FIELDS.FIELD_OPR_LINE]);
                        string edcInsKey             = Convert.ToString(drPatchLotInfo[POR_LOT_FIELDS.FIELD_EDC_INS_KEY]);
                        string equipmentKey          = Convert.ToString(drPatchLotInfo[EMS_EQUIPMENTS_FIELDS.FIELD_EQUIPMENT_KEY]);
                        string patchedTransactionKey = UtilHelper.GenerateNewKey(0);
                        AddWIPLot(dbTran, patchedTransactionKey, patchedLotKey);
                        //更新被补片批次的数量
                        sql = string.Format(@"UPDATE POR_LOT 
                                            SET QUANTITY={0},EDITOR='{1}',EDIT_TIME=GETDATE(),EDIT_TIMEZONE='{2}'
                                            WHERE LOT_KEY='{3}'",
                                            quantityOut,
                                            editor.PreventSQLInjection(),
                                            editTimeZone.PreventSQLInjection(),
                                            patchedLotKey.PreventSQLInjection());
                        db.ExecuteNonQuery(dbTran, CommandType.Text, sql);
                        Hashtable htPatchedTransaction = new Hashtable(htTransaction);
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_PIECE_KEY]       = patchedLotKey;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_ENTERPRISE_KEY]  = enterpriseKey;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_ENTERPRISE_NAME] = enterpriseName;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_ROUTE_KEY]       = routeKey;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_ROUTE_NAME]      = routeName;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_STEP_KEY]        = stepKey;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_STEP_NAME]       = stepName;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_WORK_ORDER_KEY]  = workOrderKey;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_STATE_FLAG]      = stateFlag;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_REWORK_FLAG]     = reworkFlag;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_LINE_KEY]        = lineKey;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_OPR_LINE]        = lineName;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_OPR_LINE_PRE]    = lineName;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_EDC_INS_KEY]     = edcInsKey;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_EQUIPMENT_KEY]   = equipmentKey;
                        //插入报废记录。
                        //isOnlyPatch=0 先报废后补片。isOnlyPatch=1 仅做补片。
                        if (isOnlyPatch == 0)
                        {
                            string  scrapTransaction = UtilHelper.GenerateNewKey(0);
                            DataSet dsScrapParams    = new DataSet();
                            htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_QUANTITY_IN]     = quantityIn;
                            htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_QUANTITY_OUT]    = quantityIn - patchedQuantity;
                            htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_TRANSACTION_KEY] = scrapTransaction;
                            htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_ACTIVITY]        = ACTIVITY_FIELD_VALUES.FIELD_ACTIVITY_CELLSCRAP;
                            DataTable dtScrapTransaction = CommonUtils.ParseToDataTable(htPatchedTransaction);
                            dtScrapTransaction.TableName = WIP_TRANSACTION_FIELDS.DATABASE_TABLE_NAME;
                            dsScrapParams.Tables.Add(dtScrapTransaction);
                            DataTable dtScrap = CommonUtils.CreateDataTable(new WIP_SCRAP_FIELDS());
                            DataRow   drScrap = dtScrap.NewRow();
                            drScrap[WIP_SCRAP_FIELDS.FIELD_DESCRIPTION]        = drPatch[WIP_PATCH_FIELDS.FIELD_DESCRIPTION];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_EDIT_TIME]          = drPatch[WIP_PATCH_FIELDS.FIELD_EDIT_TIME];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_EDIT_TIMEZONE_KEY]  = drPatch[WIP_PATCH_FIELDS.FIELD_EDIT_TIMEZONE_KEY];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_EDITOR]             = drPatch[WIP_PATCH_FIELDS.FIELD_EDITOR];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_ENTERPRISE_KEY]     = drPatch[WIP_PATCH_FIELDS.FIELD_ENTERPRISE_KEY];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_ENTERPRISE_NAME]    = drPatch[WIP_PATCH_FIELDS.FIELD_ENTERPRISE_NAME];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_REASON_CODE_CLASS]  = drPatch[WIP_PATCH_FIELDS.FIELD_REASON_CODE_CLASS];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_REASON_CODE_KEY]    = drPatch[WIP_PATCH_FIELDS.FIELD_REASON_CODE_KEY];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_REASON_CODE_NAME]   = drPatch[WIP_PATCH_FIELDS.FIELD_REASON_CODE_NAME];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_RESPONSIBLE_PERSON] = drPatch[WIP_PATCH_FIELDS.FIELD_RESPONSIBLE_PERSON];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_ROUTE_KEY]          = drPatch[WIP_PATCH_FIELDS.FIELD_ROUTE_KEY];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_ROUTE_NAME]         = drPatch[WIP_PATCH_FIELDS.FIELD_ROUTE_NAME];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_SCRAP_QUANTITY]     = drPatch[WIP_PATCH_FIELDS.FIELD_PATCH_QUANTITY];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_STEP_KEY]           = drPatch[WIP_PATCH_FIELDS.FIELD_STEP_KEY];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_STEP_NAME]          = drPatch[WIP_PATCH_FIELDS.FIELD_STEP_NAME];
                            drScrap[WIP_SCRAP_FIELDS.FIELD_TRANSACTION_KEY]    = scrapTransaction;
                            dtScrap.Rows.Add(drScrap);
                            dsScrapParams.Tables.Add(dtScrap);
                            LotScrap(dsScrapParams, dbTran);
                        }
                        //插入被补片批次的操作记录
                        //isOnlyPatch=0 先报废后补片。isOnlyPatch=1 仅做补片。
                        if (isOnlyPatch == 0)
                        {
                            htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_QUANTITY_IN]  = quantityIn - patchedQuantity;
                            htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_QUANTITY_OUT] = quantityIn;
                        }
                        else
                        {
                            htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_QUANTITY_IN]  = quantityIn;
                            htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_QUANTITY_OUT] = quantityIn + patchedQuantity;
                        }
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_TRANSACTION_KEY] = patchedTransactionKey;
                        htPatchedTransaction[WIP_TRANSACTION_FIELDS.FIELD_ACTIVITY]        = ACTIVITY_FIELD_VALUES.FIELD_ACTIVITY_PATCHED;
                        sql = DatabaseTable.BuildInsertSqlStatement(wipFields, htPatchedTransaction, null);
                        db.ExecuteNonQuery(dbTran, CommandType.Text, sql);
                        //插入一笔批次补片明细数据
                        //补片操作记录主键。
                        if (!htPatch.ContainsKey(WIP_PATCH_FIELDS.FIELD_TRANSACTION_KEY))
                        {
                            htPatch.Add(WIP_PATCH_FIELDS.FIELD_TRANSACTION_KEY, transactionKey);
                        }
                        htPatch[WIP_PATCH_FIELDS.FIELD_TRANSACTION_KEY] = transactionKey;
                        //被补片批次操作记录主键
                        if (!htPatch.ContainsKey(WIP_PATCH_FIELDS.FIELD_PATCHED_TRANSACTION_KEY))
                        {
                            htPatch.Add(WIP_PATCH_FIELDS.FIELD_PATCHED_TRANSACTION_KEY, patchedTransactionKey);
                        }
                        htPatch[WIP_PATCH_FIELDS.FIELD_PATCHED_TRANSACTION_KEY] = patchedTransactionKey;
                        //重置补片明细的编辑时间为当前时间。
                        htPatch[WIP_PATCH_FIELDS.FIELD_EDIT_TIME] = null;
                        sql = DatabaseTable.BuildInsertSqlStatement(patchFields, htPatch, null);
                        db.ExecuteNonQuery(dbTran, CommandType.Text, sql);
                    }

                    AddWIPLot(dbTran, transactionKey, lotKey);
                    //获取组件补片批次当前数量
                    sql = string.Format("SELECT QUANTITY FROM POR_LOT WHERE LOT_KEY='{0}'", lotKey.PreventSQLInjection());
                    double quantity = Convert.ToDouble(db.ExecuteScalar(CommandType.Text, sql));
                    if (quantity < sumPatchedQty)
                    {
                        ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Format("组件补片批次当前实际数量[{0}]小于补片数量[{1}],请确认。", quantity, sumPatchedQty));
                        dbTran.Rollback();
                        return(dsReturn);
                    }
                    //更新批次数量。
                    sql = string.Format(@"UPDATE POR_LOT 
                                        SET QUANTITY={0},EDITOR='{1}',EDIT_TIME=GETDATE(),EDIT_TIMEZONE='{2}',DELETED_TERM_FLAG={3}
                                        WHERE LOT_KEY='{4}'",
                                        quantity - sumPatchedQty,
                                        editor.PreventSQLInjection(),
                                        editTimeZone.PreventSQLInjection(),
                                        (quantity - sumPatchedQty) > 0 ? 0 : 1,
                                        lotKey.PreventSQLInjection());
                    db.ExecuteNonQuery(dbTran, CommandType.Text, sql);
                    //向WIP_TRANSACTION表插入批次补片的操作记录。
                    if (!htTransaction.ContainsKey(WIP_TRANSACTION_FIELDS.FIELD_TRANSACTION_KEY))
                    {
                        htTransaction.Add(WIP_TRANSACTION_FIELDS.FIELD_TRANSACTION_KEY, transactionKey);
                    }
                    htTransaction[WIP_TRANSACTION_FIELDS.FIELD_TRANSACTION_KEY] = transactionKey;
                    sql = DatabaseTable.BuildInsertSqlStatement(wipFields, htTransaction, null);
                    db.ExecuteNonQuery(dbTran, CommandType.Text, sql);
                }
                dbTran.Commit();
                ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Empty);
            }
            catch (Exception ex)
            {
                ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
                LogService.LogError("LotPatch Error: " + ex.Message);
                dbTran.Rollback();
            }
            finally
            {
                dbConn.Close();
            }
            return(dsReturn);
        }
Ejemplo n.º 30
0
        public ActionResult SavePeople([Bind(Include = "Id,LastName,FirstName,BirthDate,PhotoPeople,ImageIsEmpty")] PeopleViewModel peopleModel)
        {
            bool saveCreateMode = (peopleModel.Id == 0) ? true : false;

            if (ModelState.IsValid)
            {
                try
                {
                    // проверка на ввод Даты рождения (возраст от 5 до 150 лет)
                    if (!UtilHelper.CheckBirthDate(peopleModel.BirthDate))
                    {
                        ModelState.AddModelError("BirthDate", "Возраст может быть от 5 до 150 лет! Введите корректную дату рождения");
                        return(View("CreateEditPeople", peopleModel));
                    }

                    // если изменяем запись
                    if (!saveCreateMode && peopleModel.PhotoPeople == null)
                    {
                        // если фото было удалено пользователем
                        if (peopleModel.ImageIsEmpty)
                        {
                            peopleModel.PhotoPeople   = null;
                            peopleModel.PhotoMIMEType = "";
                        }
                        else
                        {
                            PeopleViewModel tmpPeopleModel = repository.GetPeople(peopleModel.Id);
                            peopleModel.PhotoPeople   = tmpPeopleModel.PhotoPeople;
                            peopleModel.PhotoMIMEType = tmpPeopleModel.PhotoMIMEType;
                        }
                    }
                    else
                    {
                        if (peopleModel.PhotoPeople != null && peopleModel.PhotoPeople.ContentLength > 0)
                        {
                            peopleModel.PhotoMIMEType = peopleModel.PhotoPeople.ContentType;
                        }
                        else
                        {
                            peopleModel.PhotoMIMEType = "";
                        }
                    }

                    repository.SavePeople(peopleModel);
                    if (saveCreateMode)
                    {
                        Logger.logger.Info(String.Format("Добавлен человек:\n LastName={0}, FirstName={1}, BirthDate={2}",
                                                         peopleModel.LastName, peopleModel.FirstName, peopleModel.BirthDateStr));
                    }
                    else
                    {
                        Logger.logger.Info(String.Format("Изменен человек:\n Id={0}, LastName={1}, FirstName={2}, BirthDate={3}",
                                                         peopleModel.Id, peopleModel.LastName, peopleModel.FirstName, peopleModel.BirthDateStr));
                    }

                    return(RedirectToAction("Index"));
                }
                catch (Exception e)
                {
                    Logger.LogException(e);
                }
            }
            else
            {
                return(View("CreateEditPeople", peopleModel));
            }

            return(RedirectToAction("CreateEditPeople", peopleModel.Id));
        }