예제 #1
0
        /// <summary>
        /// 设置库位绑定图形控件
        /// </summary>
        /// <param name="locationNum">库位编号</param>
        /// <param name="bindTag">绑定控件tag</param>
        /// <returns></returns>
        public static string SetLoctionBind(string locationNum, string bindTag)
        {
            string returnStr = "";

            try
            {
                string sqlStr = string.Format(@"update base_lgpos t
                            set t.lgpos_location='{2}'
                            where t.company_num='{0}' and t.lgpos_id='{1}'", companyNum, locationNum, bindTag);
                int    x      = DbControler.ExecuteSql(sqlStr);
                if (x != 1)
                {
                    throw new Exception("location not exists!");
                }
                returnStr = "S";
            }
            catch (Exception ex)
            {
                returnStr = ex.Message;
            }
            return(returnStr);
        }